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 example_pgsql ocf:heartbeat:pgsql \

  op monitor depth="0" timeout="30" interval="30" 

See also

http://www.linux-ha.org/wiki/pgsql_(resource_agent)