Problems with Timezones in Australia

["Craig Ayliffe" <cayliffe@xxxxxxxxx>]

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