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: Enabling the PostgreSQL Software to Run in the Cluster
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 example illustrates how to install the PostgreSQL software on shared storage. You can also build and install the PostgreSQL binaries in the default directory /usr/local/pgsql. See Installing the PostgreSQL Binaries in the Default Directory in a Zone (Alternative Installation). Perform this procedure on phys-host-1 and phys-host-2.
phys-schost-1# zlogin clu1
zone-1# groupadd -g 1000 postgres zone-1# useradd -g 1000 -u 1006 -d /postgres -s /bin/ksh postgres zone-2# groupadd -g 1000 postgres zone-2# useradd -g 1000 -u 1006 -d /postgres -s /bin/ksh postgres
phys-schost-1# mkdir /glohal/mnt3/postgres
phys-schost-1# chown -R postgres:postgres /glohal/mnt3/postgres
zone-1# su - postgres
zone-1$ mkdir build zone-1$ cd build
zone-1$ PATH=$PATH:/usr/local/bin:/usr/sfw/bin:/usr/ccs/bin zone-1$ export PATH
zone-1$ gzcat /tmp/postgresql-8.1.0.tag.gz | tar xvf - zone-1$ cd /global/mnt3/postgres/build/postgresql-8.1.0 zone-1$ ./configure --prefix=/global/mnt3/postgres/postgresql-8.1.0
zone-1$ gmake
If you use gcc to build the postgres binaries, build them in a failover file system.
zone-1$ gmake check
zone-1# gmake install
zone-1$ gmake clean