From: | "Simon Kinsella" <simon(at)bluefiresystems(dot)co(dot)uk> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Postgres timestamps are out by one hour |
Date: | 2006-10-26 15:17:41 |
Message-ID: | 20061026151745.F0C8C198AC6@smtp03l.fasthosts.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Jari Vauhkonen | 2006-10-26 15:22:55 | Re: TCP/IP connection problem |
Previous Message | Ben Suffolk | 2006-10-26 13:06:44 | Re: TCP/IP connection problem |