Oracle^® Solaris Cluster Data Service for PostgreSQL Guide

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