[Live-demo] [OSGeo] #1189: psql db size summary: broken in recent builds

[OSGeo]

#1189: psql db size summary: broken in recent builds
---------------------+------------------------------------------------------
 Reporter:  hamish   |       Owner:  live-demo@…              
     Type:  defect   |      Status:  new                      
 Priority:  major    |   Milestone:  OSGeoLive7.0             
Component:  LiveDVD  |    Keywords:  pgsql, space             
---------------------+------------------------------------------------------
 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

-- 
Ticket URL: <https://trac.osgeo.org/osgeo/ticket/1189>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.