Re: Postgres timestamps are out by one hour

["Simon Kinsella" <simon(at)bluefiresystems(dot)co(dot)uk>]

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