Pallav Kalva <pkalva@xxxxxxxxxxxxxxxxx> 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
