Re: initdb with lc-collate=C

Scot Kreienkamp <SKreien(at)la-z-boy(dot)com> writes:
> There wasn't any output from the initdb other than OK.
> [root(at)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