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)

AUTHOR

       Linux-HA contributors (see the resource agent source for information about individual
       authors)