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]

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 p_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)

resource-agents UNKNOWN 					    03/09/2014						    OCF_HEARTBEAT_PGSQL(7)