From: Kenneth Marshall <ktm@rice.edu>
To: Frank Bax <fbax@sympatico.ca>
Cc: pgsql-sql@postgresql.org
Subject: Re: What does PostgreSQL do when time goes backward?
Date: Wed, 4 Aug 2010 07:55:24 -0500
Message-ID: <20100804125524.GV12093@aart.is.rice.edu> (raw)
In-Reply-To: <BLU0-SMTP860B73D3D0E9B478E3DF80ACAF0@phx.gbl>
References: <87eiegblzq.fsf@thumper.dhh.gt.org>
<BLU0-SMTP860B73D3D0E9B478E3DF80ACAF0@phx.gbl>
On Wed, Aug 04, 2010 at 07:20:31AM -0400, Frank Bax wrote:
> 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
>
PostgreSQL does not use system time to track transactions so
you should be good. Also, these types of clock changes by ntpd
use the adjtime() system call which either slows or speeds the
system clock to make the adjustment over a period of time so
it should be minimally disruptive. These do seem to be larger
values than you might expect from a clock conditioned with ntpd.
Is it a VM or is there something going on that would stop or
suspend your system?
Cheers,
Ken
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ktm@rice.edu, fbax@sympatico.ca
Subject: Re: What does PostgreSQL do when time goes backward?
In-Reply-To: <20100804125524.GV12093@aart.is.rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox