Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres timestamps are out by one hour - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgres timestamps are out by one hour
Date
Msg-id 21444.1161879385@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres timestamps are out by one hour  ("Simon Kinsella" <simon@bluefiresystems.co.uk>)
Responses Re: Postgres timestamps are out by one hour  ("Simon Kinsella" <simon@bluefiresystems.co.uk>)
List pgsql-admin
Tree view 
"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

pgsql-admin by date:

Previous
From: "Fernando Machado"
Date:
Subject:
Next
From: Jari Vauhkonen
Date:
Subject: Re: TCP/IP connection problem