i want to setup postgres high availability cluster with one Master (Primary DB) and two Slaves (Standby) along with PGPOOL for load balancing.
Postgres version 15
Im using repmgr for streaming replication setup and automatic failover.
Requirement
- to have synchronous streaming replication between Master and Slave to have consistent data and avoid any data loss.
- Standby need to accept read connections.
Question:
- List item
If we want to set Slave to accept application read connections via pgpool we need to set hot_standby = on, adding to that we need to set few other parameters max_standby_archive_delay and max_standby_streaming_delay then in this case can we set synchronous commit on?
- Also without setting
hot_standbyto ON we can not use the standby for read operations?
