createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8
Date: 2008-04-11 13:59:56
Message-ID: 373099.90346.qm@web25804.mail.ukl.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When trying to specify an encoding to initdb I get:

createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8

8.2 Used to let us create any encoding in initdb. I see that it was in the todo to make this change, but how do I create my database in LATIN encoding now?

Do I just change these lines in postgresql.conf:

lc_messages = 'en_GB.UTF-8' # locale for system error message
# strings
lc_monetary = 'en_GB.UTF-8' # locale for monetary formatting
lc_numeric = 'en_GB.UTF-8' # locale for number formatting
lc_time = 'en_GB.UTF-8' # locale for time formatting

Or do I have to do something else? The comments in the .conf file indicate that it's something else I need to change....

___________________________________________________________
Yahoo! For Good helps you make a difference

http://uk.promotions.yahoo.com/forgood/

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-04-11 14:34:06 Re: BD removed
Previous Message Stefan Sturm 2008-04-11 13:09:43 PostgreSQL Processes on a linux box