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
Example: Enabling the PostgreSQL Software to Run in the Cluster
Installing the PostgreSQL Binaries in the Default Directory in a Zone (Alternative Installation)
E. Deployment Example: Installing PostgreSQL in the Global Zone Using WAL File Shipping
This example illustrates how to install the PostgreSQL software in the default directory /usr/local/pgsql. You can also build and install the PostgreSQL binaries on shared storage. See Installing and Configuring PostgreSQL on Shared Storage in a Non-Global Zone.
Before You Begin
You can only install the PostgreSQL software in the default directory if one of the following conditions is true:
/usr is not inherited
/usr/local/pgsql is linked to somewhere in the global zone
If /usr/local/pgsql is linked to the global zone, create this directory in the non-global zone as well.
phys-schost-1# mkdir /glohal/mnt3/postgres
phys-schost-1# chown -R postgres:postgres /glohal/mnt3/postgres
zone-1# su - postgres
zone-1$ mkdir /pgsql-linksource
zone-1$ gzcat /tmp/postgresql-8.1.0.tar.gz |tar xvf -
zone-1$ PATH=$PATH:/usr/local/bin:/usr/sfw/bin:/usr/ccs/bin zone-1$ export PATH
zone-1$ LD_LIBRARY_PATH=/usr/sfw/lib:/usr/local/lib:/usr/lib:/opt/csw/lib zone-1$ export LD_LIBRARY_PATH
zone-1$ gzcat /tmp/postgresql-8.1.0.tar.gz |tar xvf - zone-1$ cd /global/mnt3/postgres/build/postgresql-8.1.0 zone-1$ ./configure
zone-1$ gmake
If you use gcc to build the postgres binaries, build them in a failover file system.
zone-1$ gmake check
zone$ su
This example assumes the following:
The compiler is gcc, located in /usr/sfw/bin.
ar is located in /usr/ccs/bin.
zone-1# PATH=$PATH:/usr/local/bin:/usr/sfw/bin:/usr/ccs/bin zone-1# export PATH
zone-1# LD_LIBRARY_PATH=/usr/sfw/lib:/usr/local/lib:/usr/lib:/opt/csw/lib zone-1$# export LD_LIBRARY_PATH
zone-1# gmake install
zone-1# scp -rp /usr/local/pgsql phys-schost-2:/usr/local
zone-1# exit
zone-1$ gmake clean
Next Steps
Perform the steps in Example: Enabling the PostgreSQL Software to Run in the Cluster to complete installation and configuration of PostgreSQL.