Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 00FE6632406 for ; Wed, 4 Aug 2010 08:20:43 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 42730-05 for ; Wed, 4 Aug 2010 11:20:34 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from blu0-omc2-s6.blu0.hotmail.com (blu0-omc2-s6.blu0.hotmail.com [65.55.111.81]) by mail.postgresql.org (Postfix) with ESMTP id 69824632346 for ; Wed, 4 Aug 2010 08:20:35 -0300 (ADT) Received: from BLU0-SMTP86 ([65.55.111.72]) by blu0-omc2-s6.blu0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Wed, 4 Aug 2010 04:20:33 -0700 X-Originating-IP: [64.231.108.234] X-Originating-Email: [fbax@sympatico.ca] Message-ID: Received: from t60p.bax.ca ([64.231.108.234]) by BLU0-SMTP86.blu0.hotmail.com over TLS secured channel with Microsoft SMTPSVC(6.0.3790.4675); Wed, 4 Aug 2010 04:20:32 -0700 Date: Wed, 04 Aug 2010 07:20:31 -0400 From: Frank Bax User-Agent: Thunderbird 2.0.0.23 (X11/20100309) MIME-Version: 1.0 CC: pgsql-sql@postgresql.org Subject: Re: What does PostgreSQL do when time goes backward? References: <87eiegblzq.fsf@thumper.dhh.gt.org> In-Reply-To: <87eiegblzq.fsf@thumper.dhh.gt.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 04 Aug 2010 11:20:32.0606 (UTC) FILETIME=[0D5F77E0:01CB33C7] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.021 tagged_above=-5 required=5 tests=BAYES_40=-0.001, MISSING_HEADERS=1.021, MSGID_FROM_MTA_HEADER=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: * X-Archive-Number: 201008/12 X-Sequence-Number: 34452 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