Sun Cluster Data Service for PostgreSQL Guide for Solaris OS

Verifying the Sun Cluster HA for PostgreSQL Installation and Configuration

After you install, register, and configure Sun Cluster HA for PostgreSQL, verify this installation and configuration to determine whether the Sun Cluster HA for PostgreSQL data service makes your PostgreSQL database highly available.

ProcedureHow to Verify the Sun Cluster HA for PostgreSQL Installation and Configuration

  1. Become superuser on a cluster node that is to host the PostgreSQL component.

  2. Ensure that all the PostgreSQL resources are online.

    For each resource, perform the following steps:

    1. Determine whether the resource is online.


      # clresource status postgres-rs
      
    2. If the resource is not online, bring the resource online.


      # clresource enable postgres-rs
      
  3. Switch the resource group to another cluster node, such as node2.


    # clresourcegroup switch-h node2 postgres-rg
    
  4. Confirm that the resource is now online on node2.


    # clresource status  postgres-rs