‘pgBackRest’

pgBackRest is an easy-to-use backup and restore tool that aims to enable your organization to implement disaster recovery solutions for PostgreSQL databases.

Note

Looking for pgBackRest documentation? Head over to http://www.pgbackrest.org

pgBackRest v2.40 is the current stable release. Release notes are on the Releases page.

EDB collaborates with the community on this open-source software. The packages are provided by the PostgreSQL community. All of the use cases shown in this document are fully tested and supported by EDBPostgresAdvancedServer .

• ‘Installation’
  • Available platforms
  • Debian/Ubuntu
  • RHEL/CentOS
  • EDB Postgres Advanced Server
• Quick Start
  • Configuration
  • Backups
  • Backup Information
  • Restore
  • Recovery target
  • Glossary
  • pgBackRest
    • restore command
  • PostgreSQL
• ‘Recommended Settings’
  • Encryption
  • Maximum Number of Processes
  • Backup Fast Start
  • Delta
  • Log Levels
  • Glossary
  • pgBackRest
• Retention Policy
  • Full backup retention
  • Differential backup retention
  • Archive retention
  • repo1-retention-archive-type
  • repo1-retention-archive
  • Glossary
  • pgBackRest
• Running pgBackRest Locally on the Database Host’
  • Description
  • Configuration
  • Global Section
    • Mount Points
    • S3-compatible Object Stores
    • Azure-compatible Object Stores
    • GCS-compatible Object Stores
    • Recommended Settings
    • Retention Policy
  • Stanza Section
  • Setup Archiving
  • Backup and Restore
  • Glossary
  • pgBackRest
  • PostgreSQL
• Running pgBackRest from a Dedicated Repository Host’
  • Description
  • Create a Dedicated User on the Repository Host
  • Setup Passwordless SSH Connection
  • Configuration
  • Backup Server
  • Database server(s)
  • Setup Archiving
  • Backup and Restore
  • Glossary
  • pgBackRest
  • PostgreSQL
• ‘Multiple Repositories’
  • Configuration
  • Initialization
  • Stanza Create Command
  • Check Command
  • Archive Push Command
  • Backups
  • Backup Command
  • Info Command
  • Restore
  • Restore Command
  • Archive Get Command
• ‘TLS connections’
  • Description
  • Create a Dedicated User on the Repository Host
  • Certificates generation
  • Configuration
  • Perform a backup
  • Prepare the servers for Streaming Replication
  • Setup the standby servers
  • Take backups from the standby servers
  • Conclusion
• ‘Appendix’
  • Concepts
  • Backup
  • Restore
  • Write Ahead Log (WAL)
  • Encryption
  • Configuration Reference
  • Global
  • Stanza
  • Command Line Arguments and Environment Variables
  • Options Precedence
  • Configuring Multiple Database Hosts in a Stanza
• ‘Frequently Asked Questions’