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?