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. 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:
  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 choose the folder you extracted the TAR file to:
  6. On the Data/Objects tab, make your options look like this and then click Restore:
  7. A message like this will appear.
  8. And then shortly after, a message like this will appear:
  9. 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: On the General tab, enter a filename and choose TAR as the format: On the Data/Objects tab, ...

    • Installing Postgres SQL

      The following instructions describe how to install PostgresSQL. You will need to complete the following two tasks Install PostgresSql Configure PgAdmin 4 Install PostgresSQL Go to this link and run the installer for Postgres Sql: Community DL Page ...

    • Restore a MSSQL BAK Backup

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

    • 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 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. 1. Open Management Studio and connect to the database server. 2. ...