Create a POSTGRES Backup

Create a POSTGRES Backup

This article assumes that you know your Postgres credentials and PgAdmin is Installed.

  1. Connect into PgAdmin.  Right-Click on the database and click Backup
  2. Click on the folder icon to choose a location for your backup
  3. When you reach the location to save your backup, give your backup a name in the File name field.
    Click Save

  4. On the General tab, enter a filename and choose TAR as the format
    Do NOT click next yet.
  5. On the Data Options tab, make your options look like the following:
  6. Next, click Backup
  7. You will get a Process completed message

  8. After the backup is complete, navigate to it's location and rename the file to have a .TAR file extension.

    • Related Articles

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

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

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

    • Create a MSSQL BACPAC Backup

      To create a BACPAC backup, do the following steps: Open Management Studio and connect to the database server. Right click on the database you wish to backup and select Tasks > Export Data-tier Application... In the dialog that appears click "Next >" ...

    • Convert a Postgres database to MSSQL

      Full Convert by Spectral Core is a robust tool for converting databases from one format to another. The following instructions will walk you through using Full Convert to convert a Postgres database to MSSQL. Launch Full Convert Click New database ...