Change LC_CTYPE for PostgreSQL and PostGIS use

postgresql locale postgis geodjango
a.m. picture a.m. · Dec 2, 2011 · Viewed 17.4k times · Source

So I'm walking through the GeoDjango tutorial and I'm stuck on this error message:

postgres@lucid32:~$ createdb -E UTF8 template_postgis
createdb: database creation failed: ERROR:  encoding UTF8 does not match locale en_US
DETAIL:  The chosen LC_CTYPE setting requires encoding LATIN1.

I've googled and read some Ubuntu docs but to no avail. Any insight would be greatly appreciated!

I'm using the default Vagrant Box lucid 32, for testing out my setup.

Answer

Peter Eisentraut picture Peter Eisentraut · Dec 2, 2011

It is better to just specify the locale for the database and have the encoding be figured out from that. So use something like

createdb --locale=en_US.utf8 template_postgis

Related questions

How do I know if my PostgreSQL server is using the "C" locale?

I'm trying to optimize my PostgreSQL 8.3 DB tables to the best of my ability, and I'm unsure if I need to use varchar_pattern_ops for certain columns where I'm performing a LIKE against the first N characters of a …

Read More
Configuring Locales on Linux for PostgreSQL

I'm having trouble getting a particular database set up and running. I'm trying to restore a postgreSQL dump I got from somebody else. I've tried a few methods to no avail. Straight from pg_restore pg_restore -C -d postgres …

Read More
Change PostgreSQL date language from request

I'm kind of new to PostgreSQL and I'm trying to change the locale of the date function results, to get the result of to_char(my_date, 'Month') in another language. Here are some of my settings : $> show lc_…

Read More