| 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: | Whole Thread | Raw Message | 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 |