Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 0E31B6324F0 for ; Mon, 2 Aug 2010 21:18:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 92414-05 for ; Tue, 3 Aug 2010 00:18:37 +0000 (UTC) X-Greylist: delayed 00:14:42.261235 by SQLgrey-1.7.6 Received: from smtp1.newsguy.com (smtp1.newsguy.com [74.209.136.71]) by mail.postgresql.org (Postfix) with ESMTP id 7F8CD63225C for ; Mon, 2 Aug 2010 21:18:38 -0300 (ADT) Received: from toncho.dhh.gt.org (174-124-10-9.dyn.centurytel.net [174.124.10.9]) by smtp.newsguy.com (8.14.3/8.14.3) with ESMTP id o7303rVr001831 for ; Mon, 2 Aug 2010 17:03:54 -0700 (PDT) (envelope-from john@dhh.gt.org) Received: from [192.168.1.7] (helo=thumper.dhh.gt.org ident=Debian-exim) by toncho.dhh.gt.org with esmtp (Exim 3.36 #1 (Debian)) id 1Og4z3-0003mU-00 for ; Mon, 02 Aug 2010 19:03:53 -0500 Received: from john by thumper.dhh.gt.org with local (Exim 4.71) (envelope-from ) id 1Og4z3-0007m1-CM for pgsql-sql@postgresql.org; Mon, 02 Aug 2010 19:03:53 -0500 From: John Hasler To: pgsql-sql@postgresql.org Subject: What does PostgreSQL do when time goes backward? Organization: Dancing Horse Hill Date: Mon, 02 Aug 2010 19:03:53 -0500 Message-ID: <87eiegblzq.fsf@thumper.dhh.gt.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.8 tagged_above=-5 required=5 tests=BAYES_50=0.8 X-Spam-Level: X-Archive-Number: 201008/8 X-Sequence-Number: 34448 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. -- John Hasler jhasler@newsguy.com Elmwood, WI USA