Skip Navigation Links
Exit Print View
| Oracle Solaris Cluster Data Service for PostgreSQL Guide Oracle Solaris Cluster 4.1

Search Scope:

- This Document
- Entire Library

## 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 -e

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. 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

9. Leave the zone.

       zone$ exit

10. Run the `pgs_register` script to register the resource.

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

11. Enable the resource.

        phys-schost-1# clresource enable RS-PGS

Copyright © 2000, 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices |