Restore an Online PostgreSQL Backup

Caution: If you have configured high availability, do not restore an online backup to the master node or the standby node. For more information about high availability configurations, see High Availability.

You can use the online-pg-backup utility to restore an online PostgreSQL backup to a standalone Log Correlation Engine server node.

Note: Restoring an online backup completely replaces the PostgreSQL database. This may result in 10-45 minutes of downtime, depending on the size of the backup files.

Before you begin:

To restore an online PostgreSQL backup to a standalone Log Correlation Engine node: 

  1. Log in to Log Correlation Engine via the command line interface (CLI).

  2. In the CLI in Log Correlation Engine, run the following command:

    online-pg-backup --restore-from <full path of directory>

    Log Correlation Engine restores the backup file.

    PostgreSQL restarts.