Обсуждение: New US DST Rules & PostgreSQL
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. -- adam
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
On Jan 23, 1:18 am, t...@sss.pgh.pa.us (Tom Lane) wrote: > Adam Gordon <adam.gor...@readytalk.com> writes: > > Anyone know where to find info about whether or not the new USDSTrules > > 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/ no... > > 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 USDSTupdates > > 8.2.x PG: all releases know about 2007 USDSTupdates > > regards, tom lane I'm curious. For 7.4.x, does the database require a restart for the change to take effect? I'm aware of a few production installations where the OS changed, but postgres time functions didn't take hold. -- Thomas F. O'Connell optimizing modern web applications : for search engines, for usability, and for performance : http://o.ptimized.com/ 615-260-0005
"Thomas F. O'Connell" <tf@o.ptimized.com> writes: > I'm curious. For 7.4.x, does the database require a restart for the > change to take effect? I'm aware of a few production installations > where the OS changed, but postgres time functions didn't take hold. Yes, probably. On those systems you will likely also find cron and other time-sensitive subsystems in need of a restart ... regards, tom lane