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)?
Thanks,
CSN
--- CSN <[EMAIL PROTECTED]> wrote:
>
> Does Postgres use the system's timezone
> (/etc/localzone) at all? Or does "SET TIME ZONE
Does Postgres use the system's timezone
(/etc/localzone) at all? Or does "SET TIME ZONE 'MST'"
need to be placed in postgres.conf to make it always
used (I set it via psql, but it appears to only be set
for that connection)?
Thanks,
CSN
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> CSN <[EMAIL PROT