Hello! I use Postgresql+Pacemaker+Corosync cluster with 2 Postgresql instances in synchronous replication mode. Parameter “rep_mode” is set to "sync", and when I shut down replica normal way, primary node swithes to the async mode. But when I shut down the replica by powering it off to emulate power unit failure, primary remains in sync mode and clients hang on INSERT operations until "pcs resource cleanup" is performed. I created an alert agent to run "pcs resource cleanup" when any node is lost, but this approach doesn’t work. What should I do to be sure the primary node will switch to async mode if replica becomes lost for any cause? Best regards, Sergey Cherukhin |
_______________________________________________ Manage your subscription: https://lists.clusterlabs.org/mailman/listinfo/users
ClusterLabs home: https://www.clusterlabs.org/
