From: | "Michel SALAIS" <msalais(at)msym(dot)fr> |
---|---|
To: | "'Sbob'" <sbob(at)quadratum-braccas(dot)com>, "'Pgsql-admin'" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | RE: Failover / repmgr questions |
Date: | 2023-02-03 12:50:59 |
Message-ID: | 01ca01d937ce$2ac90cb0$805b2610$@msym.fr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)quadratum-braccas(dot)com>
Envoyé : mardi 24 janvier 2023 20:26
À : Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Gambhir Singh | 2023-02-03 15:09:38 | Fwd: Performance Tool - PostgreSQL |
Previous Message | Sonia Valeja | 2023-02-03 07:03:57 | Re: Postgres Monitoring |