Re: Safe switchover

Greetings,

* Paul Förster (paul.foerster@gmail.com) wrote:
> I wouldn't work out the procedure myself, especially since there is a free working solution already. It's dangerous if you do it yourself and make a mistake.
> 
> In our company, we rely on Patroni (https://github.com/zalando/patroni). Yes, it uses pg_rewind in the background but it does switchover and failover fast and reliably (also for high load databases), handles timelines automatically and so on.

Patroni also has the option to use pgbackrest instead of pg_rewind.

Thanks,

Stephen