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@xxxxxxxxxxxxx] Sent: Thursday, October 26, 2006 5:16 PM To: Simon Kinsella Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] Postgres timestamps are out by one hour "Simon Kinsella" <simon@xxxxxxxxxxxxxxxxxxxxx> 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