ocf_heartbeat_pgsql(7) - Linux man page
Name
ocf_heartbeat_pgsql - Manages a PostgreSQL database instance
Synopsis
pgsql [start | stop | status | monitor | meta-data | validate-all]
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 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)
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 p_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)