Re: daylight savings patches needed? - Mailing list pgsql-general

From Ed L.
Subject Re: daylight savings patches needed?
Date
Msg-id 200703121307.36248.pgsql@bluepolka.net
Whole thread Raw
In response to daylight savings patches needed?  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: daylight savings patches needed?  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
We have a 7.4.6 cluster which has been running on an HP B.11.00
box for quite sometime.  The IT group applied daylight savings
patches to the OS, but the cluster is still showing the
incorrect timezone:

$ psql -c "select now()"
              now
-------------------------------
 2007-03-12 13:46:11.369583-05

$ date
Mon Mar 12 14:46:18 EDT 2007

It appears that newly initialized 7.4.6 clusters get the proper
timezone.  I didn't see anything in the FAQ about restarting.

Does this mean that we need to restart these clusters in order to
get the timezone updates from the OS?  Are they cached in the
postmaster?

TIA.
Ed

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Tsearch2 / Create rule on select
Next
From: "Ed L."
Date:
Subject: Re: daylight savings patches needed?