Problems with Timezones in Australia

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(at)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(at)citadel:~$ date
Thu Oct 16 17:18:31 EST 2008

--
Craig Ayliffe