HP Serviceguard Linux Contributed Toolkit Suite A.04.02.01 User Guide (696979-001, June 2012)

4 PostgreSQL Toolkit
Overview
HP Serviceguard toolkit for PostgreSQL on Linux (PostgreSQL toolkit) enables you to integrate the
PostgreSQL database server with HP Serviceguard. Using PostgreSQL toolkit simplifies application
integration, and eases deployment and maintenance of applications in a cluster environment. The
PostgreSQL toolkit consists of a set of shell scripts that are used by the package control script to
start, stop, and monitor the PostgreSQL database server. The toolkit simplifies integrating PostgreSQL
with SG/LX.
The node where the PostgreSQL database server runs is termed as “Primary” node. The other nodes
configured to take up the service in case of failure are termed as “Standby” nodes. The PostgreSQL
database server application runs on the primary node serving PostgreSQL database requests from
clients. If the primary node fails, the package fails over to the standby node. Ensure that all the
necessary configuration details on all the nodes are identical and the resources are available to
all the supporting nodes. The data must be stored on shared disks and these disks must be accessible
by the same path names on each node.
Advantages
When PostgreSQL toolkit is deployed in an SG/LX cluster, following are the advantages:
• Provides monitoring for PostgreSQL daemons.
• Enables easy integration of PostgreSQL server in an SG/LX environment.
• Provides high availability for the PostgreSQL server.
Prerequisites
PostgreSQL toolkit package requires the following to function:
• HP Serviceguard on Linux must be installed on all the nodes that must be configured in the
cluster.
• The toolkit must be installed on all the target nodes, where the package is configured to run.
• PostgreSQL server must be installed and the database is configured on the storage that is
shared between all the nodes that are configured to run the database.
Installing and uninstalling PostgreSQL toolkit
The PostgreSQL toolkit is bundled within the HP Serviceguard on Linux Contributed toolkit suite.
The PostgreSQL toolkit must be installed on all the nodes of the cluster that are configured to run
the PostgreSQL database server package.
NOTE: Before installing this version of the toolkit, you must verify and remove any earlier version
of this toolkit that might be installed on the system.
To search for any earlier version of PostgreSQL toolkit, run # rpm –qa | grep
postgresql-toolkit.
To remove the earlier version, run:
# rpm –e <toolkit name retrieved after executing the # rpm –qa | grep
postgresql-toolkit>
To ensure that the earlier version of the PostgreSQL toolkit is removed from all the configured nodes
of the cluster, run the # rpm –qa command on all the nodes configured to run the PostgreSQL
web server package.
To install the PostgreSQL toolkit on Red Hat, run the command:
Overview 27