DST problem on pg 8.2.5

From: Joseph S <jks(at)selectacast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: DST problem on pg 8.2.5
Date: 2007-10-29 20:17:28
Message-ID: fg5f4l$1rva$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On one of my servers postgres thinks that we're back on standard time
already:

[local]:db=# select current_timestamp;
now
-------------------------------
2007-10-29 15:06:10.049795-05
(1 row)

Time: 0.807 ms
[local]:db=# select version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 8.2.5 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6
20060404 (Red Hat 3.4.6-3)
(1 row)

Time: 37.631 ms

But the os itself doesn't have a problem:
> date
Mon Oct 29 16:05:50 EDT 2007

On another machine with an 8.2.5 install it is working fine. What could
have caused this?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-10-29 20:43:15 Re: reg. rewrite rules
Previous Message Tom Lane 2007-10-29 19:46:27 Re: Inheritance problem when restoring db