PostgreSQL Backup and Recovery

PostgreSQL Backup and Recovery

PostgreSQL Backup - Overview

BDRSuite provides comprehensive backups for PostgreSQL databases, offering granular-level recovery options. With flexible and instant recovery features, BDRSuite ensures seamless data restoration and business continuity

Watch the Demo Video

See BDRSuite's PostgresSQL database Backup in action by watching our demo video.


How to Get Started

Step 1: Download and install BDRSuite Backup Server

  1. Click to Download BDRSuite Backup Server here
  2. To Install BDRSuite Backup Server, watch the Backup Server Installation Video below.

Step 2: Create Backup Repository Configuration

Configure local or remote storage such as DAS, NAS, SAN or Use your own public cloud storage like S3, Azure, Google, S3 Compatible like Wasabi, MinIO, etc as a backup storage target to store backup data.

Step 3. Add PostgreSQL Database Server as Data Source

Navigate to ‘Data Sources - PostgresSQL Database Server' menu and click on 'Windows/Linux' as per your requirement. Make sure to install the BDRSuite Delegation Service on each database Server you plan to backup using Manual Agent Installation method. Watch the How-to Video below for detailed instructions.

Adding PostgreSQL Database Server - Windows



Adding PostgreSQL Database Server - Linux


Step 4: Configure PostgreSQL Database Backup

  1. Specify a backup job name & select the backup repository
  2. Select Database you want to backup
  3. Configure backup scheduling, retention and encryption policies
  4. Save the backup job
  5. You can monitor backup progress, edit job, view reports, check status and manage backup jobs centrally.

Step 5: PostgreSQL Database Recovery

  1. Navigate to the 'Recovery - Restore Backup Data' menu
  2. Choose the target Database Server you want to restore
  3. Select the Restore type
  4. Select Restore Point or timestamp to restore
  5. Specify the restore details and initiate the restore
Watch our demo video attached above for detailed PostgreSQL backup and recovery configuration.

Other Backup Solutions


    • Related Articles

    • Quick Start Guide for PostgreSQL Backup &Recovery

      About PostgreSQL Backup & Recovery BDRSuite provides comprehensive backup solutions for PostgreSQL databases. Automated backup scheduling ensures regular backups without disrupting database operations, while granular recovery allows for restoring ...

    • PostgreSQL Database Recovery

      Step 1: Choose the backup job data that you want to restore. Navigate to the Recovery tab. All the backed up applications & DBs will be listed. Click on the respective restore icon of the PostgreSQL backup job that you want to recover. Step 2: Choose ...

    • Does BDRSuite provide reports for PostgreSQL Server backup and recovery?

      Yes, BDRSuite offers comprehensive reporting for PostgreSQL Server backup and recovery. This includes a dashboard report for an overview of your backup operations, job-level reports for individual backup jobs, restore reports for tracking restoration ...

    • KVM Backup and Recovery

      KVM Backup - Overview BDRSuite offers comprehensive agentless backups for KVM. With multiple recovery options, from instant boot recovery to granular file & folder-level recovery, BDRSuite offers flexible and instant data recoveryensuringbusiness ...

    • VMware Backup and Recovery

      Overview BDRSuite offers agentless backup solutions for VMware ESXi & vCenter. This eliminates the need to install backup agents on each VM. It also provides flexible storage, instant & granular recovery, and centralized management for efficient VM ...