PostgreSQL 12 High Availability Cookbook - Third Edition

There's more...

Though we used systemd to manage PostgreSQL, the resource-agents repository package installed with Pacemaker contains a resource agent specifically designed for PostgreSQL. However, its usage is far more complicated. It can also monitor PostgreSQL by querying it instead of simply using a process ID test. If you want to use this agent instead, follow these steps as root:

1. Set the path of pg_ctl with this command:

export CTL=$(pg_config --bindir)/pg_ctl

2. Add the pgsql resource agent as primary with this command:

crm configure primitive pg_agent ocf:heartbeat:pgsql \
    params pgctl="$CTL" \
           pgdata="/db/pgdata" \
    op monitor interval="30" timeout="60" \
    op start interval="0" timeout="60" \
 op stop interval="0" timeout="60" ...