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

From Michael Paquier
Subject Re: Adding a TAP test checking data consistency on standby withminRecoveryPoint
Date
Msg-id 20181108070026.GG1222@paquier.xyz
Whole thread Raw
In response to Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Responses Re: Adding a TAP test checking data consistency on standby withminRecoveryPoint  (Michael Paquier <michael@paquier.xyz>)
List pgsql-hackers
On Thu, Nov 08, 2018 at 06:00:29AM +0000, Andrew Gierth wrote:
> I think it would be nice to have a test that didn't rely on that, too.

Yes, I don't disagree with you and I thought about it.  Fetching the
value from the control file is easy, doing the comparison between two
LSNs is also simple by doing it directly with pg_lsn in the database
(and I don't want to add math logics about LSNs as a TAP API).  Now I am
less sure about how portable it is possible to make the read of 8 bytes
on the page header for the last page of a relation portable across many
architectures in perl.

And I am not sure that we actually need this addition that as the
standby spawned in the TAP test will not have any clients scanning the
pages and generating WAL, except autovacuum which would be better
switched off in the test.
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Amit Langote
Date:
Subject: Re: move PartitionBoundInfo creation code
Next
From: John Naylor
Date:
Subject: Re: PostgreSQL Limits and lack of documentation about them.