Re: How to set time zone permanently

Tom Lane wrote:
> Pam Wampler <Pam_Wampler(at)taylorwhite(dot)com> writes:
> > Where do I & how do I permanently set the time zone?
>
> I think best/only way right now is to set the TZ environment variable
> before starting the postmaster. The TimeZone variable ought to be
> settable from postgresql.conf, but for some reason it's not there now.
>
> BTW, if the system default timezone is not already the way you want it,
> you might consider making it so rather than putting a special hack into
> the Postgres start script. This usually involves creating or changing
> a configuration file somewhere under /etc ...

Actually, I think there are three levels: system timezone, TZ, and PGTZ
environment variables. The first is all processes, the second is all
processes that have TZ set, and PGTZ affects only PostgreSQL and not
other applications.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026