Scroll to navigation

OCF_HEARTBEAT_PGSQL(7) OCF resource agents 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)
02/03/2011 resource-agents 1.0.3