From: Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS AND APPLICATIONS, INC] <m.l.wilson@nasa.gov>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: log timestamp since daylight saving time
Date: Tue, 15 Mar 2011 14:21:59 -0400
Message-ID: <4D7FAE47.3000503@nasa.gov> (raw)
In-Reply-To: <AANLkTinnEvMWjd+NrWbAYCLs7ypzAwHTrM9E5oXw7vk-@mail.gmail.com>
References: <4D7F6097.50708@nasa.gov>
<AANLkTikTmgmAOg6u+yg6xUS_==QHyoZbr1YJcod7NyZ-@mail.gmail.com>
<4D7FABFC.6030809@nasa.gov>
<AANLkTi=HdYB9YXMoVse3wG0xw4FVDswPXZmRSF7_zajC@mail.gmail.com>
<AANLkTinnEvMWjd+NrWbAYCLs7ypzAwHTrM9E5oXw7vk-@mail.gmail.com>
yes they are all running the same postgres version. - 8.4.5
just as a test this morning - on one of the problem machines, we
installed another postgres installation - same version - just pointed it
to different paths - copied over the conf files and brought the server
up. This time it was the correct timeszone - US/Eastern. The other
postgres is set to EST5EDT. When I try to set it to US/Eastern, I get
an error...
postgres=# set timezone = 'US/Eastern';
ERROR: unrecognized time zone name: "US/Eastern"
postgres=#
On 3/15/11 2:18 PM, Scott Marlowe wrote:
> On Tue, Mar 15, 2011 at 12:17 PM, Scott Marlowe<scott.marlowe@gmail.com> wrote:
>> On Tue, Mar 15, 2011 at 12:12 PM, Maria L. Wilson
>> <Maria.L.Wilson-1@nasa.gov> wrote:
>>> when you say updating postgres - do you mean the server software? How do
>>> you update the tz data?
>> Yes updating the pg software. The OS has tzdata as well, and you can
>> update that. But postgresql includes its own tzdata so I'm guessing
>> that updating pg would fix it.
>>
>>> I'm just a little concerned why only 2 of our machines (they are all
>>> supposed to be the same) are having this problem.
>> Are they all running the same pg version?
> Also are all the machines set to the same time zone?
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, scott.marlowe@gmail.com, m.l.wilson@nasa.gov
Subject: Re: log timestamp since daylight saving time
In-Reply-To: <4D7FAE47.3000503@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