Postgres timestamps are out by one hour

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

Responses

Browse pgsql-admin by date

  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