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 LCE 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 LCE node: 

  1. Run the following command:

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

    LCE restores the backup file.

    PostgreSQL restarts.