Re: How to set time zone permanently

Tom Lane wrote:
> Pam Wampler <Pam_Wampler@taylorwhite.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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026