NTP Setup
We have been using this script to set up NTP.
When there are changes to the NTP sevrers, you'll need to modify /etc/ntp.conf and /etc/ntp/step-tickers.
We have also been seeing this issue.
***** Nagios ***** Notification Type: PROBLEM Service: PostgreSQL Timesync Host: eas-sfproddb.sfgov.org Address: 10.250.60.196 State: CRITICAL Date/Time: Wed Jan 2 06:00:11 PST 2013 Additional Info: POSTGRES_TIMESYNC CRITICAL: DB postgres (host:10.250.60.196) timediff=70 DB=2013-01-02 05:58:51 Local=2013-01-02 06:00:01
It might be this issue.