/ ocf:pgsql
	ocf:oralsnr		ocf:pingd

Name

ocf:pgsql — pgsql resource agent

Synopsis

[OCF_RESKEY_pgctl=string] [OCF_RESKEY_start_opt=string] [OCF_RESKEY_ctl_opt=string] [OCF_RESKEY_psql=string] [OCF_RESKEY_pgdata=string] [OCF_RESKEY_pgdba=string] [OCF_RESKEY_pghost=string] [OCF_RESKEY_pgport=string] [OCF_RESKEY_pgdb=string] [OCF_RESKEY_logfile=string] [OCF_RESKEY_stop_escalate=string] 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

OCF_RESKEY_pgctl=pgctl: Path to pg_ctl command.
OCF_RESKEY_start_opt=start_opt: Start options (-o start_opt in pgi_ctl). "-i -p 5432" for example.
OCF_RESKEY_ctl_opt=ctl_opt: Additional pg_ctl options (-w, -W etc..). Default is ""
OCF_RESKEY_psql=psql: Path to psql command.
OCF_RESKEY_pgdata=pgdata: Path PostgreSQL data directory.
OCF_RESKEY_pgdba=pgdba: User that owns PostgreSQL.
OCF_RESKEY_pghost=pghost: Hostname/IP Addreess where PosrgeSQL is listening
OCF_RESKEY_pgport=pgport: Port where PosrgeSQL is listening
OCF_RESKEY_pgdb=pgdb: Database that will be used for monitoring.
OCF_RESKEY_logfile=logfile: Path to PostgreSQL server log output file.
OCF_RESKEY_stop_escalate=stop escalation: Number of retries (using -m fast) before resorting to -m immediate