pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feeddst 2007?
4+ messages / 3 participants
[nested] [flat]
* dst 2007?
@ 2007-01-18 21:39 Ray Stell <stellr@cns.vt.edu>
0 siblings, 1 reply; 4+ messages in thread
From: Ray Stell @ 2007-01-18 21:39 UTC (permalink / raw)
To: pgsql-admin
This blog discusses the US dst 2007 issue.
http://www.edgeblog.net/2007/daylight-saving-time-the-year-2007-problem/
Unfortunately, this change has not received the attention it deserves,
so many IT shops have not yet started, and there are only 60 days to
get patches tested and deployed.
That blog points to:
http://archives.postgresql.org/pgsql-announce/2007-01/msg00004.php
as a response to the problem. I don't see any mention of the topic in
the accouncement or in the release notes. Josh does mention Canada
and Austrailia fixes. Is this topic covered somewhere in the pg docs?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: dst 2007?
@ 2007-01-18 21:58 Tom Lane <tgl@sss.pgh.pa.us>
parent: Ray Stell <stellr@cns.vt.edu>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2007-01-18 21:58 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: pgsql-admin
Ray Stell <stellr@cns.vt.edu> writes:
> This blog discusses the US dst 2007 issue.
> http://www.edgeblog.net/2007/daylight-saving-time-the-year-2007-problem/
> That blog points to:
> http://archives.postgresql.org/pgsql-announce/2007-01/msg00004.php
> as a response to the problem. I don't see any mention of the topic in
> the accouncement or in the release notes.
Indeed, because we've had the US changes in the database since before
8.1 release. It's the Canadian and Aussie changes that are today's
headache.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* dst 2007?
@ 2007-02-19 20:06 Ray Stell <stellr@cns.vt.edu>
0 siblings, 1 reply; 4+ messages in thread
From: Ray Stell @ 2007-02-19 20:06 UTC (permalink / raw)
To: pgsql-admin
Is your database ready for the Daylight Savings Times change of 2007?
http://people.planetpostgresql.org/greg/index.php?/archives/96-Is-your-database-ready-for-the-Daylig...
in the pg share dir:
$ /usr/sbin/zdump -v EST5EDT | grep 2007
EST5EDT Sun Mar 11 06:59:59 2007 UTC = Sun Mar 11 01:59:59 2007 EST isdst=0 gmtoff=-18000
EST5EDT Sun Mar 11 07:00:00 2007 UTC = Sun Mar 11 03:00:00 2007 EDT isdst=1 gmtoff=-14400
EST5EDT Sun Nov 4 05:59:59 2007 UTC = Sun Nov 4 01:59:59 2007 EDT isdst=1 gmtoff=-14400
EST5EDT Sun Nov 4 06:00:00 2007 UTC = Sun Nov 4 01:00:00 2007 EST isdst=0 gmtoff=-18000
Nice to see it in b&w on the system of interest.
Thx, Greg.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: dst 2007?
@ 2007-02-19 23:01 Michael Fuhr <mike@fuhr.org>
parent: Ray Stell <stellr@cns.vt.edu>
0 siblings, 0 replies; 4+ messages in thread
From: Michael Fuhr @ 2007-02-19 23:01 UTC (permalink / raw)
To: Ray Stell <stellr@cns.vt.edu>; +Cc: 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2007-02-19 23:01 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-01-18 21:39 dst 2007? Ray Stell <stellr@cns.vt.edu>
2007-01-18 21:58 ` Tom Lane <tgl@sss.pgh.pa.us>
2007-02-19 20:06 dst 2007? Ray Stell <stellr@cns.vt.edu>
2007-02-19 23:01 ` Michael Fuhr <mike@fuhr.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox