Postgres Pro
Downloads
Home   >   mailing lists

Re: system date != now() - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: system date != now()
Date
Msg-id 20040412115837.GB20278@wolff.to
Whole thread Raw
In response to Re: system date != now()  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
Tree view 
On Sun, Apr 11, 2004 at 00:01:42 -0700,
  CSN <cool_screen_name90001@yahoo.com> wrote:
>
> timezone in postgresql.conf was set to MST. Setting it
> to MDT gave this error:
>
> LOG:  unrecognized time zone name: "MDT"
> FATAL:  invalid value for parameter "timezone": "MDT"

I think setting the timezone to MST accounts for your problem.
If you want to switch timezones at the DST boundaries, I think
you want to use a timezone of "MST7MDT".

pgsql-general by date:

Previous
From: "Siew Hui, Wong"
Date:
Subject: Re: Error in function to pg_dump: Standard in must be a tty
Next
From: Tom Lane
Date:
Subject: Re: Regular expressions