Re: New US DST Rules & PostgreSQL
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