On Jan 23, 1:18 am, t...@xxxxxxxxxxxxx (Tom Lane) wrote:
> Adam Gordon <adam.gor...@xxxxxxxxxxxxx> 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
