Re: pg_checksums? - Mailing list pgsql-general

From Alexander Kukushkin
Subject Re: pg_checksums?
Date
Msg-id CAFh8B=kUT1-dNwfh4rQnAoMpseVLEDtEq+icP9Fdhb5OZocBzQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_checksums?  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: pg_checksums?
Re: pg_checksums?
List pgsql-general


On Mon, 30 Oct 2023 at 14:46, Ron <ronljohnsonjr@gmail.com> wrote:
Erroneously thinking that Percona develops Patroni. :D

IIRC, they may have made one or two contributions, but very minor.
But anyway, Patroni is orthogonal to pg_checksums.

As Michael already said, the following workflow works just fine (I did it dozens of times):
1. enable checksums on the standby node
2. start the standby and let it catch up with the primary
3. switchover to a standby node
4. enable checksums on the former primary (now replica).

Regards,
--
Alexander Kukushkin

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: pg_checksums?
Next
From: David Ventimiglia
Date:
Subject: Help with a good mental model for estimating PostgreSQL throughput