pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
dst 2007?
4+ messages / 3 participants
[nested] [flat]

* dst 2007?
@ 2007-01-18 21:39 Ray Stell <stellr@cns.vt.edu>
  2007-01-18 21:58 ` Re: dst 2007? Tom Lane <tgl@sss.pgh.pa.us>
  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:39 dst 2007? Ray Stell <stellr@cns.vt.edu>
@ 2007-01-18 21:58 ` Tom Lane <tgl@sss.pgh.pa.us>
  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>
  2007-02-19 23:01 ` Re: dst 2007? Michael Fuhr <mike@fuhr.org>
  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 20:06 dst 2007? Ray Stell <stellr@cns.vt.edu>
@ 2007-02-19 23:01 ` Michael Fuhr <mike@fuhr.org>
  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