Loading...

Restoring a PostgreSQL Server to a Disk (Application-Free Restore)

You can restore PostgreSQL data and transaction log files directly to a disk without the need for a PostgreSQL Agent on the destination computer.

Restoring to a disk is used in the following scenarios:

  • To restore the PostgreSQL server data for disaster recovery.
  • To restore the transaction logs that are missing on a PostgreSQL Standby replication setup.
  • To restore multiplexed data on the same media. The data from different backup jobs is passed to the client so that all of the interleaved backup jobs are restored in parallel.

Note: You cannot use a backup copy job for an application-free restore.

Procedure

  1. From the CommCell Browser, go to Client Computers > client > PostgreSQL > instance.
  2. Right-click FSBasedBackupSet, and then go to All Tasks > Restore to Disk.

    The Restore to Disk Filter dialog box appears.

  3. Select the filters to view the list of backup jobs, and then click OK.

    A list of backup jobs appears.

  4. Right-click the job that you want to restore, and then select Restore to Disk.

    Select multiple backup jobs at a time and restore them to disk.

    The Restore Options for All Selected Items dialog box appears.

  5. From the Destination Client list, select the client.
  6. In the Destination path box, specify where the backup pieces are restored to.
  7. To restore only the log files, select the Restore transaction logs only check box.
  8. To use a different account than the one that is configured for the PostgreSQL instance, select the Impersonate User check box, and then enter the credentials.

    The user must have the necessary privileges to restore the application data.

  9. Click OK.

What to Do Next

Recover the database.

Last modified: 10/4/2019 4:46:46 AM