From: Maria L. Wilson <Maria.L.Wilson-1@nasa.gov>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS AND APPLICATIONS, INC] <m.l.wilson@nasa.gov>
Cc: Scott Marlowe <scott.marlowe@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: log timestamp since daylight saving time
Date: Tue, 15 Mar 2011 15:56:02 -0400
Message-ID: <4D7FC452.4090601@nasa.gov> (raw)
In-Reply-To: <3503.1300218634@sss.pgh.pa.us>
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>
<3503.1300218634@sss.pgh.pa.us>
I would have thought the same thing too - but, the file system looks
correct.....(below...)
[postgres@catalogdata share]$ cd timezone
/scratch/postgresql-8.4.5/share/timezone
[postgres@catalogdata timezone]$ ls -al
total 268
drwxr-xr-x 19 root staff 4096 Nov 1 09:08 ./
drwxr-xr-x 9 root staff 4096 Nov 1 09:20 ../
drwxr-xr-x 2 root staff 4096 Nov 1 09:08 Africa/
drwxr-xr-x 6 root staff 4096 Nov 1 09:08 America/
drwxr-xr-x 2 root staff 4096 Nov 1 09:08 Antarctica/
.
.
.
-rw------- 6 root staff 118 Nov 1 09:08 Universal
drwxr-xr-x 2 root staff 4096 Nov 1 09:08 US/
-rw------- 6 root staff 118 Nov 1 09:08 UTC
-rw------- 1 root staff 1873 Nov 1 09:08 WET
-rw------- 2 root staff 2194 Nov 1 09:08 W-SU
-rw------- 6 root staff 118 Nov 1 09:08 Zulu
[postgres@catalogdata timezone]$ pwd
/scratch/postgresql-8.4.5/share/timezone
/scratch/postgresql-8.4.5/share/timezone
[postgres@catalogdata timezone]$ cd US
/scratch/postgresql-8.4.5/share/timezone/US
[postgres@catalogdata US]$ ls -al
total 60
drwxr-xr-x 2 root staff 4096 Nov 1 09:08 ./
drwxr-xr-x 19 root staff 4096 Nov 1 09:08 ../
-rw------- 2 root staff 2358 Nov 1 09:08 Alaska
-rw------- 3 root staff 2353 Nov 1 09:08 Aleutian
-rw------- 2 root staff 327 Nov 1 09:08 Arizona
-rw------- 2 root staff 3543 Nov 1 09:08 Central
-rw------- 3 root staff 3519 Nov 1 09:08 Eastern
-rw------- 4 root staff 1649 Nov 1 09:08 East-Indiana
-rw------- 2 root staff 312 Nov 1 09:08 Hawaii
-rw------- 3 root staff 2395 Nov 1 09:08 Indiana-Starke
-rw------- 2 root staff 2202 Nov 1 09:08 Michigan
-rw------- 4 root staff 2427 Nov 1 09:08 Mountain
-rw------- 3 root staff 2819 Nov 1 09:08 Pacific
-rw------- 3 root staff 2819 Nov 1 09:08 Pacific-New
-rw------- 3 root staff 290 Nov 1 09:08 Samoa
[postgres@catalogdata US]$
I'm just wondering if something happened in the installation that did
NOT load the data into the timezone view - pg_timezone_names - because
when I query that it comes up empty.
On 3/15/11 3:50 PM, Tom Lane wrote:
> "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: Maria.L.Wilson-1@nasa.gov, tgl@sss.pgh.pa.us, m.l.wilson@nasa.gov, scott.marlowe@gmail.com
Subject: Re: log timestamp since daylight saving time
In-Reply-To: <4D7FC452.4090601@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