Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 80E0E1337C16
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 15 Mar 2011 15:45:23 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 23888-03-4
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 15 Mar 2011 18:45:16 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from ndjsnpf03.ndc.nasa.gov (ndjsnpf03.ndc.nasa.gov [198.117.1.123])
	by mail.postgresql.org (Postfix) with ESMTP id 0A0E11337C17
	for <pgsql-admin@postgresql.org>; Tue, 15 Mar 2011 15:45:09 -0300 (ADT)
Received: from ndmsppt03.ndc.nasa.gov (ndmsppt03.ndc.nasa.gov [198.117.0.102])
	by ndjsnpf03.ndc.nasa.gov (Postfix) with ESMTP id 273782E0076;
	Tue, 15 Mar 2011 13:45:09 -0500 (CDT)
Received: from ndmshub02.ndc.nasa.gov (ndmshub02-pub.ndc.nasa.gov
	[198.117.0.161])
	by ndmsppt03.ndc.nasa.gov (8.14.4/8.14.4) with ESMTP id p2FIj8j8025274;
	Tue, 15 Mar 2011 13:45:08 -0500
Received: from lrc000959195.larc.nasa.gov (198.119.134.170) by
	smtp02.ndc.nasa.gov (198.117.0.161) with Microsoft SMTP Server (TLS) id
	8.3.137.0; Tue, 15 Mar 2011 13:45:09 -0500
Message-ID: <4D7FB3B3.7010805@nasa.gov>
Date: Tue, 15 Mar 2011 14:45:07 -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: Scott Marlowe <scott.marlowe@gmail.com>
CC: "Wilson, Maria Louise (LARC-E301)[SCIENCE SYSTEMS AND APPLICATIONS, INC]"
	<m.l.wilson@nasa.gov>, "pgsql-admin@postgresql.org"
	<pgsql-admin@postgresql.org>
Subject: Re: log timestamp since daylight saving time
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>
In-Reply-To: <AANLkTinnEvMWjd+NrWbAYCLs7ypzAwHTrM9E5oXw7vk-@mail.gmail.com>
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
Content-Transfer-Encoding: 7bit
X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:5.2.15, 1.0.148,
	0.0.0000
	definitions=2011-03-15_02:2011-03-14, 2011-03-15,
	1970-01-01 signatures=0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-4.21 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201103/175
X-Sequence-Number: 37047

it also looks like the view pg_timezone_names is empty in the problem 
installation.  What loads this view?

psql (8.4.5)
Type "help" for help.

postgres=# select * from pg_timezone_names;
  name | abbrev | utc_offset | is_dst
------+--------+------------+--------
(0 rows)

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?