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.

    • Related Articles

    • Create a POSTGRES Backup

      This article assumes that you know your Postgres credentials and PgAdmin is Installed. Connect into PgAdmin. Right-Click on the database and click Backup Click on the folder icon to choose a location for your backup When you reach the location to ...

    • Recover a POSTGRES username and Password

      The following will help you recover your username/pw to a Postgres database so you can convert it to MSSQL format. Current Process: 1. Log into the server, open Services.msc, find Postgres service, and stop it: 2. Right-Click the service, select ...

    • Restore a MSSQL BAK Backup

      To restore a MSSQL BAK database backup, do the following steps: Open Management Studio and connect to the database server. 1. Right-Click on Databases 2. Select Restore Database... In the dialog that appears: 1. Select Device 2. Click the ... button: ...

    • Restore a MSSQL BACPAC Backup

      BACPAC files are a specialized set of SQL Scripts that can be restored into Microsoft SQL Server using Management Studio. To restore a BACPAC database, do the following steps. Open Management Studio and connect to the database server. Right-click on ...

    • Create a MSSQL BAK Backup

      To create a BAK backup, do the following steps: 1. Shrink the Database (Optional) Open Management Studio and connect to the database server. Change the Recovery Model to Simple: 1. Right click on the database you wish to backup and select Properties. ...