Pallav Kalva <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED]:/var/lib/pgsql/bin> cd .. > [EMAIL PROTECTED]:/var/lib/pgsql> cd share > [EMAIL PROTECTED]:/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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly