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.