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

Document Information

Preface

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

E.  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: Preparing the Cluster for PostgreSQL

  1. Install and configure cluster as instructed in Oracle Solaris Cluster Software Installation Guide.

    Install the following cluster software components on both nodes:

    • Oracle Solaris Cluster core software

    • Oracle Solaris Cluster data service for PostgreSQL

  2. Install the following utility software on both nodes:
    • readline utility

    • rsync utility

    • gmake utility

    • Your C compiler

  3. Beginning from the node that owns the file system, add the postgres users.
    phys-schost-1# groupadd -g 1000 postgres
    phys-schost-2# groupadd -g 1000 postgres
    phys-schost-1# useradd -g 1000 -d /global/mnt3/postgres -m -s /bin/ksh pgs
    phys-schost-2# useradd -g 1000 -d /global/mnt3/postgres -m -s /bin/ksh pgs

    Note - For a local zone, perform the steps in the local zones on each node.


  4. Ensure that the PostgreSQL users can login to each other's profile using ssh without a password prompt.