psql db size summary: broken in recent builds

[hamish]

Hi,

this was working in earlier nightly builds, but no longer:

(setdown.sh)

## check how big the databases ended up
echo "Postgres database sizes:"
psql << EOF
SELECT pg_database.datname,
       pg_size_pretty(pg_database_size(pg_database.datname)) AS size
  FROM pg_database;
EOF

the error is:

Postgres database sizes:
psql: FATAL:  database "root" does not exist

?

it would be good to fix this asap as we deal with disc space issues.

thanks, Hamish

[wildintellect]

So it's trying to login to postgres with ident, which fails if the database is not specified or the user logging in doesn't have a db to match it's name.

Try

sudo -u postgres psql
OR
psql -d postgres (one above is more likely to work

[kalxas]

confirmed fixed in build 10635:

Postgres database sizes:
      datname       |  size   
--------------------+---------
 template1          | 5754 kB
 template0          | 5665 kB
 postgres           | 5754 kB
 user               | 5890 kB
 osm_local          | 38 MB
 pgrouting          | 30 MB
 sahana             | 30 MB
 mapbender3.0.0.2   | 8186 kB
 v2.2_mapfishsample | 10 MB
 52nSOS             | 24 MB
 RASBASE            | 67 MB
 petascopedb        | 7794 kB
 eoxserver_demo     | 15 MB
 cartaro            | 21 MB
 geonode            | 15 MB
 natural_earth2     | 82 MB
(16 rows)