man ocf_heartbeat_pgsql (7): 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"

AUTHOR