Re: Online verification of checksums - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Online verification of checksums
Date
Msg-id e55c9f5b-c092-8535-6d0a-7e5a70fd71e7@2ndquadrant.com
Whole thread Raw
In response to Online verification of checksums  (Michael Banck <michael.banck@credativ.de>)
Responses Re: Online verification of checksums
List pgsql-hackers
On 26/07/2018 13:59, Michael Banck wrote:
> I've now forward-ported this change to pg_verify_checksums, in order to
> make this application useful for online clusters, see attached patch.

Why not provide this functionality as a server function or command.
Then you can access blocks with proper locks and don't have to do this
rather ad hoc retry logic on concurrent access.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Dimension limit in contrib/cube (dump/restore hazard?)
Next
From: Michael Paquier
Date:
Subject: Re: Bug in slot.c and are replication slots ever used at Window?