Re: initdb with lc-collate=C - Mailing list pgsql-general

From Tom Lane
Subject Re: initdb with lc-collate=C
Date
Msg-id 18898.1323752406@sss.pgh.pa.us
Whole thread Raw
In response to Re: initdb with lc-collate=C  (Scot Kreienkamp <SKreien@la-z-boy.com>)
Responses Re: initdb with lc-collate=C
List pgsql-general
Scot Kreienkamp <SKreien@la-z-boy.com> 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
and hoping it will pass the switch you supplied through to initdb.
If it doesn't, you'll get whatever locale is default in root's environment.

I gather from the package name that you're using Devrim's packages not
mine, so I don't know for sure what will happen here ... but I'm pretty
sure that that extra switch would *not* be honored in the Red Hat/Fedora
initscripts.

My suggestion for this would be to "su - postgres" and then run initdb
directly.

            regards, tom lane

pgsql-general by date:

Previous
From: Dong Han
Date:
Subject: Re: WAL file accumulation on log shipping primary node
Next
From: Dave Cramer
Date:
Subject: Re: WAL file accumulation on log shipping primary node