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

Target Cluster Configuration

Software Configuration

Assumptions

Installing and Configuring PostgreSQL on Shared Storage in a Non-Global HA Container

Example: Preparing the Cluster for PostgreSQL

Example: Configuring Cluster Resources for PostgreSQL

Example: Configuring the HA Container

Example: Modifying the PostgreSQL Configuration File

Example: Building and Installing the PostgreSQL Software on Shared Storage in an HA Container

Example: Enabling the PostgreSQL Software to Run in the Cluster

Installing the PostgreSQL Binaries in the Default Directory in an HA Container (Alternative Installation)

Example: Building and Installing the PostgreSQL Software in the Default Directory in an 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

Index

Example: Configuring the HA Container

  1. On shared cluster storage, create a directory for the HA container root path.

    This example presents a sparse root zone. You can use a whole root zone if that type better suits your configuration.

    phys-schost-1# mkdir /global/mnt3/zones
  2. Create a temporary file, for example /tmp/x, and include the following entries:
    create -b
    set zonepath=/global/mnt3/zones/clu1
    set autoboot=false
    set pool=pool_default
    add inherit-pkg-dir
    set dir=/lib
    end
    add inherit-pkg-dir
    set dir=/platform
    end
    add inherit-pkg-dir
    set dir=/sbin
    end
    add inherit-pkg-dir
    set dir=/usr
    end
    add net
    set address=hahostix1
    set physical=bge0
    end
    add attr
    set name=comment
    set type=string
    set value="PostgreSQL cluster zone" Put your desired zone name between the quotes here.
    end
  3. Configure the HA container, using the file you created.
    phys-schost-1# zonecfg -z clu1 -f /tmp/x
  4. Install the zone.
    phys-schost-1# zoneadm -z clu1 install
  5. Log in to the zone.
    phys-schost-1# zlogin -C clu1
  6. Open a new window to the same node and boot the zone?
    phys-schost-1a# zoneadm -z clu1 boot
  7. Close this terminal window and disconnect from the zone console.
    phys-schost-1# ~~.
  8. Copy the containers configuration file to a temporary location.
    phys-schost-1# cp /opt/SUNWsczone/sczbt/util/sczbt_config /tmp/sczbt_config
  9. Edit the /tmp/sczbt_config file and set variable values as shown:
    RS=RS-PGS-ZONE
    RG=RG-PGS
    PARAMETERDIR=/global/mnt3/zonepar
    SC_NETWORK=false
    SC_LH=
    FAILOVER=true
    HAS_RS=RS-PGS-HAS
    
    
    Zonename=clu1
    Zonebootopt=
    Milestone=multi-user-server
    Mounts=
  10. Create the zone according to the instructions in the Oracle Solaris Cluster Data Service for Solaris Containers Guide.
  11. Register the zone resource.
    phys-schost-1# ksh /opt/SUNWsczone/sczbt/util/sczbt_register -f /tmp/sczbt_config
  12. Enable the zone resource.
    phys-schost-1# clresource enable RS-PGS-ZONE