Man Linux: Main Page and Category List

NAME

       ocf_heartbeat_pgsql - Manages a PostgreSQL database instance

SYNOPSIS

       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

       pgctl
           Path to pg_ctl command. (optional, string, default /usr/bin/pg_ctl)

       start_opt
           Start options (-o start_opt in pgi_ctl). "-i -p 5432" for example.
           (optional, string, no default)

       ctl_opt
           Additional pg_ctl options (-w, -W etc..). Default is "" (optional,
           string, no default)

       psql
           Path to psql command. (optional, string, default /usr/bin/psql)

       pgdata
           Path PostgreSQL data directory. (optional, string, default
           /var/lib/pgsql/data)

       pgdba
           User that owns PostgreSQL. (optional, string, default postgres)

       pghost
           Hostname/IP Addreess where PosrgeSQL is listening (optional,
           string, no default)

       pgport
           Port where PosrgeSQL is listening (optional, string, default 5432)

       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)

       stop_escalate
           Number of retries (using -m fast) before resorting to -m immediate
           (optional, string, default 30)

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)