A utility for managing PostgreSQL database backups and recovery with incremental backup, parallel operations, and retention policies.
pg_probackup is a utility for managing backup and recovery of PostgreSQL database clusters. It enables periodic backups to restore servers after failures, supporting incremental backups, parallel operations, and retention policies. The tool is compatible with PostgreSQL versions 13 through 18 and handles large datasets efficiently.
Database administrators and DevOps engineers managing PostgreSQL instances who need reliable, efficient backup solutions with features like incremental backups and point-in-time recovery.
Developers choose pg_probackup for its page-level incremental backup and restore capabilities, which save disk space and speed up operations, along with support for remote operations, backup from standby servers, and flexible retention policies.
Backup and recovery manager for PostgreSQL
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Supports PAGE, DELTA, and PTRACK modes for page-level incremental backups, saving disk space and speeding up operations, as detailed in the README's feature list.
Runs backup, restore, merge, and other processes on multiple threads, improving speed for large datasets, which is explicitly mentioned in the key features.
Manages backups based on recovery time, count, or TTL, allowing automated cleanup and compliance with backup strategies, as highlighted in the retention section.
Enables backups from remote systems or standby servers to reduce master load, a feature noted in the remote operations and backup from standby descriptions.
Requires matching block_size, wal_block_size, and same major PostgreSQL version between backup and restore, limiting flexibility for heterogeneous environments, as stated in the limitations.
Building from source involves specific steps, like applying patches for PostgreSQL 18 or using MSVC 2013 on Windows, and some modes depend on WAL archiving or external extensions like ptrack.
Remote operations via SSH on Windows are not supported, and remote backups require identical pg_probackup versions, adding constraints for mixed environments, per the limitations.