Thanks for your help Tom - I've got it sorted now by setting
timezone='GMT0DST' in the conf file.
Simon.
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, October 26, 2006 5:16 PM
To: Simon Kinsella
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres timestamps are out by one hour
"Simon Kinsella" <simon@bluefiresystems.co.uk> writes:
> template1=# show timezone;
> TimeZone
> ----------
> GMT0
That's a non-daylight-savings zone ... and one would guess that the
postmaster was started with TZ=GMT or some such, else it would not have
picked that as the Postgres zone.
regards, tom lane