JavaScript is required to for searching.
Skip Navigation Links
Exit Print View
Oracle Solaris Cluster Data Service for PostgreSQL Guide     Oracle Solaris Cluster 4.1
search filter icon
search icon

Document Information

Preface

1.  Installing and Configuring HA for PostgreSQL

A.  Files for Configuring Oracle Solaris Cluster HA for PostgreSQL Resources

B.  Deployment Example: Installing PostgreSQL in the Global Zone or a Zone Cluster

C.  Deployment Example: Installing PostgreSQL in a Non-Global Zone With HA for Solaris Zones

D.  Deployment Example: Installing PostgreSQL in the Global Zone Using WAL File Shipping

Target Cluster Configuration

Software Configuration

Assumptions

Installing and Configuring PostgreSQL on Shared Storage in the 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

Example: Enabling the PostgreSQL Software to Run in the Cluster

Index

Example: Building and Installing the PostgreSQL Software on Shared Storage

These steps illustrate how to install the PostgreSQL software. You can build and install the PostgreSQL binaries in the default directory /usr/local/pgsql. Perform the following steps on both hosts.

  1. Log in as the PostgreSQL user to the target environment.
    phys-schost-1# su - postgres
  2. Set up the build environment by performing the following steps.
    1. Create a build directory.
      phys-schost-1$ mkdir build
      phys-schost-1$ cd build
    2. Add the C compiler to your PATH and set the LD_LIBRARY_PATH.
      phys-schost-1$ PATH=$PATH:/usr/local/bin:/usr/sfw/bin:/usr/ccs/bin
      phys-schost-1$ LD_LIBRARY_PATH=/postgres/postgresql-8.3.1: \
      /usr/sfw/lib:/usr/local/lib:/usr/lib:/opt/csw/lib
      phys-schost-1$ export PATH LD_LIBRARY_PATH
  3. Install the source and configure the build.
    phys-schost-1$ gzcat /tmp/postgresql-8.3.1.tag.gz | tar xvf
    phys-schost-1$ cd /postgres/build/postgresql-8.3.1
    phys-schost-1$ ./configure --prefix=/postgres/postgresql-8.3.1
  4. Build the PostgreSQL binaries.
    phys-schost-1$ gmake
  5. Run the PostgreSQL regression tests.
    phys-schost-1$ gmake check
  6. Install the PostgreSQL binaries.
    phys-schost-1$ gmake install
  7. Install the utilities, including pg_standby.
    phys-schost-1$ cd contrib
    phys-schost-1$ gmake install
    phys-schost-1$ cd ..
  8. Clean the distribution.
    phys-schost-1$ gmake clean