Re: update time zone in timestamps - Mailing list pgsql-general

CSN wrote:
>
> SHOW ALL shows TimeZone is 'unknown'. postgres.conf
> says 'TZ' is used for default. Where should TZ be set
> (it doesn't appear to be set on my RH9 system)?

The postmaster process should have TZ in its environment.  I think that
gives clients a default timezone. You can also use PGTZ on the client to
control it.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073