Re: FATAL error on launch

I could use some help.

I've just finished installing postgreSQL 7.3.1 on my PowerBook (Os
10.2.3). Everything appeared to be going fine until I tried to run it.
Below is what happens when ever I try to start (copied straight from
the terminal)

[TiBox:~] postgres% /Users/postgres/bin/pg_ctl start -D
/Users/postgres/data -o -i -l
postmaster successfully started
[TiBox:~] postgres% FATAL: invalid value for option 'LC_TIME': 'en_US'

So it seams that "LC_TIME" (local time, I guess) is set incorrectly,
but I can't find any reference to "LC_TIME" anywhere (I also think I've
misplaced the man pages for postgres, I can't get man pages on anything)

Has anyone run across this problem before? Any advice on correcting
"LC_TIME"

Thanks,
Paul

Paul Gobble <paul(dot)gobble(at)sbox(dot)net> writes:
> I could use some help.
> I've just finished installing postgreSQL 7.3.1 on my PowerBook (Os
> 10.2.3). Everything appeared to be going fine until I tried to run it.
> Below is what happens when ever I try to start (copied straight from
> the terminal)

> [TiBox:~] postgres% /Users/postgres/bin/pg_ctl start -D
> /Users/postgres/data -o -i -l
> postmaster successfully started
> [TiBox:~] postgres% FATAL: invalid value for option 'LC_TIME': 'en_US'

Set LC_TIME to 'C' near the bottom of $PGDATA/postgresql.conf. And
complain to Apple about the shoddy state of their locale support.
It's ridiculous that LC_TIME barfs up on locale settings that are
accepted by the other half-dozen LC_ variables.

Alternatively, you might want to re-initdb with --no-locale (or however
that switch is spelled, don't recall at the moment). 'en_US' is usually
an inferior choice compared to 'C' for database locale.

regards, tom lane