SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 02:33 PM
| ||||
| ||||
 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/cvsw...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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster      |
|
04-09-2008, 02:34 PM
| ||||
| ||||
| Re: New US DST Rules & PostgreSQL "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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
Linear Mode
