Re: Operating of synchronous master when no standby is available

2023-10-03 Thread Sergey Cherukhin
Thank you for your answer. вт, 3 окт. 2023 г., 17:22 MATSUO Takatoshi : > It's not normal behavior. > > Pgsql RA is developed here. > https://github.com/ClusterLabs/resource-agents/blob/main/heartbeat/pgsql > You may get better advice if you ask on this mailing list. > https://oss.clusterlabs.org

Re: Operating of synchronous master when no standby is available

2023-10-03 Thread MATSUO Takatoshi
It's not normal behavior. Pgsql RA is developed here. https://github.com/ClusterLabs/resource-agents/blob/main/heartbeat/pgsql You may get better advice if you ask on this mailing list. https://oss.clusterlabs.org/mailman/listinfo/users 2023年10月3日(火) 18:03 Sergey Cherukhin : > I already have re

Re: Operating of synchronous master when no standby is available

2023-10-03 Thread Sergey Cherukhin
I already have rep_mode set to "sync", but the primary node switches to async mode only if the replica is shutted down correctly. When I shut down the replica by powering it off to emulate power unit failure, primary remains in sync mode until "pcs resource cleanup" is performed. I think it is poss

Re: Operating of synchronous master when no standby is available

2023-10-02 Thread MATSUO Takatoshi
Pgsql RA has rep_mode=sync parameter. https://wiki.clusterlabs.org/wiki/PgSQL_Replicated_Cluster 2023年10月2日(月) 23:48 Sergey Cherukhin : > Hello! > > I use Postgresql+Pacemaker+Corosync cluster with 2 Postgresql instances in > synchronous replication mode. When one of the nodes is down, clients h

Re: Operating of synchronous master when no standby is available

2023-10-02 Thread Ron
On 10/2/23 03:54, Sergey Cherukhin wrote: Hello! I use Postgresql+Pacemaker+Corosync cluster with 2 Postgresql instances in synchronous replication mode. When one of the nodes is down, clients hang on INSERT operations because the primary server waits until standby confirms that it got the da

Re: Operating of synchronous master when no standby is available

2023-10-02 Thread Andreas Kretschmer
Am 02.10.23 um 10:54 schrieb Sergey Cherukhin: Hello! I use Postgresql+Pacemaker+Corosync cluster with 2 Postgresql instances in synchronous replication mode. When one of the nodes is down, clients hang on INSERT operations because the primary server waits until standby confirms that it go