SYNOPSIS

pgsql [start | stop | status | monitor | promote | demote | 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, string, default "/var/lib/pgsql/data/postgresql.conf")

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, default 30)

rep_mode

Replication mode(none(default)/async/sync). "async" and "sync" require PostgreSQL 9.1 or later. If you use async or sync, it requires node_list, master_ip, restore_command parameters, and needs setting postgresql.conf, pg_hba.conf up for replication. Please delete "include /../../rep_mode.conf" line in postgresql.conf when you switch from sync to async.

(optional, string, default "none")

node_list

All node names. Please separate each node name with a space. This is required for replication.

(optional, string, no default)

restore_command

restore_command for recovery.conf. This is required for replication.

(optional, string, no default)

archive_cleanup_command

archive_cleanup_command for recovery.conf. This is used for replication and is optional.

(optional, string, no default)

recovery_end_command

recovery_end_command for recovery.conf. This is used for replication and is optional.

(optional, string, no default)

master_ip

Master's floating IP address to be connected from hot standby. This parameter is used for "primary_conninfo" in recovery.conf. This is required for replication.

(optional, string, no default)

repuser

User used to connect to the master server. This parameter is used for "primary_conninfo" in recovery.conf. This is required for replication.

(optional, string, default "postgres")

primary_conninfo_opt

primary_conninfo options of recovery.conf except host, port, user and application_name. This is optional for replication.

(optional, string, no default)

tmpdir

Path to temporary directory. This is optional for replication.

(optional, string, default "/var/lib/pgsql/tmp")

xlog_check_count

Number of checking xlog on monitor before promote. This is optional for replication.

(optional, integer, no default)

crm_attr_timeout

The timeout of crm_attribute forever update command. Default value is 5 seconds. This is optional for replication.

(optional, integer, default 5)

stop_escalate_in_slave

Number of shutdown retries (using -m fast) before resorting to -m immediate in Slave state. This is optional for replication.

(optional, integer, 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.

monitor (Master role)

Performs a detailed status check. Suggested minimum timeout: 30. Suggested interval: 29.

promote

Promotes the resource to the Master role. Suggested minimum timeout: 120.

demote

Demotes the resource to the Slave role. Suggested minimum timeout: 120.

notify

Suggested minimum timeout: 90.

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" \
  op monitor depth="0" timeout="30" interval="29" role="Master"
ms ms_pgsql p_pgsql \
  meta notify="true" interleave="true"

RELATED TO ocf_heartbeat_pgsql…

\m[blue]http://www.linux-ha.org/wiki/pgsql_(resource_agent)\m[]

AUTHOR

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