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_opt
Start options (-o start_opt in pg_ctl). "-i -p 5432" for example. (optional, string, no default)
ctl_opt
Additional 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
)
pghost
Hostname/IP address where PostgreSQL is listening (optional, string, no default)
pgport
Port where PostgreSQL is listening
(optional, integer, default 5432
)
monitor_user
PostgreSQL user that pgsql RA will user for monitor operations. If it's not set pgdba user will be used. (optional, string, no default)
monitor_password
Password for monitor user. (optional, string, no default)
monitor_sql
SQL script that will be used for monitor operations.
(optional, string, default select now();
)
config
Path 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
)
socketdir
Unix socket directory for PostgeSQL (optional, string, no default)
stop_escalate
Number 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.