Postgres Pro
Downloads
Home   >   mailing lists

ERROR: encoding LATIN9 does not match server's locale en_US - Mailing list pgsql-admin

From Arnau
Subject ERROR: encoding LATIN9 does not match server's locale en_US
Date
Msg-id 47F270CA.8040407@andromeiberica.com
Whole thread Raw
Responses Re: ERROR: encoding LATIN9 does not match server's locale en_US
List pgsql-admin
Tree view 
Hi all,

  Using PostgreSQL 8.3.0 I'm trying to do the following:

template1=# create database test with encoding='LATIN9';
ERROR:  encoding LATIN9 does not match server's locale en_US
DETAIL:  The server's LC_CTYPE setting requires encoding LATIN1.

  I've been looking into the documentation to fix this and the only way
I have found is to use initdb to recreate the cluster, Is there any
other option?

Thanks
--
Arnau

pgsql-admin by date:

Previous
From: "Benjamin Krajmalnik"
Date:
Subject: Re: connection problems
Next
From: Tom Lane
Date:
Subject: Re: ERROR: encoding LATIN9 does not match server's locale en_US