Overview

Backup Procedure.

Here is the backup procedure to backup the database on PostgreSQL.

Using PgAdmin.

  • Launch PgAdmin UI.
  • Enter the Credential.
  • Select the Veeam Database.
  • Right click, and choose Backup.
  • Enter the FileName, browse the path where you want to save the backup.
  • Format keep default Custom. By default postgreSQL backups the DB as .SQL format.
  • Click Backup, and see the progress.

Using Powershell

  • Open Powershell
  • Go to Postgres bin folder. For example:
cd '.\Program Files\PostgreSQL\15\bin\'
  • Enter the command to dump your database. For example:
./pg_dump.exe -U postgres -d VeeamBackup -f D:\BackupDB\filename.sql
  • Type password for your postgres user

Restore Procedure.

Here is the backup procedure to restore the database on PostgreSQL.

Using PgAdmin

  • Launch PgAdmin UI.
  • Enter the Credential.
  • Create a new database.
  • Right click on the database, and choose Restore.
  • Browse the backed up file. Click Restore, and see the progress.

Using Powershell

  • Open Powershell
  • Go to Postgres bin folder. For example:
cd '.\Program Files\PostgreSQL\15\bin\'
  • Type this command to restore your database.
./psql.exe -U postgres -d VeeamRestoredDB -f D:\BackupDB\filename.sql
  • Type password for your postgres user