Re: Clarification of pg_cotroldata output - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Clarification of pg_cotroldata output
Date
Msg-id 4D46AFAF020000250003A038@gw.wicourts.gov
Whole thread Raw
In response to Clarification of pg_cotroldata output  (Melvin Davidson <mdavidson@icsolutions.com>)
List pgsql-admin
Melvin Davidson <mdavidson@icsolutions.com> wrote:

> 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:" ?

If it's documented, I haven't found it yet.  I generally find the
labels to be pretty descriptive, though.

"pg_control last modified" is the last time the server wrote control
information out to the disk.  "Time of latest checkpoint" is the
last time a checkpoint had been performed at the point when the
control data was last written.

-Kevin

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Drop Schema Error
Next
From: "Do, Elvis L"
Date:
Subject: pgagent fails to start by service command on redhat enterprise 5