Re: dst 2007? - Mailing list pgsql-admin

From Michael Fuhr
Subject Re: dst 2007?
Date
Msg-id 20070219230129.GA83610@winnie.fuhr.org
Whole thread Raw
In response to dst 2007?  (Ray Stell <stellr@cns.vt.edu>)
List pgsql-admin
On Mon, Feb 19, 2007 at 03:06:32PM -0500, Ray Stell wrote:
> in the pg share dir:
>
> $ /usr/sbin/zdump -v EST5EDT | grep 2007

On many platforms, regardless of what directory you're in, the above
command will read timezone files from a standard directory like
/usr/share/zoneinfo, not from the current directory.  Even a relative
path like ./EST5EDT won't work; you'll need to give the full path:

zdump -v /full/path/EST5EDT

I'd suggest doing a process trace (ktrace, strace, truss, etc.) to
check what timezone file zdump is reading.  And if your system
stores its local timezone in /etc/localtime, don't forget to check
that file as well -- otherwise you might discover that your system
uses the correct DST dates for every timezone except the one you're
in.

--
Michael Fuhr

pgsql-admin by date:

Previous
From: Ray Stell
Date:
Subject: dst 2007?
Next
From: Tom Lane
Date:
Subject: Re: log_duration?