ocf_heartbeat_pgsql — Manages a PostgreSQL database instance
pgsql [ start | stop | status | monitor | meta-data | validate-all ]
pgctl
Path to pg_ctl command.
(optional, string, default /usr/bin/pg_ctl)
start_optStart options (-o start_opt in pg_ctl). "-i -p 5432" for example. (optional, string, no default)
ctl_optAdditional pg_ctl options (-w, -W etc..). (optional, string, no default)
psql
Path to psql command.
(optional, string, default /usr/bin/psql)
pgdata
Path to PostgreSQL data directory.
(optional, string, default /var/lib/pgsql/data)
pgdba
User that owns PostgreSQL.
(optional, string, default postgres)
pghostHostname/IP address where PostgreSQL is listening (optional, string, no default)
pgport
Port where PostgreSQL is listening
(optional, integer, default 5432)
monitor_userPostgreSQL user that pgsql RA will user for monitor operations. If it's not set pgdba user will be used. (optional, string, no default)
monitor_passwordPassword for monitor user. (optional, string, no default)
monitor_sql
SQL script that will be used for monitor operations.
(optional, string, default select now();)
configPath to the PostgreSQL configuration file for the instance (optional, integer, no default)
pgdb
Database that will be used for monitoring.
(optional, string, default template1)
logfile
Path to PostgreSQL server log output file.
(optional, string, default /dev/null)
socketdirUnix socket directory for PostgeSQL (optional, string, no default)
stop_escalateNumber of shutdown retries (using -m fast) before resorting to -m immediate (optional, integer, no default)
This resource agent supports the following actions (operations):
start
Starts the resource. Suggested minimum timeout: 120.
stop
Stops the resource. Suggested minimum timeout: 120.
status
Performs a status check. Suggested minimum timeout: 60.
monitor
Performs a detailed status check. Suggested minimum timeout: 30. Suggested interval: 30.
meta-data
Retrieves resource agent metadata (internal use only). Suggested minimum timeout: 5.
validate-all
Performs a validation of the resource configuration. Suggested minimum timeout: 5.
methods
Suggested minimum timeout: 5.