>
> On Oct 30, 2023 at 7:00 PM, Paul Förster <paul(dot)foerster(at)gmail(dot)com> wrote:
>
>
> Hi Michael,
>
> > On Oct 30, 2023, at 01:56, Michael Paquier <michael(at)paquier(dot)xyz> 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
>
>