[Live-demo] [OSGeo] #1279: PostgreSQL 9.3 template encoding

[OSGeo]

#1279: PostgreSQL 9.3 template encoding
---------------------+------------------------------------------------------
 Reporter:  kalxas   |       Owner:  live-demo@…              
     Type:  defect   |      Status:  new                      
 Priority:  blocker  |   Milestone:  OSGeoLive7.9             
Component:  LiveDVD  |    Keywords:                           
---------------------+------------------------------------------------------

Comment(by darkblueb):

 using base_stable_01 snapshot and running install_postgis.sh +
 load_gisdata.sh :

 {{{
 user at live-rc1:~$ cat /tmp/all_tables.txt
 List of databases
         Name        |  Owner   | Encoding |   Collate   |    Ctype    |
 Access privileges    |  Size   | Tablespace |                Description
 --------------------+----------+----------+-------------+-------------+-------------------------+---------+------------+--------------------------------------------
  52nSOS             | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 =Tc/postgres           +| 24 MB   | pg_default |
                     |          |          |             |             |
 postgres=CTc/postgres  +|         |            |
                     |          |          |             |             |
 user=CTc/postgres       |         |            |
  RASBASE            | root     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 67 MB   | pg_default |
  cartaro            | cartaro  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 20 MB   | pg_default |
  eoxserver_demo     | user     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 15 MB   | pg_default |
  geonode            | user     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 15 MB   | pg_default |
  mapbender3.0.0.2   | user     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 8097 kB | pg_default |
  natural_earth2     | user     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 82 MB   | pg_default |
  osm_local          | user     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 37 MB   | pg_default |
  petascopedb        | root     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 7673 kB | pg_default |
  pgrouting          | user     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 30 MB   | pg_default |
  postgres           | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 5754 kB | pg_default | default administrative connection database
  sahana             | sahana   | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 30 MB   | pg_default |
  template0          | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 =c/postgres            +| 5665 kB | pg_default | unmodifiable empty
 database
                     |          |          |             |             |
 postgres=CTc/postgres   |         |            |
  template1          | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 =c/postgres            +| 5665 kB | pg_default | default template for new
 databases
                     |          |          |             |             |
 postgres=CTc/postgres   |         |            |
  uf_basegrid_bamin  | user     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 1968 MB | pg_default |
  user               | user     | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 | 5890 kB | pg_default |
  v2.2_mapfishsample | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 =Tc/postgres           +| 10 MB   | pg_default |
                     |          |          |             |             |
 postgres=CTc/postgres  +|         |            |
                     |          |          |             |             |
 "www-data"=CTc/postgres |         |            |
 (17 rows)

 }}}

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