I'm looking for a tool to automate PostgreSQL cluster management failover in the event the master database were to become unavailable. Currently are manually issuing a "pg_ctl promote" once we become aware that the master database has crashed.
Is repmgr a via solution? Please pass along experiences with repmgr.
Are there any other tools available to automatically issue the "promote" in the event of a master database crash?
