HP Serviceguard Contributed Toolkit Suite Version A.04.02.02 on Linux User Guide (December, 2012)

1. Create a directory for the package on all the cluster nodes using the following command:
# mkdir $SGCONF/pkg/pgsql
2. cd to the package directory.
3. Create the package configuration and control templates using the cmmakepkg command:
# cmmakepkg –m tkit/pgsql/pgsql pgsql_pkg.conf
4. Edit the following attributes manually in the package configuration file. Table 14 (page 33)
lists all the attributes that you can edit manually in the package configuration file.
Table 14 List of attributes that you can edit
DescriptionAttribute
This directory holds the toolkit configuration file. This
parameter directs cmapplyconf to generate the
TKIT_DIR
hapgsql.conf file under this directory. To put the
toolkit into maintenance mode, create pgsql.debug
file under this directory. This is synonymous with the
package directory acronym.
This is the path of the directory where database files
resides. It must be unique across all the PostgreSQL
toolkit packages.
DATA_DIRECTORY
NOTE: PostgreSQL toolkit does not support online
modification of this attribute.
This is the path of the PostgreSQL log file. The default
value is /var/lib/pgsql/pgsql1.log. Ensure that
LOG_FILE
the name is unique across all the PostgreSQL toolkit
Packages.
For Example: LOG_FILE /var/lib/pgsql/
pgsql1.log
NOTE: PostgreSQL toolkit does not support online
modification of this attribute.
This parameter is used to bring this toolkit into
maintenance mode. If this parameter is set to yes, then
MAINTENANCE_FLAG
it enables maintenance feature in the toolkit. PostgreSQL
toolkit searches pgsql.debug file in the PostgreSQL
toolkit package file directory where all the PostgreSQL
toolkit files are located.
If the file exists, monitoring is paused, and you can bring
down PostgreSQL for maintenance. The package does
not fail over to the adoptive node even though
PostgreSQL instance is brought down for maintenance.
After the maintenance work, ensure that PostgreSQL is
brought up. You must delete the pgsql.debug file in
the package directory. This enables the toolkit to
continue monitoring PostgreSQL server application.
NOTE: If the Maintenance flag is set to no, then this
feature does not work.
The time interval in seconds to monitor the PostgreSQL
server instance. The default value is 30.
MONITOR_INTERVAL
The number of trials attempted by the toolkit script to
check the PostgreSQL server daemon before giving up
and exiting. The default value is 0.
RETRY_TIMES
Using PostgreSQL toolkit 33