Re: FATAL error on launch

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