Skip Navigation Links | |
Exit Print View | |
Oracle Solaris Cluster Data Service for PostgreSQL Guide Oracle Solaris Cluster 3.3 3/13 |
1. Installing and Configuring HA for PostgreSQL
A. Files for Configuring Oracle Solaris Cluster HA for Solaris PostgreSQL Resources
B. Deployment Example: Installing PostgreSQL in the Global Zone
C. Deployment Example: Installing PostgreSQL in a Non-Global HA Container
D. Deployment Example: Installing PostgreSQL in a Non-Global Zone
Installing and Configuring PostgreSQL on Shared Storage in a Non-Global Zone
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 on Shared Storage in a Zone
Installing the PostgreSQL Binaries in the Default Directory in a Zone (Alternative Installation)
Example: Building and Installing the PostgreSQL Software in the Default Directory in a Zone
E. Deployment Example: Installing PostgreSQL in the Global Zone Using WAL File Shipping
This task will initialize your database, it is essential, that you perform it on one node only.
zone-1$ mkdir /global/mnt3/postgres/data zone-1$ mkdir /global/mnt3/postgres/logs
zone-1$ cd /postgres/postgresql-8.1.0 zone-1$ ./bin/initdb -D postgres/data
zone-1$ ./bin/postmaster -D /postgresql-8.1.0
zone-1$ ksh /opt/SUNWscPostgreSQL/util/pgs_db_prep -f \ /tmp/pgs_config -e
zone-1$ ./bin/pg_ctl -D /postgres/data stop
listen_addresses = 'localhost,ha-host-1'
host all all 0.0.0.0/0 password
zone-1$ exit
zone-1$ ksh /opt/SUNWscPostgreSQL/util/pgs_register -f /tmp/pgs/config -e zone-2$ ksh /opt/SUNWscPostgreSQL/util/pgs_register -f /tmp/pgs/config -e
phys-schost-1# ksh /opt/SUNWscPostgreSQL/util/pgs_register -f /global/mnt3/pgs_config
phys-schost-1# clresource enable RS-PGS