Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 246699F9F6F for ; Mon, 27 Aug 2007 20:17:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 91560-02 for ; Mon, 27 Aug 2007 20:16:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 9DD879FA108 for ; Mon, 27 Aug 2007 20:17:03 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l7RNH2R4010269; Mon, 27 Aug 2007 19:17:02 -0400 (EDT) To: Robert Treat cc: pgsql-admin@postgresql.org Subject: Re: how is pitr replay interruption time determined? In-reply-to: <200708271742.57392.xzilla@users.sourceforge.net> References: <200708271742.57392.xzilla@users.sourceforge.net> Comments: In-reply-to Robert Treat message dated "Mon, 27 Aug 2007 17:42:57 -0400" Date: Mon, 27 Aug 2007 19:17:02 -0400 Message-ID: <10268.1188256622@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/337 X-Sequence-Number: 26668 Robert Treat writes: > LOG: database system was interrupted while in recovery at log time 2007-07-30 > 19:17:37 EDT > I am curious how this date is determined by postgres/pitr? It's the update timestamp in pg_control, which in essence is going to be the completion time of the last checkpoint. If the crash was during WAL recovery, as it seems to be, it'd be the time the last "restart" checkpoint was made. I'm not sure why the phrase "at log time" is used. It looks like whoever wrote the message thought that the timestamp would be one taken from the WAL data being replayed, but that's not what I see the code doing. regards, tom lane