Postgres timestamps are out by one hour

Поиск
Список
Период
Сортировка
От Simon Kinsella
Тема Postgres timestamps are out by one hour
Дата
Msg-id 20061026151745.F0C8C198AC6@smtp03l.fasthosts.co.uk
обсуждение исходный текст
Ответы Re: Postgres timestamps are out by one hour  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hello,

I'm experiencing a strange problem on two of my installs (PostgreSQL 8.1.4
on FreeBSD6.1-Release):

From the shell:

root@stilton> date
Thu Oct 26 16:03:09 BST 2006

From psql/any sql client:

template1=# select now();
             now
------------------------------
 2006-10-26 15:03:24.43408+00

The shell / system timestamp is correct local time (London, daylight
saving), but the postgres time is one hour behind.

postgresql.conf shows:
#timezone = unknown                     # actually, defaults to TZ
                                        # environment setting

This is happening on two machines, but not on a third. All with same version
and config. Not sure where to start - any clues?  Sounds like some time zone
or daylight saving thing...?


---
Simon Kinsella



В списке pgsql-admin по дате отправления:

Предыдущее
От: Enrico
Дата:
Сообщение: Re: TCP/IP connection problem
Следующее
От: Jari Vauhkonen
Дата:
Сообщение: Re: TCP/IP connection problem