[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:                           
---------------------+------------------------------------------------------
 {{{
 Removing obsolete dictionary files:
  * No PostgreSQL clusters exist; see "man pg_createcluster"
 Setting up postgresql-9.3 (9.3.2-1.pgdg12.4+1~precise) ...
 Creating new cluster 9.3/main ...
   config /etc/postgresql/9.3/main
   data   /var/lib/postgresql/9.3/main
   locale C
   port   5432
 update-alternatives: using
 /usr/share/postgresql/9.3/man/man1/postmaster.1.gz to provide
 /usr/share/man/man1/postmaster.1.gz (postmaster.1.gz) in auto mode.
  * Starting PostgreSQL 9.3 database server
    ...done.
 }}}

 and then:
 {{{
 Processing triggers for menu ...
 ALTER ROLE
 createdb: database creation failed: ERROR:  new encoding (UTF8) is
 incompatible with the encoding of the template database (SQL_ASCII)
 HINT:  Use the same encoding as in the template database, or use template0
 as template.
 psql: FATAL:  database "user" does not exist
 }}}

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