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

NOTE:
• Each node must have the same version of the PostgreSQL application.
• Each node must have the same configuration directory where identical copies of the
configuration files for each instance are placed in the local or shared hard disk.
• Each node must have the same file system directories to access the same shared storage.
Shared configuration
In a shared configuration, the configuration and database files are placed all on the shared storage.
The same PostgreSQL data and configuration file are shared between the cluster nodes, so you
need not maintain identical copies on each node. In a cluster environment, each PostgreSQL
database server instance must have unique IP addresses.
When the package is created, one or more relocatable IP addresses are created for each
PostgreSQL database server. When the PostgreSQL database server package switches over from
one node to another, this instance is stopped, IP addresses are removed from the primary node,
IP addresses are reallocated to a standby node, and the instance is started on that node. Clients
are automatically connected or manually reconnected through these IP addresses to the identical
PostgreSQL database server on the standby node.
Multiple PostgreSQL Instances Configuration
PostgreSQL database server supports multiple-instance configuration on the same node. Using the
PostgreSQL toolkit, you can configure multiple PostgreSQL toolkit packages to run on the same
node. Each copy of the PostgreSQL toolkit serves exactly one package. So, to configure multiple
packages, you must create separate directories, one per package, and configure each package
to run a unique database instance.
Using PostgreSQL toolkit
After installing the PostgreSQL toolkit, you can use the toolkit to:
• Configure packages in an SSG/LX environment
• Manage packages
Configuring PostgreSQL toolkit packages
You can configure PostgreSQL toolkit packages using either legacy or modular style of packaging.
Configuring legacy PostgreSQL toolkit packages
To configure legacy PostgreSQL toolkit packages:
1. Create a directory for the package on all the cluster nodes using the following command:
# mkdir ${SGCONF}/pkg/postgresql
2. Copy the toolkit files from ${SGCONF}/postgresqltoolkit to the package directory
${SGCONF}/pkg/postgresql.
3. cd to the package directory.
4. Create the package configuration and control templates using the cmmakepkg command:
Configuration template: # cmmakepkg -p pgsql_pkg.conf
Control template:# cmmakepkg -s pgsql_pkg.cntl
30 PostgreSQL Toolkit