Hi Michael,
> On Oct 30, 2023, at 01:56, Michael Paquier <michael@xxxxxxxxxxx> wrote:
>
> > - Enable checksums on the previous primary.
> - Start the previous primary to be a standby of the node you failed
> over to.
That's exactly the reasoning behind my initial idea and question. Patroni does the switchover job for me including catching up on the latest changes, etc.
Seems that opinions vary. Are there any hard facts?
The best hard facts are those generated in your environment.
It turns out that enabling checksums can take quite some time to complete, i.e. downtime for the application which is hard to do in a 24x7 environment.
Yes. Try it first with a smaller sample.
Cheers
Paul
