Re: What does PostgreSQL do when time goes backward?

From: Frank Bax <fbax(at)sympatico(dot)ca>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: What does PostgreSQL do when time goes backward?
Date: 2010-08-04 11:20:31
Message-ID: BLU0-SMTP860B73D3D0E9B478E3DF80ACAF0@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

John Hasler wrote:
> How does PostgreSQL react to time being stepped at bootup? My Chrony
> NTP package might cause it to do so on rare occasions when the hardware
> clock is way off. This would only happen during bootup.

My ntp client changes clock (by small amount) at any time:

Jul 25 05:29:38 bax ntpd[10269]: adjusting local clock by 0.098724s
Jul 25 05:31:43 bax ntpd[10269]: adjusting local clock by 0.038991s
Jul 25 06:13:38 bax ntpd[10269]: adjusting local clock by -0.037131s
Jul 25 15:01:52 bax ntpd[10269]: adjusting local clock by -0.112429s

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2010-08-04 11:48:08 Re: Help Need some hindsight
Previous Message Oliveiros d'Azevedo Cristina 2010-08-04 11:11:35 Re: join table problem