1.2. New Features of pg_probackup3 #

As compared to pg_probackup, pg_probackup3 comprises the following new features and improvements:

  • Version independence: The same pg_probackup3 version can now be used with different versions of Postgres Pro or PostgreSQL, ensuring compatibility and flexibility.

  • API integration: pg_probackup3 provides programming interfaces for integration, which enables external backup management systems to utilize pg_probackup3 functionality for creating Postgres Pro backups and ensuring centralized backup management.

  • Work without SSH: pg_probackup3 can work without an SSH connection, simplifying data transfer.

  • FUSE: pg_probackup3 introduces the new fuse command, which enables running a database instance directly from a backup without requiring a full restore, using the FUSE (Filesystem in User Space) mechanism.

  • Operation by unprivileged users: pg_probackup3 can be started by users who do not have access rights to PGDATA. This helps to increase security and reduce the risk of potential errors.

  • A new backup format: Each backup is now stored as a single file, simplifying backup management and storage while providing additional usage capabilities.

  • pg_probackup3 supports various backup protocols via the following backup data source modes:

    • BASE: Leverages pg_basebackup replication protocol.

    • PRO: Uses the pg_probackup3's proprietary replication protocol, ensuring secure, high-speed data transfer from the Postgres Pro server.

    • DIRECT: Bypasses replication protocols entirely, accessing data files directly for backup operations.

    For details on backup data source modes, see the next section.

  • Merging incremental backup chains: It is now possible to merge chains of incremental backups, thus saving storage space and enabling more flexible backup policies.

  • Tape-ready: pg_probackup3's new backup format eliminates file fragmentation and allows size customization, thus providing optimal performance with tape backup systems.

  • Completely reengineered core

  • Redesigned architecture

  • Improved performance