Verifying the HA for PostgreSQL Installation and Configuration

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

How to Verify the 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

How to Verify the Oracle Solaris 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.

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

   ---