[Live-demo] [OSGeo] #983: chroot build method: postgis fails to create databases

OSGeo trac_osgeo at osgeo.org
Sun Aug 5 23:05:27 PDT 2012


#983: chroot build method: postgis fails to create databases
----------------------+-----------------------------------------------------
 Reporter:  kalxas    |       Owner:  live-demo@…              
     Type:  defect    |      Status:  new                      
 Priority:  critical  |   Milestone:  OSGeoLive6.0RC1          
Component:  LiveDVD   |    Keywords:  6.0                      
----------------------+-----------------------------------------------------

Comment(by darkblueb):

 and here is the results on a fresh base after init,
 {{{
 reuse at osgeolive-base:~/gisvm/bin$ sudo -u postgres createuser --superuser
 $USER_NAME
 reuse at osgeolive-base:~/gisvm/bin$ psql
 psql: FATAL:  database "reuse" does not exist
 reuse at osgeolive-base:~/gisvm/bin$ psql postgres
 psql (9.1.4)
 Type "help" for help.

 postgres=# \l
                                   List of databases
    Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access
 privileges
 -----------+----------+----------+-------------+-------------+-----------------------
  postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
  template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
 +
            |          |          |             |             |
 postgres=CTc/postgres
  template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
 +
            |          |          |             |             |
 postgres=CTc/postgres
 (3 rows)

 }}}

-- 
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/983#comment:2>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.


More information about the Osgeolive mailing list