Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
Grovespaz opened this issue Mar 21, 2014 · 3 comments

Comments

@Grovespaz
Copy link

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
Copy link

bond-os commented May 18, 2014

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 mvl22 closed this as completed in 9f9d577 May 17, 2015
@mvl22
Copy link
Member

mvl22 commented May 17, 2015

Thanks for reporting this. I used both solutions at:

http://askubuntu.com/a/229512
cyclestreets/cyclescape-chef#25 (comment)

which should force a UTF8 environment.

@icemagno
Copy link

Comming from google. Thanks for this.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

4 participants