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
|
| Список | 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 по дате отправления: