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.

    instance_restore01

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

    restore_basic2 - restoreklzzwxh:0023ostgresqlklzzwxh:0024estore_basic2.png

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

    restore_basic3 - restoreklzzwxh:0019ostgresqlklzzwxh:0020estore_basic3.png

  • Click OK.

    restore_basic4 - restoreklzzwxh:0010ostgresqlklzzwxh:0011estore_basic4.png

  • 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

    restore_basic5 - restoreklzzwxh:0002ostgresqlklzzwxh:0003estore_basic5.png

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

    restore_verify

Loading...