Support of synchronized commit in PG HA
Summary
Support PG synchronized commit in PG HA for higher level of data consistency between master and standby
Proposal
According to PG documentation at https://www.postgresql.org/docs/10/warm-standby.html#SYNCHRONOUS-REPLICATION, if synchronous_commit=on
and synchronous_standby_names
is set the commit will only return if the transaction is written to disk on both master and standby. If we could automate the setup of synchronous_standby_names
and handle the failover it would add another level of data consistency in our PG HA solution.