Re: [GENERAL] initdb with lc-collate=C

2011-12-13 Thread Scot Kreienkamp
m -Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane Sent: Tuesday, December 13, 2011 12:00 AM To: Scot Kreienkamp Cc: Adrian Klaver; Postgres General (pgsql-general@postgresql.org) Subject: Re: [GENERAL] initdb

Re: [GENERAL] initdb with lc-collate=C

2011-12-12 Thread Tom Lane
Scot Kreienkamp writes: > There wasn't any output from the initdb other than OK. > [root@dvrv5030 9.1]# /etc/init.d/postgresql-9.1 initdb --lc-collate=C > Initializing database: [ OK ] Um. This isn't running initdb: this is running the package's initscript a

Re: [GENERAL] initdb with lc-collate=C

2011-12-12 Thread Scot Kreienkamp
NERAL] initdb with lc-collate=C On 12/12/2011 12:37 PM, Scot Kreienkamp wrote: > Nope no clusters. I never got past the initial install and configure. > > All I did was install, initdb, alter a few things in postgresql.conf (nothing > relating to locale) and pg_hba.conf, start postgr

Re: [GENERAL] initdb with lc-collate=C

2011-12-12 Thread Adrian Klaver
On 12/12/2011 12:37 PM, Scot Kreienkamp wrote: Nope no clusters. I never got past the initial install and configure. All I did was install, initdb, alter a few things in postgresql.conf (nothing relating to locale) and pg_hba.conf, start postgres using the init script, and run the query

Re: [GENERAL] initdb with lc-collate=C

2011-12-12 Thread Adrian Klaver
On 12/12/2011 12:37 PM, Scot Kreienkamp wrote: Nope no clusters. I never got past the initial install and configure. All I did was install, initdb, alter a few things in postgresql.conf (nothing relating to locale) and pg_hba.conf, start postgres using the init script, and run the query

Re: [GENERAL] initdb with lc-collate=C

2011-12-12 Thread Scot Kreienkamp
. Scot Kreienkamp Senior Systems Engineer skre...@la-z-boy.com -Original Message- From: Adrian Klaver [mailto:adrian.kla...@gmail.com] Sent: Monday, December 12, 2011 3:26 PM To: Scot Kreienkamp Cc: Postgres General (pgsql-general@postgresql.org) Subject: Re: [GENERAL] initdb with lc-collate

Re: [GENERAL] initdb with lc-collate=C

2011-12-12 Thread Adrian Klaver
On 12/12/2011 12:15 PM, Adrian Klaver wrote: On 12/12/2011 10:49 AM, Scot Kreienkamp wrote: Hey guys, In PG 8.x, when I did an initdb with --lc-collate=c it was always effective in setting it server wide so it would apply to all databases. However, in 9.1.2, when I run initdb like so: /etc/init

Re: [GENERAL] initdb with lc-collate=C

2011-12-12 Thread Adrian Klaver
On 12/12/2011 10:49 AM, Scot Kreienkamp wrote: Hey guys, In PG 8.x, when I did an initdb with --lc-collate=c it was always effective in setting it server wide so it would apply to all databases. However, in 9.1.2, when I run initdb like so: /etc/init.d/postgresql-9.1 initdb --lc-collate=C, it do

[GENERAL] initdb with lc-collate=C

2011-12-12 Thread Scot Kreienkamp
Hey guys, In PG 8.x, when I did an initdb with --lc-collate=c it was always effective in setting it server wide so it would apply to all databases. However, in 9.1.2, when I run initdb like so: /etc/init.d/postgresql-9.1 initdb --lc-collate=C, it doesn't seem to have any effect. [root@dvrv50