Message-ID: <4D7F6097.50708@nasa.gov>
Date: Tue, 15 Mar 2011 08:50:31 -0400
From: "Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov>
Reply-To: Maria.L.Wilson-1@nasa.gov
Organization: SSAI
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US;
	rv:1.9.2.15) Gecko/20110303 Lightning/1.0b2 Thunderbird/3.1.9
MIME-Version: 1.0
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: log timestamp since daylight saving time
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
Content-Transfer-Encoding: 7bit

Hi all -

Ever since daylight savings time, I've noticed that the timestamp in the 
log files on 2 of our many postgres servers (version 8.4.5) did not 
update.  It's still 1 hour behind.  The settings are all default (see 
below) on all the servers.

# - Locale and Formatting -

datestyle = 'iso, mdy'
#intervalstyle = 'postgres'
#timezone = unknown                     # actually, defaults to TZ 
environment
                                         # setting
#timezone_abbreviations = 'Default'     # Select the set of available 
time zone
                                         # abbreviations.  Currently, 
there are
                                         #   Default
                                         #   Australia
                                         #   India
                                         # You can create your own file in
                                         # share/timezonesets/.
#extra_float_digits = 0                 # min -15, max 2
#client_encoding = sql_ascii            # actually, defaults to database
                                         # encoding


I've also checked the timezone through psql - for the 2 incorrect 
servers I get

postgres=# show timezone;
  TimeZone
----------
  EST5EDT
(1 row)

For the correct servers, I get.....

postgres=# show timezone;
   TimeZone
------------
  US/Eastern
(1 row)

postgres=#


How do you go about correcting this??

thanks!
Maria Wilson
NASA/Langley Research Center
Hampton, Virginia 23681