Restore a POSTGRES Backup
Once someone sends you a backup created by following these instructions, you can restore it by following the steps below.
- Navigate to the location your TAR file is saved at.

- 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

- Next, open PGAdmin, right click on Databases and select Create > Database

- Now create an empty database that we will restore into:

- Now, right-click on your database and select Restore

- On the General Tab, select Directory and navigate to the folder you extracted the TAR file to

- Select the folder you extracted the TAR file to

- Your General tab should now look similar to this:
Do NOT click Restore yet

- On the Data Options tab, make your options look like this and then click Restore

- You will get a Process completed message

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