Postgres Pro
Downloads
Home   >   mailing lists

Re: What does PostgreSQL do when time goes backward? - Mailing list pgsql-sql

From Frank Bax
Subject Re: What does PostgreSQL do when time goes backward?
Date
Msg-id BLU0-SMTP860B73D3D0E9B478E3DF80ACAF0@phx.gbl
Whole thread Raw
In response to What does PostgreSQL do when time goes backward?  (John Hasler <jhasler@newsguy.com>)
Responses Re: What does PostgreSQL do when time goes backward?  (Kenneth Marshall <ktm@rice.edu>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: join table problem
Next
From: "A. Kretschmer"
Date:
Subject: Re: Help Need some hindsight