Perform Backup and Restore in a High-Availability Cluster

This topic describes the process of creating a backup of a database and restoring it on a server that is highly available.

About this task

The backup or restore process must be executed on the Active node, making sure to include all necessary data and configurations in the backup.

Procedure

Create a Backup:
  1. On the Node1 server, launch Windows Failover Cluster Manager.
    Ensure that:
    • Node1 is Active
    • Node2 is Paused
  2. Update the pg_ident.conf file in all three database folders.
    1. Access the shared drive in your clustered environment, where the database folders are located.
    2. Go to each folder and open pg_ident.conf in a text editor.
      Location path:
      • iqp > data-v13 > pg_ident.conf
      • uaa > data-v13 > pg_ident.conf
      • webhmi > data-v13 > pg_ident.conf
    3. Add both nodes as shown in the following screenshot. Save and close the file.

      The pg_ident.conf file initially contains only one entry for the node where the last installation was performed.

  3. In Windows Failover Cluster Manager, right-click on each service (listed below) and select Take Offline.
    • Operations Hub IQP Tomcat Web Server
    • Operations Hub WebHMI Tomcat Web Server
    • Operations Hub WebHMI Data Distributor
    • Operations Hub IQP EndApp
    • Operations Hub OPC UA Browse Service
  4. Run the backup script.
    See Back Up the Operations Hub Database.
  5. To bring the services online, right-click on each service (listed below) and select Bring Online.
    • Operations Hub IQP Tomcat Web Server
    • Operations Hub WebHMI Tomcat Web Server
    • Operations Hub WebHMI Data Distributor
    • Operations Hub IQP EndApp
    • Operations Hub OPC UA Browse Service
Restore a Database:
  1. On the server you want to restore the Operations Hub database, repeat steps 1-3.
  2. Run the restore script.
    See Restore the Operations Hub Database.
  3. Repeat step 5 to bring services online.