Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id A26D01337B5E for ; Thu, 27 Jan 2011 16:10:00 -0400 (AST) 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 67635-08 for ; Thu, 27 Jan 2011 20:09:53 +0000 (UTC) X-Greylist: delayed 00:05:22.332084 by SQLgrey-1.7.6 Received: from polaris1.ics.loc (polaris.icsolutions.com [174.47.150.20]) by mail.postgresql.org (Postfix) with ESMTP id 14ECA1337B4E for ; Thu, 27 Jan 2011 16:09:53 -0400 (AST) Received: from [172.26.15.66] (172.26.15.66) by polaris.icsolutions.com (172.26.16.20) with Microsoft SMTP Server id 8.1.436.0; Thu, 27 Jan 2011 14:04:30 -0600 Message-ID: <4D41CFCD.4050402@icsolutions.com> Date: Thu, 27 Jan 2011 14:04:29 -0600 From: Melvin Davidson User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7 MIME-Version: 1.0 To: Subject: Clarification of pg_cotroldata output Content-Type: multipart/alternative; boundary="------------030109070600090605050704" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.909 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201101/177 X-Sequence-Number: 36617 --------------030109070600090605050704 Content-Type: text/plain; charset="ISO-8859-1"; format=flowed Content-Transfer-Encoding: 7bit *Can someone please clarify? When I execute pg_control on a warm standby cluster, I notice that often, "Time of latest checkpoint:" lags behind "pg_control last modified:". Is it documented anywhere the difference between "pg_control last modified:" and "Time of latest checkpoint:" ? Thanks in advance! Melvin * --------------030109070600090605050704 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: 7bit
Can someone please clarify?
When I execute pg_control on a warm standby cluster, I notice that often,
"Time of latest checkpoint:" lags behind "pg_control last modified:".

Is it documented anywhere the difference between "pg_control last modified:"
and "Time of latest checkpoint:" ?

Thanks in advance!
Melvin

--------------030109070600090605050704--