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.