Hello, I am looking after some advice about solution allowing to increase High availability?
Here is a bit of context : I have an Master-Slave architecture - 1 master - 2 asynchronous slaves using replication slot - backup is made with barman using replication slot - Wal archiving is done towards barman server I think 3 axes could be improved ( I am totaly novice with these): - using of a proxy I found HAproxy. Could you advice any others solutions to explore or share your experience? - using an automatick failover I found PAF Could you advice any others solutions to explore or share your experience? - using a tool for fencing a failing node Ideally, I aimagine to disable network traffic in I/O to prevent client connecting and exchange between backup server failling server + on postgesql server disable automatic restart of the service. Could you share you experience about it? - Maybe an other axe to explore ? Thank you Thomas