New US DST Rules & PostgreSQL

Adam Gordon wrote:

Hi-

Anyone know where to find info about whether or not the new US DST rules
impact certain versions of Postgres and what needs to be done to ensure
observance of the new rules? Thanks.

Pre-8.0 PostgreSQL versions us the operating system timezone database.
All >= 8.0 current PostgreSQL releases have updated timezone databases
that will function fine.

--
Bruce Momjian bruce@momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Adam Gordon <adam.gordon@readytalk.com> writes:

Anyone know where to find info about whether or not the new US DST rules
impact certain versions of Postgres and what needs to be done to ensure
observance of the new rules? Thanks.

http://developer.postgresql.org/cvsweb.cgi/pgsql/src/timezone/data/northamerica

The short version:

Any 7.x PG: uses your OS's timezone info, hence OK if you've updated the OS

8.0.x PG: need 8.0.4 or later

8.1.x PG: all releases know about 2007 US DST updates

8.2.x PG: all releases know about 2007 US DST updates

regards, tom lane