Opened 7 years ago

Closed 7 years ago

#983 closed defect (fixed)

chroot build method: postgis fails to create databases

Reported by: kalxas Owned by: live-demo@…
Priority: critical Milestone: OSGeoLive6.0RC1
Component: OSGeoLive Keywords: 6.0
Cc: live-demo@…

Description

as per http://aiolos.survey.ntua.gr/gisvm/dev/osgeo-live-mini-build8731-log.tar.gz

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. createlang: could not connect to database template_postgis: FATAL: database "template_postgis" does not exist UPDATE 0 psql: FATAL: database "template_postgis" does not exist psql: FATAL: database "template_postgis" does not exist Finished: ./install_postgis.sh

Change history (3)

comment:1 Changed 7 years ago by darkblueb

I am puzzled by the locale theory to explain this new failure.. As an experiment, I installed a new XUbuntu 12.04 into a VM, then asked for locale

reuse@osgeolive-base:~/gisvm/bin$ locale
LANG=en_US.UTF-8
LANGUAGE=en_US:en
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=

comment:2 Changed 7 years ago by darkblueb

and here is the results on a fresh base after init,

reuse@osgeolive-base:~/gisvm/bin$ sudo -u postgres createuser --superuser $USER_NAME
reuse@osgeolive-base:~/gisvm/bin$ psql
psql: FATAL:  database "reuse" does not exist
reuse@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)

comment:3 Changed 7 years ago by kalxas

Resolution: fixed
Status: newclosed

fixed in build 8833

Note: See TracTickets for help on using tickets.