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:
- Perform an online PostgreSQL backup, as described in Perform an Online PostgreSQL Backup.
To restore an online PostgreSQL backup to a standalone LCE node:
Log in to LCE via the command line interface (CLI).
In the CLI in LCE, run the following command:
online-pg-backup --restore-from <full path of directory>
LCE restores the backup file.