Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint - Mailing list pgsql-hackers

From Andrew Gierth
Subject Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint
Date
Msg-id 87in18yxdf.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Adding a TAP test checking data consistency on standby withminRecoveryPoint  (Michael Paquier <michael@paquier.xyz>)
Responses Re: Adding a TAP test checking data consistency on standby withminRecoveryPoint
List pgsql-hackers
>>>>> "Michael" == Michael Paquier <michael@paquier.xyz> writes:

 Michael> I have also been trying to shape that into a TAP test which
 Michael> can be added into the in-core recovery test suite, and it
 Michael> happens that the part which scans if all the pages of a
 Michael> relation are not newer than what minRecoveryPoint is set to in
 Michael> the control file can be easily calculated by using pageinspect
 Michael> and pg_control_recovery() with a simple SQL query.

How? It's OK (and normal) for in-core pages to have newer LSNs than
minRecoveryPoint, it's only on-disk pages that must not be more recent
than that. And pageinspect will show the in-core page...

-- 
Andrew (irc:RhodiumToad)


pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: csv format for psql
Next
From: Tom Lane
Date:
Subject: Re: jsonpath