Re: [ClusterLabs] PAF recover master after crash

2022-01-21 Thread Jehan-Guillaume de Rorthais
Le Fri, 21 Jan 2022 18:17:04 +0100, damiano giuliani a écrit : > Ehy, > > Take in account when a master node crash, you should re-allign the old > master into the slave using pg_basebackup/pg_rewind and then rejoin the > node into the cluster as a slave. This is the only way to avoid data >

Re: [ClusterLabs] PAF recover master after crash

2022-01-21 Thread damiano giuliani
Ehy, Take in account when a master node crash, you should re-allign the old master into the slave using pg_basebackup/pg_rewind and then rejoin the node into the cluster as a slave. This is the only way to avoid data corruption and be sure the new slave is correcly synchronised with the new

[ClusterLabs] PAF recover master after crash

2022-01-21 Thread Miro Igov
Hello, I have a 2 node cluster with pgsqlms and sbd fencing. I tested the failover by resetting the VM running the postgresql master, it promoted the other node. When i started pacemaker on fenced node i get this error: Instance "pgsqld" controldata indicates a running primary instance,