ocf_heartbeat_pgsql(7)

1OCF_HEARTBEAT_PGSQL(7)        OCF resource agents       OCF_HEARTBEAT_PGSQL(7)
2
3
4

NAME

6       ocf_heartbeat_pgsql - Manages a PostgreSQL database instance
7

SYNOPSIS

9       pgsql [start | stop | status | monitor | meta-data | validate-all]
10

DESCRIPTION

12       Resource script for PostgreSQL. It manages a PostgreSQL as an HA
13       resource.
14

SUPPORTED PARAMETERS

16       pgctl
17           Path to pg_ctl command.  (optional, string, default
18           /usr/bin/pg_ctl)
19
20       start_opt
21           Start options (-o start_opt in pg_ctl). "-i -p 5432" for example.
22           (optional, string, no default)
23
24       ctl_opt
25           Additional pg_ctl options (-w, -W etc..).  (optional, string, no
26           default)
27
28       psql
29           Path to psql command.  (optional, string, default /usr/bin/psql)
30
31       pgdata
32           Path to PostgreSQL data directory.  (optional, string, default
33           /var/lib/pgsql/data)
34
35       pgdba
36           User that owns PostgreSQL.  (optional, string, default postgres)
37
38       pghost
39           Hostname/IP address where PostgreSQL is listening (optional,
40           string, no default)
41
42       pgport
43           Port where PostgreSQL is listening (optional, integer, default
44           5432)
45
46       monitor_user
47           PostgreSQL user that pgsql RA will user for monitor operations. If
48           it's not set pgdba user will be used.  (optional, string, no
49           default)
50
51       monitor_password
52           Password for monitor user.  (optional, string, no default)
53
54       monitor_sql
55           SQL script that will be used for monitor operations.  (optional,
56           string, default select now();)
57
58       config
59           Path to the PostgreSQL configuration file for the instance
60           (optional, integer, no default)
61
62       pgdb
63           Database that will be used for monitoring.  (optional, string,
64           default template1)
65
66       logfile
67           Path to PostgreSQL server log output file.  (optional, string,
68           default /dev/null)
69
70       socketdir
71           Unix socket directory for PostgeSQL (optional, string, no default)
72
73       stop_escalate
74           Number of shutdown retries (using -m fast) before resorting to -m
75           immediate (optional, integer, no default)
76

SUPPORTED ACTIONS

78       This resource agent supports the following actions (operations):
79
80       start
81           Starts the resource. Suggested minimum timeout: 120.
82
83       stop
84           Stops the resource. Suggested minimum timeout: 120.
85
86       status
87           Performs a status check. Suggested minimum timeout: 60.
88
89       monitor
90           Performs a detailed status check. Suggested minimum timeout: 30.
91           Suggested interval: 30.
92
93       meta-data
94           Retrieves resource agent metadata (internal use only). Suggested
95           minimum timeout: 5.
96
97       validate-all
98           Performs a validation of the resource configuration. Suggested
99           minimum timeout: 5.
100
101       methods
102           Suggested minimum timeout: 5.
103

EXAMPLE

105       The following is an example configuration for a pgsql resource using
106       the crm(8) shell:
107
108           primitive p_pgsql ocf:heartbeat:pgsql \
109             op monitor depth="0" timeout="30" interval="30"
110

AUTHOR

115       Linux-HA contributors (see the resource agent source for information
116       about individual authors)
117
118
119
120resource-agents 3.9.2             07/08/2011            OCF_HEARTBEAT_PGSQL(7)