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: Configuring Cluster Resources for PostgreSQL

  1. Register the necessary data types on both nodes.
    phys-schost-1# clresourcetype register SUNW.gds
  2. Create the PostgreSQL resource group.
    phys-schost-1# clresourcegroup create -n phys-schost-1 POSTGRES-PRIM-RG
    phys-schost-1# clresourcegroup create -n phys-schost-2 POSTGRES-STA-RG
    phys-schost-1# clresourcegroup create - ROLECHG-RG
    phys-schost-1# clresourcegroup create set -p \
    Auto_start_on_new_cluster=false ROLECHG-RG
  3. Create the logical host.
    phys-schost-1# clreslogicalhostname create -g ROLECHG-RG ha-host-1
  4. Enable the resource groups.
    phys-schost-1# clresourcegroup online -eM ROLECHG-RG
    phys-schost-1# clresourcegroup online -M POSTGRES-PRIM-RG
    phys-schost-1# clresourcegroup online -M POSTGRES-STA-RG