table of contents
other versions
conflicting packages
OCF_HEARTBEAT_PGSQL(7) | OCF resource agents | OCF_HEARTBEAT_PGSQL(7) |
NAME¶
ocf_heartbeat_pgsql - Manages a PostgreSQL database instanceSYNOPSIS¶
pgsql
[start | stop | status | monitor | meta-data | validate-all]
DESCRIPTION¶
Resource script for PostgreSQL. It manages a PostgreSQL as an HA resource.SUPPORTED PARAMETERS¶
pgctlPath 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): startStarts 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¶
AUTHOR¶
Linux-HA contributors (see the resource agent source for information about individual authors)03/09/2014 | resource-agents UNKNOWN |