Loading...

Performing Entire Server Restore

You can restore the entire PostgreSQL server by using the data and log backups that you previously performed on the default subclient of the FSBasedBackupSet.

Before You Begin

  1. Perform a backup.
  2. Stop the PostgreSQL server.
  3. Delete or rename the wal and data directories.
  4. Verify that the PostgreSQL software version on the destination is the same version or higher than the software version.

Procedure

  1. You can perform a restore on the instances page, instance details page, or job details page.
    • Instances: From the navigation pane, click Solutions > DB Instances, in the Restore column, click Restore.
    • Instance details: From the navigation pane, click Servers > server > PostgreSQL > instance > FSBasedBackupSet > default, in the Restore column, click Restore.
    • Job details: From the navigation pane, click Jobs > job ID, in the Job summary area, click Restore.

      The Backup Content page appears.

  2. Click Restore.

    The Restore Options dialog box appears.

  3. From the Destination Client list, select the destination host for the restore.
  4. From the Destination instance list, select the destination instance for the restore.
  5. Select the database recover option.
    • To start the PostgreSQL server automatically after the restore operation, select the Recover Database Server check box.
    • To recover to a point-in-time, select Point-in-Time and enter the date and time.
  6. Click Submit.

What to Do Next

You can control or view the job. For more information, see Jobs.

Last modified: 10/3/2018 9:27:12 AM