Re: pg_checksums? - Mailing list pgsql-general

From Peter J. Holzer
Subject Re: pg_checksums?
Date
Msg-id 20231030100113.l2fzg7x3ukvce2l7@hjp.at
Whole thread Raw
In response to Re: pg_checksums?  (Michael Paquier <michael@paquier.xyz>)
List pgsql-general
On 2023-10-30 09:56:31 +0900, Michael Paquier wrote:
> Hm?  Page checksums are written when a page is flushed to disk, we
> don't set them for dirty buffers or full-page writes included in WAL,
> so it should be OK to do something like the following:
> - Stop cleanly a standby.
> - Run pg_checksums on the standby to enable them.
> - Restart the standby.
> - Catchup with the latest changes
> - Stop cleanly the primary, letting the shutdown checkpoint be
> replicated to the standby.
> - Promote the standby.
> - Enable checksums on the previous primary.
> - Start the previous primary to be a standby of the node you failed
> over to.

I stand corrected.

        hp

--
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

Attachment

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: [SOLVED?] Re: Disk wait problem... not hardware...
Next
From: "Peter J. Holzer"
Date:
Subject: Re: pg_checksums?