Restore

Restoring your backup data is crucial, therefore you should perform a restore operation immediately after your first full backup so that you understand the process.

Ensure that the following guidelines are met before you start the restore:

• You need to stop the PostgreSQL server before performing the File System restore to recover the entire PostgreSQL server.

• Make sure to delete or rename the wal and data directories.

• Restore the File System backups of same version of PostgreSQL and not from higher to lower or lower to higher.

• From the CommCell Browser, navigate to Client Computers| <Client> | PostgreSQL.

  Right-click the <Instance>, and then click All Tasks | Restore PostgreSQL Server.

• Select the destination server from the Destination Server list.

  Click OK.

  Note: If you do not want the PostgreSQL Server to start automatically after the restore operation is complete, clear the Recover Database Server check box.

  

• You can monitor the progress of the restore job in the Job Controller.

  

• Once the restore job has completed, right-click the agent or <Instance>, point to View and click Restore History.

  

• Click OK.

  

• You can view the following details about the job by right-clicking the job:

  • View Restore Items

    You can view them as Successful, Failed, Skipped or All.

  • View Job Details

  • View Events of the restore job.

  • View and send Log files of the restore job

  • Resubmit the restore job

  

• Once the database is restored, verify that the restored database and log files are available in the original location.