Re: Open source HA setup for postgres

On 10/14/22 11:33, Tharmarajah, Sam wrote:
>
> Hi,
>
> We are wondering what is open-source tools being used to set up the HA. We
> are also looking for a way to pass the reads to all the HA nodes and
> writes to the primary.  One of the pressing criteria is the HA also should
> be able to handle the node being taken down during patching and should be
> able to fail back or recover seamlessly without any manual intervention.
>
> This is the first time we are embarking on HA, so would like some advice
> and caveats to avoid.
>

What I'm currently looking at is this combo:
https://repmgr.org/ (for quorum voting, fail over *and seamless fail back*)
https://pgpool.net/mediawiki/index.php/Main_Page (for a common IP address)

On a switchover (whether planned or unplanned), repgmr reconfigures PgPool
to use the New-primary's IP address.

--
Angular momentum makes the world go 'round.