Restore a POSTGRES Backup

Restore a POSTGRES Backup

Once someone sends you a backup created by following these instructions, you can restore it by following the steps below.

  1. Navigate to the location your TAR file is saved at.

  1. Extract the TAR File
    A TAR file is similar to a ZIP file.  Using 7Zip, open the archive and extract it to your preferred location:
    1. Click Extract
    2. Choose a location to save extracted files to
    3. Click OK
  2. Next, open PGAdmin, right click on Databases and select Create > Database
  3. Now create an empty database that we will restore into:
  4. Now, right-click on your database and select Restore
  5. On the General Tab, select Directory and navigate to the folder you extracted the TAR file to
  6. Select the folder you extracted the TAR file to
  7. Your General tab should now look similar to this:
    Do NOT click Restore yet
  8. On the Data Options tab, make your options look like this and then click Restore
  9. You will get a Process completed message
  10. The restore is now complete.