Name

ocf:pgsql — Manages a PostgreSQL database instance

Synopsis

[OCF_RESKEY_pgctl=string] [OCF_RESKEY_start_opt=string] [OCF_RESKEY_ctl_opt=string] [OCF_RESKEY_psql=string] [OCF_RESKEY_pgdata=string] [OCF_RESKEY_pgdba=string] [OCF_RESKEY_pghost=string] [OCF_RESKEY_pgport=integer] [OCF_RESKEY_monitor_user=string] [OCF_RESKEY_monitor_password=string] [OCF_RESKEY_monitor_sql=string] [OCF_RESKEY_config=string] [OCF_RESKEY_pgdb=string] [OCF_RESKEY_logfile=string] [OCF_RESKEY_socketdir=string] [OCF_RESKEY_stop_escalate=integer] 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

OCF_RESKEY_pgctl=pgctl

Path to pg_ctl command.

OCF_RESKEY_start_opt=start_opt

Start options (-o start_opt in pg_ctl). "-i -p 5432" for example.

OCF_RESKEY_ctl_opt=ctl_opt

Additional pg_ctl options (-w, -W etc..).

OCF_RESKEY_psql=psql

Path to psql command.

OCF_RESKEY_pgdata=pgdata

Path to PostgreSQL data directory.

OCF_RESKEY_pgdba=pgdba

User that owns PostgreSQL.

OCF_RESKEY_pghost=pghost

Hostname/IP address where PostgreSQL is listening

OCF_RESKEY_pgport=pgport

Port where PostgreSQL is listening

OCF_RESKEY_monitor_user=monitor_user

PostgreSQL user that pgsql RA will user for monitor operations. If it's not set pgdba user will be used.

OCF_RESKEY_monitor_password=monitor_password

Password for monitor user.

OCF_RESKEY_monitor_sql=monitor_sql

SQL script that will be used for monitor operations.

OCF_RESKEY_config=Configuration file

Path to the PostgreSQL configuration file for the instance

OCF_RESKEY_pgdb=pgdb

Database that will be used for monitoring.

OCF_RESKEY_logfile=logfile

Path to PostgreSQL server log output file.

OCF_RESKEY_socketdir=socketdir

Unix socket directory for PostgeSQL

OCF_RESKEY_stop_escalate=stop escalation

Number of shutdown retries (using -m fast) before resorting to -m immediate