Hi,
I have several Postgres DB's not showing correct daylight savings time.
From maillist etc I believe these are patched up to the right levels to have the correct time zones - but they don't seem to be working still.
The unix date command show the correct dates.
Server 1: postgresql-8.2.4 (Ubuntu 7.04)
dbtest=> show timezone;
TimeZone
-----------
localtime
(1 row)
dbtest=> select localtime;
time
-----------------
16:16:32.853566
(1 row)
craiga@xyz-01:~$ date
Thu Oct 16 17:16:36 EST 2008
And another:
Server2: Postgresql-8.1.9 (on Ubuntu Dapper 6.06.1)
btest=> show timezone ;
TimeZone
---------------
Australia/ACT
(1 row)
btest=> select localtime;
time
-----------------
16:17:45.227342
(1 row)
craiga@citadel:~$ date
Thu Oct 16 17:18:31 EST 2008
--
Craig Ayliffe
