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