Postgres Professional has released version 3.5.0 of its ProBackup Enterprise software, designed to streamline database backup and recovery. The update integrates remote recovery directly into the pg_probackup3 utility, enabling multi-threaded data transfer and restoration across networks without requiring third-party tools.
The new release introduces the sync-replica parameter for the catchup command, which allows administrators to verify and synchronize PostgreSQL replicas with a primary server. This feature includes diagnostic checks and automated rollback capabilities using pg_rewind to resolve timeline discrepancies.
Management of backup retention policies is now multi-threaded, utilizing new parameters to accelerate the merging of old backups and archive cleanup. Additionally, the wal-depth setting ensures the preservation of transaction logs required for point-in-time recovery, while keepalive messages improve connection stability.
Performance enhancements extend to SFTP and S3-compatible storage, where asynchronous data transfer and increased buffer sizes reduce network load. The update also addresses security vulnerabilities related to FUSE mounting and buffer overflows, while fixing bugs affecting TDE encryption and compressed file system support.
