Oracle^® Solaris Cluster Data Service for PostgreSQL Guide

Example: Enabling the PostgreSQL Software to Run in the Cluster

1. Create the directories for the databases and the log file.

   phys-schost-1$ mkdir /global/mnt3/postgres/data
   phys-schost-1$ mkdir /global/mnt3/postgres/logs

2. Change to the PostgreSQL root directory and initialize the data cluster.

   phys-schost-1$ cd /global/mnt3/postgres/postgresql-8.1.0 
   phys-schost-1$ ./bin/initdb -D /global/mnt3/postgres/data

3. Start the database.

   phys-schost-1$ ./bin/postmaster -D /global/mnt3/postgresql-8.1.0

4. Prepare the Oracle Solaris Cluster-specific test database.

   phys-schost-1$ ksh /opt/SUNWscPostgreSQL/util/pgs_db_prep -f \
   /global/mnt3/pgs_config -e

5. Stop the postmaster.

   phys-schost-1$ ./bin/pg_ctl -D /global/mnt3/data stop

6. Exit the postgres user ID.

   phys-schost-1$ exit

7. Encrypt the password of the monitoring user on all nodes, to run the PostgreSQL resource.

   phys-schost-1$ ksh /opt/SUNWscPostgreSQL/util/pgs_register -f \
   /global/mnt3/pgs_config -e

8. Run the pgs_register script to register the resource.

   phys-schost-1# ksh /opt/SUNWscPostgreSQL/util/pgs_register -f /global/mnt3/pgs_config

9. Add the following line to the postgresql.conf file in the PGDATA directory.

   listen_addresses = 'localhost,ha-host-1'

10. Add the following line to the pg_hba.conf file in the PGDATA directory.

    host    all         all        0.0.0.0/0      password

11. Enable the resource.

    phys-schost-1# clresource enable RS-PGS

Installing the PostgreSQL Binaries in the Default Directory (Alternative Installation)

The instructions in Installing and Configuring PostgreSQL on Shared Storage in the Global Zone or a Zone Cluster install the PostgreSQL software on shared cluster storage. You can also install this software in the default directory /usr/local/pgsql.

To install the PostgreSQL software in the default directory, perform the steps provided in the following example procedures:

• Example: Preparing the Cluster for PostgreSQL

• Example: Configuring Cluster Resources for PostgreSQL

• Example: Modifying the PostgreSQL Configuration File

• Example: Building and Installing the PostgreSQL Software in the Default Directory in the Global Zone

• Example: Enabling the PostgreSQL Software to Run in the Cluster