From: Michel SALAIS <msalais@msym.fr>
To: 'Sbob' <sbob@quadratum-braccas.com>
To: 'Pgsql-admin' <pgsql-admin@lists.postgresql.org>
Subject: RE: Failover / repmgr questions
Date: Fri, 3 Feb 2023 13:50:59 +0100
Message-ID: <01ca01d937ce$2ac90cb0$805b2610$@msym.fr> (raw)
In-Reply-To: <0f0742dc-fd37-cc82-061e-0fbee2911f82@quadratum-braccas.com>
References: <0f0742dc-fd37-cc82-061e-0fbee2911f82@quadratum-braccas.com>
Hi,
You can use repmgr or patroni
Repmgr can do what you want but it is not just by executing repmgr command. You have to run a daemon "repmgrd" on all nodes. Then you should activate automatic failover...
Note that a witness is not necessary to do that but it could be useful depending on what you are searching...
Michel SALAIS
-----Message d'origine-----
De : Sbob <sbob@quadratum-braccas.com>
Envoyé : mardi 24 janvier 2023 20:26
À : Pgsql-admin <pgsql-admin@lists.postgresql.org>
Objet : Failover / repmgr questions
All;
we are constructing a PostgreSQL based architecture that is more complex than "promote node B and manage the IP" for a failover.
It would be ideal if I could deploy repmgr and have repmgr run a script for me if it detects a failure, but it looks like this may not be an option. Anyone know if I can force repmgr to do this? Is there a better tool that does?
Thanks in advance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: msalais@msym.fr, sbob@quadratum-braccas.com, pgsql-admin@lists.postgresql.org
Subject: RE: Failover / repmgr questions
In-Reply-To: <01ca01d937ce$2ac90cb0$805b2610$@msym.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox