Thanks for you're feedback.
For sure I would like also to use streaming replication with synchronous commits. I would be more secure.. but on your stdby you have configure a script to become the primary automatically?
Le sam. 3 nov. 2018 à 17:45, Rui DeSousa <rui@xxxxxxxxxxxxx> a écrit :
For an HA setup I would highly recommend using streaming replication with synchronous commits. There is no reason to risk losing a single committed transaction in a HA setup. As far as managing the system which I believe your question is more about; that is going to depend on your environment and there are numerous cluster solutions out there; personally I use a CARP based solution.
For DR it’s more customary to use asynchronous replication due to the high latency in most DR setups thus there is a risk of losing committed transactions.
--
