Re: Postgres timestamps are out by one hour

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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Thursday, October 26, 2006 5:16 PM
To: Simon Kinsella
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Postgres timestamps are out by one hour

"Simon Kinsella" <simon(at)bluefiresystems(dot)co(dot)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