Lists: | pgsql-novice |
---|
From: | Paul Gobble <paul(dot)gobble(at)sbox(dot)net> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | FATAL error on launch |
Date: | 2003-01-14 16:04:55 |
Message-ID: | EC4D3122-27D9-11D7-A706-000393669376@sbox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
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
From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Paul Gobble <paul(dot)gobble(at)sbox(dot)net> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: FATAL error on launch |
Date: | 2003-01-14 16:40:25 |
Message-ID: | 16664.1042562425@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-novice |
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