Example: Enabling the PostgreSQL Software to Run in the Cluster

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

   zone$ mkdir /global/mnt3/postgres/data
   zone$ mkdir /global/mnt3/postgres/logs

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

   zone$ cd /postgres/postgresql-8.1.0 
   zone$ ./bin/initdb -D postgres/data

3. Start the database.

   zone$ ./bin/postmaster -D /postgresql-8.1.0

4. Prepare the Oracle Solaris Cluster specific test database.

   zone$ ksh /opt/SUNWscPostgreSQL/util/pgs_db_prep -f /tmp/pgs_config

5. Stop the postmaster.

   zone$ ./bin/pg_ctl -D /postgres/data stop

6. Add the following line to the /postgres/data/postgresql.conf file.

   listen_addresses = 'localhost,ha-host-1'

7. Add the following line to the /postgres/data/pg_hba.conf file.

   host all all 0.0.0.0/0 password

8. Leave the zone.

   zone$ exit

9. Run the pgs_register script to register the resource.

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

10. Enable the resource.

    phys-schost-1# clresource enable RS-PGS