Re: New US DST Rules & PostgreSQL

On Jan 23, 1:18 am, t(dot)(dot)(dot)(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane) wrote:
> Adam Gordon <adam(dot)gor(dot)(dot)(dot)(at)readytalk(dot)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