How to Verify the Sun Cluster HA for PostgreSQL WAL File Shipping 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-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.

   # cleresource 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.

   ---