Quick Start Guide for PostgreSQL Backup &Recovery

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 specific tables or schemas. Backup data is securely stored with AES-256 encryption and optimized using compression. Centralized management offers detailed monitoring, reporting, and alerting for efficient PostgreSQL backup management, ensuring data integrity and streamlined recovery operations.

Getting Started

Step 1: Planning

Required Components:
1. BDRSuite Backup Server
2. PostgreSQL Database Server
System Requirements(Backup Server): Windows Server 2012 R2 Core (Standard or Datacenter) & above. To learn more, refer to the System Requirements.
Supported Platform(PostgreSQL Server(Windows & Linux)): 
Port Configuration:

Step 2: Deploying Backup Server

BDRSuite Backup Server is the central management component for configuring, scheduling, managing backups and recovery across virtual, physical, cloud, and SaaS environments. This server has to be installed and hosted on a dedicated machine.
  1. BDRSuite Backup Server Installation on Windows
  2. BDRSuite Backup Server Installation on Linux
  3. BDRSuite Backup Server Installation on Docker containers
After installation you can access the backup server by navigating to http://<IP Address>:6060 or http://localhost:6060 in your browser.
Watch BDRSuite Backup Server installation on Windows video.

Configuring PostgreSQL Backup & Recovery 

Step 1: Creating a Storage Repository to store the Backup data

  1. BDRSuite supports on-premise storage options and remote solutions, including DAS, NAS, SAN. You can navigate to the Infrastructure -> Backup Repository tab choose Block Storage. Refer to Block Storage Repository to learn more.
Watch creating Block Storage Repository video

  1. BDRSuite also supports public cloud services like Amazon S3, Azure Blob, Google Cloud, and S3-compatible platforms such as Wasabi, MinIO, and Backblaze. You can navigate to the Infrastructure -> Backup Repository tab choose Object Storage. Refer to Object Storage Repository to learn more.

Step 2: Adding PostgreSQL Backup Sources

To configure backups and restores, the PostgreSQL Server must be added to the BDRSuite Backup Server. Navigate to Data Source -> PostgreSQL Database Server -> Windows or Linux. Enter the required credentials to integrate the PostgreSQL source. To learn more, refer to the Adding PostgreSQL Backup Source.

Watch Adding PostgreSQL (Windows)Data Source Video.


Watch Adding PostgreSQL (Linux)Data Source Video.

Step 3: Configuring PostgreSQL Backups

To configure PostgreSQL backups within the BDRSuite Backup Server, follow the steps to set up backup jobs, schedule them, manage retention policies, and ensure effective data protection. Navigate to the Backup -> Configure Backup -> PostgreSQL Server Database.

Configure PostgreSQL Backup
  1. Specify a backup job name & select the backup repository
  2. Select PostgreSQL Server for backup
  3. Select the database
  4. Schedule when you want backups to run
  5. Configure settings
  6. Save the backup job. The backup will run as per schedule
  7. You can centrally manage and monitor backups
Refer PostgreSQL Configuration to learn more.

Step 4: Recovering PostgreSQL Backups

To perform recovery operations for PostgreSQL backup jobs, follow the steps outlined. Navigate to Recovery -> Restore Backup Data and click on the Restore button alongside the respective PostgreSQL backup job you wish to restore.

PostgreSQL Recovery
  1. Choose the PostgreSQL Server from which you want to restore.
  2. Select the Restore type.
  3. Select Restore Point or timestamp to restore
  4. Specify the restore details and initiate the restore
Refer to the PostgreSQL Recovery for more information.

Step 5: Managing PostgreSQL Backups

In BDRSuite Backup Server, managing PostgreSQL backup jobs involves navigating to Backup -> List Backup Jobs where you can perform various actions like searching, scheduling, and editing backup jobs. You can also suspend, resume, or abort jobs, adjust schedules, and even generate job reports. For more information, refer to managing backup jobs.

Step 6: Reporting & Notification

The Reports section provides information on automatically generated reports for PostgreSQL backups in BDRSuite Backup Server, including backup and recovery status, job summaries, and error logs. It also explains how notifications can be configured to keep users informed about the status of PostgreSQL backup operations and any issues that may arise. You can navigate to the Reports tab in the BDRSuite Backup Server console. To learn more, refer to Reporting & Notifications.

Watch PostgreSQL Backup & Recovery Demo Video.

Secondary Copy for PostgreSQL Backups

Secondary Copy - Offsite Copy

Offsite Copy page provides instructions on configuring Offsite Copy/DR in BDRSuite Backup Server, where backup data is replicated to a DR server in an offsite location for disaster recovery purposes. It explains how to set up offsite copy jobs for PostgreSQL backups, allowing backup data to be stored securely in a remote location, ensuring data availability and business continuity in the event of site failure. To learn more refer to the Secondary Copy - Offsite Copy.

Watch Secondary Copy - Offsite Copy Video.

Backup Settings

For detailed guidance on configuring and managing backup settings in BDRSuite Backup Server, including features like concurrent backups, bandwidth throttling, and more to optimize backup performance and resource management. You can navigate to Backup -> Configure Backup Settings. To learn more, refer to the Backup Settings.

Purchase & Manage Licenses

Licensing in BDRSuite enables seamless management of PostgreSQL Backup & Recovery, including activation, renewal, and allocation of licenses to ensure uninterrupted backup and recovery operations. For further details, refer to the Purchase & Manage License guide, which provides step-by-step instructions.

Watch Purchase & Manage License Video.

    • Related Articles

    • Quick Start Guide for KVM Backup & Recovery

      About KVM Backup & Replication BDRSuite provides a robust and reliable solution for protecting KVM-based virtual environments. It supports full and incremental backups, flexible scheduling, offsite replication, and centralized management. Whether ...

    • Quick Start Guide for oVirt Backup & Recovery

      About oVirt Backup & Recovery BDRSuite provides agentless, image-level backups for oVirt virtual machines, leveraging Changed Block Tracking (CBT) for efficient incremental backups and supporting automated scheduling. Backup data is secured with ...

    • Quick Start Guide for AWS Backup & Recovery

      About AWS Backup & Recovery BDRSuite offers backups for AWS EC2 instances, utilizing native snapshots for efficient backup and recovery. It supports incremental backups to optimize storage and bandwidth usage, with secure storage options across ...

    • Quick Start Guide for MySQL Backup & Recovery

      About MySQL Backup BDRSuite offers a robust solution for safeguarding MySQL databases with automated incremental backups, secure storage, and granular recovery capabilities. Backups can be stored locally, remotely, or in the cloud, all centrally ...

    • Quick Start Guide for Windows Disk Image Backup & Recovery

      About Windows Disk/Image Backup & Recovery BDRSuite offers comprehensive Windows disk image backup, with features like incremental backups with Changed Block Tracking (CBT), application-aware processing and various retention policies. Backup data is ...