now() time off

From: John McCawley <nospam(at)hardgeus(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: now() time off
Date: 2006-02-22 22:36:43
Message-ID: 43FCE77B.6030400@hardgeus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Earlier this week when I logged into my database, I just so happened to
notice that the value for now() was six hours off of the time reported
by the operating system when using the date command from the command
line. How is this possible? I rebooted the server and the problem
magically went away. I am quite certain that I didn't modify anything
in the database that should cause this problem. It turns out that that
the now() time has been off for some time, and resulted in quite a bit
of corrupted data. What exactly should I do in the future to keep this
from happening, or where should I look for clues?

John

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2006-02-22 22:46:35 Re: now() time off
Previous Message Jim C. Nasby 2006-02-22 20:31:41 Re: Performance Problems