'\" t
.\"     Title: ocf_heartbeat_pgsql
.\"    Author: Linux-HA contributors (see the resource agent source for information about individual authors)
.\" Generator: DocBook XSL Stylesheets v1.76.1 <http://docbook.sf.net/>
.\"      Date: 03/09/2014
.\"    Manual: OCF resource agents
.\"    Source: resource-agents UNKNOWN
.\"  Language: English
.\"
.TH "OCF_HEARTBEAT_PGSQL" "7" "03/09/2014" "resource-agents UNKNOWN" "OCF resource agents"
.\" -----------------------------------------------------------------
.\" * Define some portability stuff
.\" -----------------------------------------------------------------
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.\" http://bugs.debian.org/507673
.\" http://lists.gnu.org/archive/html/groff/2009-02/msg00013.html
.\" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
.ie \n(.g .ds Aq \(aq
.el       .ds Aq '
.\" -----------------------------------------------------------------
.\" * set default formatting
.\" -----------------------------------------------------------------
.\" disable hyphenation
.nh
.\" disable justification (adjust text to left margin only)
.ad l
.\" -----------------------------------------------------------------
.\" * MAIN CONTENT STARTS HERE *
.\" -----------------------------------------------------------------
.SH "NAME"
ocf_heartbeat_pgsql \- Manages a PostgreSQL database instance
.SH "SYNOPSIS"
.HP \w'\fBpgsql\fR\ 'u
\fBpgsql\fR [start | stop | status | monitor | meta\-data | validate\-all]
.SH "DESCRIPTION"
.PP
Resource script for PostgreSQL\&. It manages a PostgreSQL as an HA resource\&.
.SH "SUPPORTED PARAMETERS"
.PP
\fBpgctl\fR
.RS 4
Path to pg_ctl command\&.
(optional, string, default
/usr/bin/pg_ctl)
.RE
.PP
\fBstart_opt\fR
.RS 4
Start options (\-o start_opt in pg_ctl)\&. "\-i \-p 5432" for example\&.
(optional, string, no default)
.RE
.PP
\fBctl_opt\fR
.RS 4
Additional pg_ctl options (\-w, \-W etc\&.\&.)\&.
(optional, string, no default)
.RE
.PP
\fBpsql\fR
.RS 4
Path to psql command\&.
(optional, string, default
/usr/bin/psql)
.RE
.PP
\fBpgdata\fR
.RS 4
Path to PostgreSQL data directory\&.
(optional, string, default
/var/lib/pgsql/data)
.RE
.PP
\fBpgdba\fR
.RS 4
User that owns PostgreSQL\&.
(optional, string, default
postgres)
.RE
.PP
\fBpghost\fR
.RS 4
Hostname/IP address where PostgreSQL is listening
(optional, string, no default)
.RE
.PP
\fBpgport\fR
.RS 4
Port where PostgreSQL is listening
(optional, integer, default
5432)
.RE
.PP
\fBmonitor_user\fR
.RS 4
PostgreSQL user that pgsql RA will user for monitor operations\&. If it\*(Aqs not set pgdba user will be used\&.
(optional, string, no default)
.RE
.PP
\fBmonitor_password\fR
.RS 4
Password for monitor user\&.
(optional, string, no default)
.RE
.PP
\fBmonitor_sql\fR
.RS 4
SQL script that will be used for monitor operations\&.
(optional, string, default
select now();)
.RE
.PP
\fBconfig\fR
.RS 4
Path to the PostgreSQL configuration file for the instance
(optional, integer, no default)
.RE
.PP
\fBpgdb\fR
.RS 4
Database that will be used for monitoring\&.
(optional, string, default
template1)
.RE
.PP
\fBlogfile\fR
.RS 4
Path to PostgreSQL server log output file\&.
(optional, string, default
/dev/null)
.RE
.PP
\fBsocketdir\fR
.RS 4
Unix socket directory for PostgeSQL
(optional, string, no default)
.RE
.PP
\fBstop_escalate\fR
.RS 4
Number of shutdown retries (using \-m fast) before resorting to \-m immediate
(optional, integer, no default)
.RE
.SH "SUPPORTED ACTIONS"
.PP
This resource agent supports the following actions (operations):
.PP
\fBstart\fR
.RS 4
Starts the resource\&. Suggested minimum timeout: 120\&.
.RE
.PP
\fBstop\fR
.RS 4
Stops the resource\&. Suggested minimum timeout: 120\&.
.RE
.PP
\fBstatus\fR
.RS 4
Performs a status check\&. Suggested minimum timeout: 60\&.
.RE
.PP
\fBmonitor\fR
.RS 4
Performs a detailed status check\&. Suggested minimum timeout: 30\&. Suggested interval: 30\&.
.RE
.PP
\fBmeta\-data\fR
.RS 4
Retrieves resource agent metadata (internal use only)\&. Suggested minimum timeout: 5\&.
.RE
.PP
\fBvalidate\-all\fR
.RS 4
Performs a validation of the resource configuration\&. Suggested minimum timeout: 5\&.
.RE
.PP
\fBmethods\fR
.RS 4
Suggested minimum timeout: 5\&.
.RE
.SH "EXAMPLE"
.PP
The following is an example configuration for a pgsql resource using the
\fBcrm\fR(8)
shell:
.sp
.if n \{\
.RS 4
.\}
.nf
primitive p_pgsql ocf:heartbeat:pgsql \e
  op monitor depth="0" timeout="30" interval="30" 
.fi
.if n \{\
.RE
.\}
.SH "SEE ALSO"
.PP

\m[blue]\fB\%http://www.linux-ha.org/wiki/pgsql_(resource_agent)\fR\m[]
.SH "AUTHOR"
.PP
\fBLinux\-HA contributors (see the resource agent source for information about individual authors)\fR