Re: Age of the WAL? - Mailing list pgsql-general

From Tom Lane
Subject Re: Age of the WAL?
Date
Msg-id 6589.1363129984@sss.pgh.pa.us
Whole thread Raw
In response to Age of the WAL?  (Erik Jones <ejones@engineyard.com>)
Responses Re: Age of the WAL?
List pgsql-general
Erik Jones <ejones@engineyard.com> writes:
> What's the best way to determine the age of the current WAL?  Not the current segment, but the whole thing.  Put
anotherway:  is there a way to determine a timestamp for the oldest available transaction in the WAL? 

Transaction commit and abort records carry timestamps, so you could
figure this out with something like pg_xlogdump.  I don't know of any
canned solution though.

            regards, tom lane


pgsql-general by date:

Previous
From: Gregg Jaskiewicz
Date:
Subject: Re: table spaces
Next
From: Joe Van Dyk
Date:
Subject: Re: Testing Technique when using a DB