Unix Technical Forum

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

This is a discussion on Re: createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8 within the Pgsql General forums, part of the PostgreSQL category; --> This is sorted now chaps, I was missing a system locale. ta Glyn ----- Original Message ---- > From: ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > Pgsql General

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-12-2008, 02:05 AM
Glyn Astill
 
Posts: n/a
Default Re: createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8

This is sorted now chaps, I was missing a system locale.

ta
Glyn

----- Original Message ----
> From: Glyn Astill <glynastill@yahoo.co.uk>
> To: pgsql-general@postgresql.org
> Sent: Friday, 11 April, 2008 2:59:56 PM
> Subject: [GENERAL] createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_GB.UTF-8
>
> 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/
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>





__________________________________________________ _________
Yahoo! For Good helps you make a difference

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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 11:07 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com