Rechercher une page de manuel
ocf_heartbeat_pgsql
Langue: en
Version: 10/07/2010 (fedora - 01/12/10)
Section: 7 (Divers)
NAME
ocf_heartbeat_pgsql - Manages a PostgreSQL database instanceSYNOPSIS
- pgsql [start | stop | status | monitor | 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, integer, no default)
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, no default)
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
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)
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre