Serviceguard Toolkits for Contrib User Guide Version A.12.00.00

Using PostgreSQL toolkit

After installing the PostgreSQL toolkit, you can use the toolkit to:

• Configure packages in an SG/LX environment

• Manage packages

For more information about managing packages, see Managing packages. (page 35)

Configuring PostgreSQL toolkit packages

To configure modular PostgreSQL toolkit packages:

1. Create the package configuration and control templates using the cmmakepkg command:

# cmmakepkg –m tkit/pgsql/pgsql pgsql_pkg.conf

2. Edit the following attributes manually in the package configuration file. Table 14 (page 21)

lists all the attributes that you can edit manually in the package configuration file.

Table 6 List of attributes that you can edit

DescriptionAttribute

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.

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

3. Validate the configuration using the cmcheckconf command:

# cmcheckconf -P pgsql_pkg.conf

4. Create the package using the cmapplyconf command, if the cmcheckconf command does

not report any errors:

# cmapplyconf -P pgsql_pkg.conf

5. To view the package details, run:

# cmviewcl

6. To enable package switching and start the package refer Managing packages. (page 35).

Using PostgreSQL toolkit 21