OCF_HEARTBEAT_PGSQL(7)
NAME
ocf_heartbeat_pgsql - Manages a PostgreSQL database instance
SYNOPSIS
pgsql [start | stop | status | monitor | meta-data | validate-all |
methods]
DESCRIPTION
Resource script for PostgreSQL. It manages a PostgreSQL as an HA
resource.
SUPPORTED PARAMETERS
- pgctl
- Path to pg_ctl command. (optional, string, default /usr/bin/pg_ctl)
- start_opt
- Start options (-o start_opt in pgi_ctl). "-i -p 5432" for example. (optional, string, no default)
- ctl_opt
- Additional pg_ctl options (-w, -W etc..). Default is "" (optional, string, no default)
- psql
- Path to psql command. (optional, string, default /usr/bin/psql)
- pgdata
- Path PostgreSQL data directory. (optional, string, default
/var/lib/pgsql/data) - pgdba
- User that owns PostgreSQL. (optional, string, default postgres)
- pghost
- Hostname/IP Addreess where PosrgeSQL is listening (optional,
string, no default) - pgport
- Port where PosrgeSQL is listening (optional, string, default 5432)
- 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) - stop_escalate
- Number of retries (using -m fast) before resorting to -m immediate (optional, string, default 30)
SUPPORTED ACTIONS
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.
EXAMPLE
- The following is an example configuration for a pgsql resource using
the crm(8) shell: - primitive example_pgsql ocf:heartbeat:pgsql \
op monitor depth="0" timeout="30" interval="30"
SEE ALSO
http://www.linux-ha.org/wiki/pgsql_(resource_agent)
AUTHOR
- Linux-HA contributors (see the resource agent source for information about individual authors)