Hello Robin, Sorry to jump in this thread so lately, I was on holidays :) Considering the failover subject, did you check the PAF project as well? It relies on Pacemaker, the industry standard for high availability under Linux.
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных