pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads. Instead of relying on traditional backup tools like tar and rsync, pgBackRest implements all backup features internally and uses a custom protocol for communicating with remote systems. Removing reliance on tar and rsync allows for better solutions to database-specific backup challenges. The custom remote protocol allows for more flexibility and limits the types of connections that are required to perform a backup which increases security. Rationale: The native PostgreSQL backup facility pg_dump provides adequate logical backup operations but does not provide for Point In Time Recovery (PITR). The PostgreSQL facility pg_basebackup performs physical backup of the database files and does provide for PITR, but it is constrained by single threading. Both of these methodologies are standard in the PostgreSQL ecosystem and appropriate for particular backup/recovery needs. pgBackRest offers another option with much more robust features and flexibility. pgBackRest is open source software developed to perform efficient backups on PostgreSQL databases that measure in tens of terabytes and greater. It supports per file checksums, compression, partial/failed backup resume, high-performance parallel transfer, asynchronous archiving, tablespaces, expiration, full/differential/incremental, local/remote operation via SSH, hard-linking, restore, backup encryption, and more. pgBackRest is written in C and Perl and does not depend on rsync or tar but instead performs its own deltas which gives it maximum flexibility. Finally, pgBackRest provides an easy to use internal repository listing backup details accessible via the pgbackrest info command, as illustrated below. $ pgbackrest info stanza: proddb01 status: ok db (current) wal archive min/max (12.0-1): 000000010000000000000012 / 000000010000000000000017 full backup: 20190603-153106F timestamp start/stop: 2019-06-03 15:31:06 / 2019-06-03 15:31:49 wal start/stop: 000000010000000000000012 / 000000010000000000000012 database size: 29.4MB, backup size: 29.4MB repository size: 3.4MB, repository backup size: 3.4MB diff backup: 20190603-153106F_20181002-173109D timestamp start/stop: 2019-06-03 17:31:09 / 2019-06-03 17:31:19 wal start/stop: 000000010000000000000015 / 000000010000000000000015 database size: 29.4MB, backup size: 2.6MB repository size: 3.4MB, repository backup size: 346.8KB backup reference list: 20190603-153106F incr backup: 20190603-153106F_20181002-183114I timestamp start/stop: 2019-06-03 18:31:14 / 2019-06-03 18:31:22 wal start/stop: 000000010000000000000017 / 000000010000000000000017 database size: 29.4MB, backup size: 8.2KB repository size: 3.4MB, repository backup size: 519B backup reference list: 20190603-153106F, 20190603-153106F_20190603-173109D NOTE: Nessus has provided the target output to assist in reviewing the benchmark to ensure target compliance.
pgBackRest is not installed nor configured for PostgreSQL by default, but instead is maintained as a GitHub project. Fortunately, it is a part of the PGDG repository and can be easily installed: $ whoami root $ dnf -y install pgbackrest Last metadata expiration check: 0:00:19 ago on Tue 29 Oct 2019 12:30:51 PM EDT. Dependencies resolved. [snip] Installed: pgbackrest-2.18-1.rhel8.x86_64 perl-DBD-Pg-3.7.4-2.module_el8.0.0+74+7e750437.x86_64 perl-DBI-1.641-2.module_el8.0.0+66+fe1eca09.x86_64 perl-Data-Dump-1.23-7.el8.noarch perl-Digest-HMAC-1.03-17.el8.noarch perl-File-Listing-6.04-17.el8.noarch perl-HTML-Parser-3.72-14.el8.x86_64 perl-HTML-Tagset-3.20-33.el8.noarch perl-HTTP-Cookies-6.04-2.el8.noarch perl-HTTP-Date-6.02-18.el8.noarch perl-HTTP-Message-6.18-1.el8.noarch perl-HTTP-Negotiate-6.01-19.el8.noarch perl-IO-HTML-1.001-10.el8.noarch perl-LWP-MediaTypes-6.02-14.el8.noarch perl-NTLM-1.09-17.el8.noarch perl-Net-HTTP-6.17-2.el8.noarch perl-TimeDate-1:2.30-13.el8.noarch perl-Try-Tiny-0.30-2.el8.noarch perl-WWW-RobotRules-6.02-18.el8.noarch perl-XML-LibXML-1:2.0132-2.el8.x86_64 perl-XML-NamespaceSupport-1.12-4.el8.noarch perl-XML-SAX-1.00-1.el8.noarch perl-XML-SAX-Base-1.09-4.el8.noarch perl-libwww-perl-6.34-1.el8.noarch Complete! Once installed, pgBackRest must be configured for things like stanza name, backup location, retention policy, logging, etc. Please consult the configuration guide. If employing pgBackRest for your backup/recovery solution, ensure the repository, base backups, and WAL archives are stored on a reliable file system separate from the database server. Further, the external storage system where backups resided should have limited access to only those system administrators as necessary. Finally, as with any backup/recovery solution, stringent testing must be conducted. A backup is only good if it can be restored successfully. References: https://pgbackrest.org/ https://github.com/pgbackrest/pgbackrest https://www.postgresql.org/docs/12/static/app-pgdump.html https://www.postgresql.org/docs/12/static/app-pgbasebackup.html