Hi all, if there are several PostgreSQL nodes replicating synchronous and I configure a guarantee that for example 3 of 5 nodes have to be in sync to go on with synchronous_standby_names and now I want to implement a load balancing scenario with active standby DBs...how or with what tool can I achieve that my read clients only use sync nodes. For sure somehow a check in the pg_stat_replication before is possible but is there something in parameters or with solutions like repmgr, patroni, etc. to do this?
Thanks and best regards Dirk
