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
ifyou 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
itdoes 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