Example: Enabling the PostgreSQL Software to Run in the Cluster

Language:

Create the directories for the databases and the log file.

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

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

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

Start the database.

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

Prepare the Oracle Solaris Cluster-specific test database.

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

Stop the postmaster.

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

Add the following line to the /postgres/data/postgresql.conf file.
```
listen_addresses = 'localhost,ha-host-1'
```
Add the following line to the /postgres/data/pg_hba.conf file.
```
host    all         all        0.0.0.0/0      password
```
Encrypt the password of the monitoring user on the zone, to run the PostgreSQL resource.
```
zone# ksh /opt/SUNWscPostgreSQL/util/pgs_register -f /global/mnt3/pgs_config -e
```
Leave the zone.
```
zone$ exit
```

Run the pgs_register script to register the resource.

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

Installing the PostgreSQL Binaries in the Default Directory in a Non-Global Zone With HA for Solaris Zones (Alternative Installation)

The example instructions in Installing and Configuring PostgreSQL on Shared Storage in a Non-Global Zone with HA for Solaris Zones install the PostgreSQL software on shared cluster storage. You can also install this software into the default directory /usr/local/pgsql by following the instructions in this section.

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