Re: Safe switchover - Mailing list pgsql-general

From Stephen Frost
Subject Re: Safe switchover
Date
Msg-id 20200710152959.GK12375@tamriel.snowman.net
Whole thread Raw
In response to Re: Safe switchover  (Paul Förster <paul.foerster@gmail.com>)
Responses Re: Safe switchover
List pgsql-general
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

Attachment

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: invalid non-zero objectSubId for object class
Next
From: Paul Förster
Date:
Subject: Re: Safe switchover