Обсуждение: 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.gobble@sbox.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