Oracle^® Solaris Cluster Data Service for PostgreSQL Guide

How to Verify the Oracle Solaris Cluster HA for PostgreSQL WAL File Shipping Installation and Configuration

1. Become the root role 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-prim-rs
      # clresource status postgres-sta-rs
      # clresource status rolechg-rs

   2. If the resource is not online, bring the resource online.

      # clresource enable postgres-sta-rs
      # clresource enable postgres-prim-rs
      # clresource enable rolechg-rs

3. Reboot the primary node where the primary database runs.

   # reboot

4. Confirm that the resource is now online on node 2.

   # clresource status rolechg-rs

5. For a failback, log in as the Postgres user on the standby node and resilver the primary node by executing scripts resilver-step1 and resilver-step2.

   ---

   Note -  Ensure that you follow the configuration steps for the scripts.

   ---