<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div class="elementToProof" style="font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi Jehan-Guillaume,</div>
<div class="elementToProof" style="font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thanks for your links, but I already had a look at them when using Pacemaker for the first time (except for the last one).</div>
<div class="elementToProof" style="font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Actually, I forgot to mention that PostgreSQL and pacemaker are run on a Debian GNU/Linux system (latest "Bookworm" release); on reboot, Pacemaker is stopped using "systemctl stop" , and resources *seems* to be migrated correctly to promoted slave.</div>
<div class="elementToProof" style="font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
When the previous master is restarted, Pacemaker is actually restarted automatically and instantly promoted as new master; it *seems* that it's at this moment that a new timeline is sometimes created on backup server...</div>
<div class="elementToProof" style="font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Don't you think that I should disable automatic restarting of Pacemaker on the master server, and handle promotion manually when a switch occurs?</div>
<div class="elementToProof" style="font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class="elementToProof" style="font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Best regards,</div>
<div class="elementToProof" style="font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Thierry</div>
<div id="Signature">
<p style="background-color: white;"><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: black;">--<b><br>
Thierry Florac</b></span></p>
<p style="background-color: white;"><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 11pt; color: black;">Resp. Pôle Architecture Applicative et Mobile</span><span style="font-family: Arial, sans-serif; font-size: 8pt; color: black;"><br>
</span><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 11pt; color: black;">DSI - Dépt. Études et Solutions Tranverses</span><span style="font-family: Arial, sans-serif; font-size: 8pt; color: black;"><br>
</span><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(12, 35, 2);">2 bis avenue du Général Leclerc - CS 30042</span><span style="font-family: Arial, sans-serif; font-size: 8pt; color: rgb(12, 35, 2);"><br>
</span><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 11pt; color: rgb(12, 35, 2);">94704 MAISONS-ALFORT Cedex</span><span style="font-family: Arial, sans-serif; font-size: 8pt; color: black;"><br>
</span><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 11pt; color: black;">Tél : 01 40 19 59 64 - 06 26 53 42 09</span><span style="font-family: Arial, sans-serif; font-size: 8pt; color: black;"><br>
</span><span style="font-family: Calibri, Helvetica, sans-serif; font-size: 11pt; color: blue;"><b><a href="https://www.onf.fr" target="_blank" rel="noopener noreferrer" style="color: blue; margin-top: 0px; margin-bottom: 0px;" data-ogsc="" data-linkindex="0" data-safelink="true" data-auth="NotApplicable">www.onf.fr</a></b></span></p>
<div style="background-color: white; border-width: 1px; border-style: solid; border-color: transparent; font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: black;">
<img style="width: 300px; height: 90px; max-width: initial;" width="300" height="90" src="https://www.ext.onf.fr/img/onf-signature.jpg">
</div>
<span style="font-family: "TW Cen MT", "Century Gothic", sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"><br>
</span></div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>De :</b> Jehan-Guillaume de Rorthais <jgdr@dalibo.com><br>
<b>Envoyé :</b> mercredi 27 mars 2024 09:04<br>
<b>À :</b> FLORAC Thierry <thierry.florac@onf.fr><br>
<b>Cc :</b> Cluster Labs - All topics related to open-source clustering welcomed <users@clusterlabs.org><br>
<b>Objet :</b> Re: [ClusterLabs] PostgreSQL server timelines offset after promote</font>
<div> </div>
</div>
<div class="BodyFragment"><font size="2"><span style="font-size:11pt;">
<div class="PlainText">Bonjour Thierry,<br>
<br>
On Mon, 25 Mar 2024 10:55:06 +0000<br>
FLORAC Thierry <thierry.florac@onf.fr> wrote:<br>
<br>
> I'm trying to create a PostgreSQL master/slave cluster using streaming<br>
> replication and pgsqlms agent. Cluster is OK but my problem is this : the<br>
> master node is sometimes restarted for system operations, and the slave is<br>
> then promoted without any problem ; <br>
<br>
When you have to do some planed system operation, you **must** diligently<br>
ask permission to pacemaker. Pacemaker is the real owner of your resource. It<br>
will react to any unexpected event, even if it's a planed one. You must<br>
consider it as a hidden colleague taking care of your resource.<br>
<br>
There's various way to deal with Pacemaker when you need to do some system<br>
maintenance on your primary, it depends on your constraints. Here are two<br>
examples:<br>
<br>
* ask Pacemaker to move the "promoted" role to another node<br>
* then put the node in standby mode<br>
* then do your admin tasks<br>
* then unstandby your node: a standby should start on the original node<br>
* optional: move back your "promoted" role to original node<br>
<br>
Or:<br>
<br>
* put the whole cluster in maintenance mode<br>
* then do your admin tasks<br>
* then check everything works as the cluster expect<br>
* then exit the maintenance mode<br>
<br>
The second one might be tricky if Pacemaker find some unexpected status/event<br>
when exiting the maintenance mode.<br>
<br>
You can find (old) example of administrative tasks in:<br>
<br>
* with pcs: <a href="https://clusterlabs.github.io/PAF/CentOS-7-admin-cookbook.html">
https://clusterlabs.github.io/PAF/CentOS-7-admin-cookbook.html</a><br>
* with crm: <a href="https://clusterlabs.github.io/PAF/Debian-8-admin-cookbook.html">
https://clusterlabs.github.io/PAF/Debian-8-admin-cookbook.html</a><br>
* with "low level" commands:<br>
<a href="https://clusterlabs.github.io/PAF/administration.html">https://clusterlabs.github.io/PAF/administration.html</a><br>
<br>
These docs updates are long overdue, sorry about that :(<br>
<br>
Also, here is an hidden gist (that needs some updates as well):<br>
<br>
<a href="https://github.com/ClusterLabs/PAF/tree/workshop/docs/workshop/fr">https://github.com/ClusterLabs/PAF/tree/workshop/docs/workshop/fr</a><br>
<br>
<br>
> after reboot, the old master is re-promoted, but I often get an error in<br>
> slave logs :<br>
> <br>
> FATAL: la plus grande timeline 1 du serveur principal est derrière la<br>
> timeline de restauration 2<br>
> <br>
> which can be translated in english to :<br>
> <br>
> FATAL: the highest timeline 1 of main server is behind restoration timeline<br>
> 2<br>
<br>
<br>
This is unexpected. I wonder how Pacemaker is being stopped. It is supposed to<br>
stop gracefully its resource. The promotion scores should be updated to reflect<br>
the local resource is not a primary anymore and PostgreSQL should be demoted<br>
then stopped. It is supposed to start as a standby after a graceful shutdown.<br>
<br>
Regards,<br>
</div>
</span></font></div>
</body>
</html>