Re: Postresql HA 2 nodes

On 5/16/23 16:30, Marcello Lorenzi wrote:
> Hi everyone,
> we're looking for the best solution for a 2-nodes cluster in HA with 
> Postegresql 15. after some checks we are noticed about pgpool for the 
> management of balancing and automatic failover. Can it be considered a 
> viable and manageable solution for production?

I implemented a 2/3-node HA system with Postgresql 13 and PgPool. Not in 
production yet, but seems stable.

By 2/3, I mean that there are 2 Pg nodes, and PgPool is installed on them 
plus a 3rd (smaller) VM.  You really need 3 nodes for quorum voting.

-- 
Born in Arizona, moved to Babylonia.