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 explicit

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 http://developer.postgres

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.ISO8

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 init

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 in

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 d

[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