PgBackRest aims to be a reliable, easy-to-use backup and restore solution that can seamlessly scale up to the largest databases and workloads by utilizing algorithms that are optimized for database-specific requirements.
- Parallel Backup & Restore
- Local or Remote Operation
- Full, Incremental, & Differential Backups
- Backup Rotation & Archive Expiration
- Backup Integrity
- Page Checksums
- Backup Resume
- Streaming Compression & Checksums
- Delta Restore
- Parallel, Asynchronous WAL Push & Get
- Tablespace & Link Support
- S3 and Azure Compatible Object Store Support
- Encryption
- Build
- Installation
- PostgreSQL Configuration
- PgBackRest Configuration & Create Stanza & Test
- Manual & Automate Backup
- Remote Backup and restore
| Purpose | Command |
|---|---|
| Get backup info | sudo -u postgres pgbackrest info |
| Create Stanza | sudo -u pgbackrest pgbackrest --stanza=main stanza-create |
| Check whether configuration are properly set | sudo -u pgbackrest pgbackrest --stanza=main check |
| Perform Backup | sudo -u pgbackrest pgbackrest --stanza=main backup |
| Perform Restore | sudo -u postgres pgbackrest --stanza=main --delta restore |
To specify type of backup - full or diff |
sudo -u postgres pgbackrest --stanza=main --type=diff --log-level-console=info backup |