From: Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: log timestamp since daylight saving time
Date: Tue, 15 Mar 2011 08:50:31 -0400
Message-ID: <4D7F6097.50708@nasa.gov> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Maria.L.Wilson-1@nasa.gov
Subject: Re: log timestamp since daylight saving time
In-Reply-To: <4D7F6097.50708@nasa.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox