pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Fuhr <mike@fuhr.org>
To: Ray Stell <stellr@cns.vt.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: dst 2007?
Date: Mon, 19 Feb 2007 16:01:30 -0700
Message-ID: <20070219230129.GA83610@winnie.fuhr.org> (raw)
In-Reply-To: <20070219200632.GA25911@cns.vt.edu>
References: <20070219200632.GA25911@cns.vt.edu>

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



view thread (4+ messages)

Message-ID: <20070219230129.GA83610@winnie.fuhr.org>
Permalink:  ../20070219230129.GA83610@winnie.fuhr.org/
Also on:    postgresql.org/message-id/20070219230129.GA83610@winnie.fuhr.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: mike@fuhr.org, stellr@cns.vt.edu
  Subject: Re: dst 2007?
  In-Reply-To: <20070219230129.GA83610@winnie.fuhr.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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