Re: Timezones in 8.2.7 - Mailing list pgsql-general

From Joseph S
Subject Re: Timezones in 8.2.7
Date
Msg-id fsdsur$1h3c$1@news.hub.org
Whole thread Raw
In response to Re: Timezones in 8.2.7  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Timezones in 8.2.7  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Joseph S <jks@selectacast.net> writes:
>> Was there something wrong with the tzdata distributed in 8.2.7?
>> current_timestamp is still using EST, but the date command run from the
>> command line is correctly returning EDT
>
> Works for me ... what have you got TimeZone set to?
>
>             regards, tom lane
>

  /etc/localtime -> /usr/share/zoneinfo/US/Eastern


I just upgraded the tzdata file to 2007k and restarted postgres, but the
problem persists.

pgsql-general by date:

Previous
From: Chris Browne
Date:
Subject: Re: PostgreSQL Replication with read-only access to standby DB
Next
From: Shane Ambler
Date:
Subject: Re: How to "use" database?