Pallav Kalva <pkalva@livedatagroup.com> writes:
> postgres@pkalva:/var/lib/pgsql/bin> cd ..
> postgres@pkalva:/var/lib/pgsql> cd share
> postgres@pkalva:/var/lib/pgsql/share> /usr/sbin/zdump -v EST5EDT | grep 2007
> EST5EDT Sun Apr 1 06:59:59 2007 UTC = Sun Apr 1 01:59:59 2007 EST
> isdst=0 gmtoff=-18000
Are you sure that zdump looks into the current directory? The man page
is not clear but it says the arguments are "zone names" not "file names",
so I'd sort of expect that it's looking into the system timezone
directory. In which case this result means that your OS is in need of
a timezone update, not Postgres.
regards, tom lane
