Hi, I have a 2-node cluster using PostgreSQL synchronous streaming replication. I don't have preference of the location of the master role. I followed this documentation : http://clusterlabs.org/wiki/PgSQL_Replicated_Cluster, and it the replication works great.
I just have a question about the PGSQL.lock file. When the master crashes (node A), the resources switches on the hot standby slave (node B), it's OK. I can create record on the DB of node B. But when the old master restart (node A), I have an error "My data may be inconsistent" because there is the PGSQL.lock file on this node. I don't understand why this file is not deleted on start when the master role is on another node of the cluster. In my mind, I'd like it to work like that : When A crashes, Master role switches on the second node (B) and it has the last data because it's a synchronous replication. So it become the reference. So, when the node A restart, pacemaker put it on slave (hot standby), activate the replication and that's all. Later, if B crashes, master roles switches to A, etc .... When I delete manually the PGSQL.lock, all works great : the slave synchronizes to the master. Is there a way to do that automatically ? Is there a function in the pgsql RA where pacemaker can delete this lock file when the master role is already on another node in the cluster ? Thanks in advance for your help. Damien
_______________________________________________ Users mailing list: Users@clusterlabs.org http://clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org