Re: Postgres timestamps are out by one hour

Поиск
Список
Период
Сортировка
От Simon Kinsella
Тема Re: Postgres timestamps are out by one hour
Дата
Msg-id 20061027083646.AE5F4199D19@smtp04l.fasthosts.co.uk
обсуждение исходный текст
Ответ на Re: Postgres timestamps are out by one hour  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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@sss.pgh.pa.us]
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" <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 по дате отправления:

Предыдущее
От: Peter Neish
Дата:
Сообщение: pg_dump: schema with OID xxxxxxxx does not exist
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump: schema with OID xxxxxxxx does not exist