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:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
