Re: [GENERAL] initdb - encoding question

2007-12-05 Thread Stephane Bortzmeyer
On Mon, Dec 03, 2007 at 12:51:27PM -0500, Josh Harrison [EMAIL PROTECTED] wrote a message of 63 lines which said: The encoding you selected (UTF8) and the encoding that the selected locale uses (LATIN1) do not match. Indeed. Rerun initdb and either do not specify an encoding explicitly,

Re: [GENERAL] initdb - encoding question

2007-12-05 Thread Peter Eisentraut
Am Montag, 3. Dezember 2007 schrieb Josh Harrison: initdb -E UTF8 -D /export/home/josh/postgres8.3/pgsql/data 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

Re: [GENERAL] initdb - encoding question

2007-12-05 Thread Peter Eisentraut
Am Montag, 3. Dezember 2007 schrieb Josh Harrison: initdb -E en_CA.utf-8 -D /export/home/sjothirajah/postgres8.3/pgsql/data gives this error initdb: en_CA.utf-8 is not a valid server encoding name The option name you want is --locale, not -E. -- Peter Eisentraut

Re: [GENERAL] initdb - encoding question

2007-12-04 Thread Josh Harrison
initdb -E en_CA.utf-8 -D /export/home/sjothirajah/postgres8.3/pgsql/data gives this error initdb: en_CA.utf-8 is not a valid server encoding name Thanks josh On Dec 3, 2007 1:01 PM, brian [EMAIL PROTECTED] wrote: Josh Harrison wrote: Hi Im tying to initialize the cluster using initdb and

[GENERAL] initdb - encoding question

2007-12-03 Thread Josh Harrison
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

Re: [GENERAL] initdb - encoding question

2007-12-03 Thread brian
Josh Harrison wrote: 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

Re: [GENERAL] initdb - encoding question

2007-12-03 Thread brian
Josh Harrison wrote: initdb -E en_CA.utf-8 -D /export/home/sjothirajah/postgres8.3/pgsql/data gives this error initdb: en_CA.utf-8 is not a valid server encoding name My bad. Use UTF-8. brian ---(end of broadcast)--- TIP 5: don't forget to