Restore - PostgreSQL iDataAgent

Deployment Deployment - UNIX Configuration Backup Restore

Perform a 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.
  1. From the CommCell Browser, navigate to Client Computers | <Client> | PostgreSQL.

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

  1. Select the destination server from the Destination Server list.

    Click OK.

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

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

  1. Click OK.

  1. 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

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

Congratulations -  You have successfully completed your first backup and restore.

If you want to further explore this Agent's features read the Advanced sections of this documentation.