From: Tom Lane <tgl@sss.pgh.pa.us>
To: Maria.L.Wilson-1@nasa.gov
Cc: 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 15:50:34 -0400
Message-ID: <3503.1300218634@sss.pgh.pa.us> (raw)
In-Reply-To: <4D7FAE47.3000503@nasa.gov>
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>
<4D7FAE47.3000503@nasa.gov>
"Maria L. Wilson" <Maria.L.Wilson-1@nasa.gov> writes:
> 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"
Huh. That should most certainly work in a standard Postgres
installation. You're apparently missing that timezone file.
There are two possibilities:
1. If Postgres was built to use its own timezone database (the default),
then $INSTALLPREFIX/share/timezone/US/Eastern is missing. Which means
you've got an incomplete PG installation.
2. If Postgres was built with --with-system-tzdata=SOMETHING, then
SOMETHING/US/Eastern is missing, which means either an incomplete
system timezone database or whoever did the build used the wrong
value of SOMETHING for your platform.
I'd imagine that the EST5EDT setting you're seeing is some kind of
fallback behavior upon not finding the proper timezone file. It's
hard to be sure about where that came from without knowing exactly
what's missing.
regards, tom lane
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: tgl@sss.pgh.pa.us, 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: <3503.1300218634@sss.pgh.pa.us>
* 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