Re: 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