initdb - encoding question

From: "Josh Harrison" <joshques(at)gmail(dot)com>
To: "Postgresql General" <pgsql-general(at)postgresql(dot)org>
Subject: initdb - encoding question
Date: 2007-12-03 17:51:27
Message-ID: 8d89ea1d0712030951yf51636fr63d0d3fcf15cb7a9@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi
Im tying to initialize the cluster using initdb and encoding 'UTF8'
initdb -E UTF8 -D /export/home/josh/postgres8.3/pgsql/data

But I get this error
The files belonging to this database system will be owned by user "josh".
This user must also own the server process.

The database cluster will be initialized with locales
COLLATE: en_CA.ISO8859-1
CTYPE: en_CA.ISO8859-1
MESSAGES: C
MONETARY: en_CA.ISO8859-1
NUMERIC: en_CA.ISO8859-1
TIME: C
initdb: encoding mismatch
The encoding you selected (UTF8) and the encoding that the
selected locale uses (LATIN1) do not match. This would lead to
misbehavior in various character string processing functions.
Rerun initdb and either do not specify an encoding explicitly,
or choose a matching combination.

Why do I get this error? How can I solve this?
Thanks
josh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2007-12-03 17:51:48 stored procedures and dynamic queries
Previous Message Scott Marlowe 2007-12-03 17:43:05 Re: "relation deleted while in use" encountered with Postgresql 8.0.8