search

cyclestreets / nominatim-install

Bash script to install Nominatim
67 stars 31 forks source link

createdb: database creation failed: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII) #10

Closed Grovespaz closed 9 years ago

Grovespaz commented 10 years ago

When importing europe, I see the following:

2014-03-21 13:02:14 (43.2 MB/s) - 'data/europe-latest.osm.pbf' saved [12987620407/12987620407]

NOTICE:  database "nominatim" does not exist, skipping
DROP DATABASE
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.
ERROR: Error executing external command: createdb -E UTF-8 -p 5432 nominatim
psql: FATAL:  database "nominatim" does not exist

I run in a fresh docker container running ubuntu.

bond-os commented 10 years ago

Setting system locales to en_us.utf8 and this http://www.pebra.net/blog/2013/06/10/when-struggling-with-postgresql-and-utf8-slash-latin/ helped in my case

mvl22 commented 9 years ago

Thanks for reporting this. I used both solutions at:

http://askubuntu.com/a/229512 https://github.com/cyclestreets/cyclescape-chef/issues/25#issuecomment-70081469

which should force a UTF8 environment.

icemagno commented 6 years ago

Comming from google. Thanks for this.