RE: Failover / repmgr questions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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...


-----Message d'origine-----
De : Sbob <sbob@xxxxxxxxxxxxxxxxxxxxx> 
Envoyé : mardi 24 janvier 2023 20:26
À : Pgsql-admin <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Objet : Failover / repmgr questions


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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux