Sun Cluster Data Service for PostgreSQL Guide for Solaris OS

Appendix A File for Configuring Sun Cluster HA for Solaris PostgreSQL Resources

The /opt/SUNWscPostgreSQL/util directory contains files that automate the process of configuring Sun Cluster HA for PostgreSQL resources. These files include a registration script, a database preparation script, and a configuration file, to provide parameters for the first two scripts. This appendix shows a listing of the configuration file.

Listing of pgs_config


#
# Copyright 2006 Sun Microsystems, Inc.  All rights reserved.
# Use is subject to license terms.
#
# This file will be sourced in by pgs_register and the parameters
# listed below will be used.
#
# These parameters can be customized in (key=value) form
#
#                RS - name of the resource for the application.
#                RG - name of the resource group containing RS.
#              PORT - name of the port number.
#                     Do not set the PORT variable if you plan to have a network
#                     unaware installation, or an installation in a failover zone.
#                LH - name of the LogicalHostname SC resource.
#                     Do not set the LH variable if you plan to have a network
#                     unaware installation, or an installation in a failover zone.
#            HAS_RS - Name of the HAStoragePlus SC resource.
#             PFILE - Parameter file which contains the PostgreSQL specific
#                     parameters, this file will be created by the register script.
#
# The following variables need to be set only, if the agent runs in a
# failover zone
#
#              ZONE - Zonename where the zsmf component should be registered
#           ZONE_BT - Resource name of the zone boot component
#           PROJECT - A project in the zone, that will be used for the PostgreSQL
#                     smf service.
#                     If the variable is not set it will be translated as :default for 
#	                     the smf credentials.
#                     Optional
#

RS=
RG=
PORT=
LH=
HAS_RS=
PFILE=

# failover zone specific options

ZONE=
ZONE_BT=
PROJECT=

#
# Content for the parameter file
#
#            USER - The Solaris user which owns the PostgreSQL database.
#          PGROOT - Contains the path to the PostgreSQL directory. Below this
#                   directory the postgres binaries are located in the ./bin
#                   directory.
#          PGDATA - Contains the path to the databases of this specific PostgreSQL
#                   instance.
#          PGPORT - Port where the postmaster process will be listening to.
#       PGLOGFILE - Logfile where the log messages of the postmaster will be stored.
# LD_LIBRARY_PATH - This path contains all the necessary libraries for this PostgreSQL
#                   installation.
#                   Optional
#       ENVSCRIPT - Script to contain PostgreSQL specific runtime variables.
#                   Optional
#            SCDB - This database will be monitored. The database will be generated at 
#                   database preparation time.
#          SCUSER - PostgresSQL user to connect to the $SCDB database. The user will be 
#                   generated at database preparation time.
#         SCTABLE - Table name in the $SCDB database. This table name will be manipulated
#                   to check if PostgreSQL is alive. This table will be generated at database
#                   preparation time.
#          SCPASS - Password of the SCUSER
#                   Optional
#        NOCONRET - Return code for connection errors. This return code has to follow the 
#                   rules for the generic data service. The value has to be between 1 and 100.
#                   100/NOCONRET defines the number of consecutive probes to ignore for
#                   failed connections. A restart or failover will occur, if the number is
#                   exeeded within the retry interval.

USER=
PGROOT=
PGDATA=
PGPORT=
PGLOGFILE=
LD_LIBRARY_PATH=
ENVSCRIPT=
SCDB=
SCUSER=
SCTABLE=
SCPASS=
NOCONRET=10