Re: Adding a TAP test checking data consistency on standby with minRecoveryPoint
Michael Paquier <michael@paquier.xyz>
From: Michael Paquier <michael@paquier.xyz>
To: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: Postgres hackers <pgsql-hackers@postgresql.org>
Date: 2018-11-08T07:00:26Z
Lists: 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
Commits
-
Add TAP test to check consistency of minimum recovery LSN
- b0825d28ea83 12.0 landed