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