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.
Barman
Backup and Recovery Manager
- Is our primary choice to backup and restore PostgreSQL data in business-critical environments
- Relies on the robust and reliable Point-In-Time 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
- Is an open-source tool maintained by EDB and distributed under GNU GPL 3
pgBackRest
Postgres Backup and Restore
- pgBackRest is an easy-to-use backup and restore tool
- pgBackRest enables you to implement backup and recovery solutions for PostgreSQL data
- EDB collaborates with the pgBackRest community to release new stable versions with exciting enhancements and improved docs
BART
Backup and Recovery Tool
- BART facilitates and automates complete hot physical backups of your PostgreSQL and EDB Postgres Advanced databases
- Manage BART through PEM 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 | Q2 | |||
| 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 | GPL-3 | MIT | Proprietary |
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.