Backup and Recovery
Automate backup and recovery for PostgreSQL
Database backup and recovery is an essential component of any PostgreSQL deployment. EDB provides multiple solutions to fit your disaster recovery plan.
Simplify PostgreSQL data recovery
Recover data any time with two simple commands
Always get your data back
Guaranteed physical backups with no corruption
Use the same solution everywhere
Integrate with any PostgreSQL architecture at scale
Find the right fit for your backup and data recovery needs
The following tools are all fully supported by EDB in addition to being tested and released as part of the EDB portfolio.
Backup and Recovery Manager
Barman
- Our primary choice to back up and restore PostgreSQL data in business-critical environments
- Relies on the robust and reliable backup and recovery technology found in PostgreSQL
- Enables DBAs to manage a complete catalog of backups from—and recover to—multiple remote servers, all from a single location
Postgres Backup and Restore
pgBackRest
- An easy-to-use backup and recovery tool
- Requires minimal configuration to back up, restore, and archive locally or remotely via SSH
- Solves common bottleneck problems with parallel processing for backup, compression, restoring and archiving
Backup and
Recovery Tool
BART
- Facilitates and automates complete hot physical backups of PostgreSQL and EDB Postgres Advanced databases
- Can be managed via the Postgres Enterprise Manager console
- Creates, manages, and restores backups for multiple local or remote Postgres databases
Feature Comparison
| Feature | pg_basebackup | Barman | pgBackRest | BART |
|---|---|---|---|---|
| SSH protocol support | ||||
| PostgreSQL protocol | ||||
| Incremental backups | ||||
| RPO=0 | ||||
| Rate limiting | ||||
| Custom WAL sizes | ( v11+) | |||
| WAL archive compression | ||||
| Backup compression | Q4 | |||
| Symmetric encryption | ||||
| Parallel backup and restore | ||||
| Partial restore (only selected databases) | ||||
| Centralized repository management | ||||
| Retention policy | ||||
| List backup | ||||
| S3 support | ||||
| Nagios integration | ||||
| PEM integration | Q4 | |||
| No custom scripts required | ||||
| License | PostgreSQL | GPLv3 | MIT | EDB |
Get Started with Backup and Recovery
Need help with building PostgreSQL into your disaster recovery plan? Our experts can help you with a single solution for configuring and scheduling backups, applying data retention policies, managing backups in a central catalog, and restoring a database to a point in time. Contact us now to learn more.