• Photos
  • Schedule
  • Talks
  • Speakers
  • Contacts
  • F.A.Q.
  • Profile
  • En Ru

    David Steele

    David Steele Crunchy Data

    6 July

    Talk

    Efficiently backing up terabytes of data with pgBackRest

    pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads. It supports per file checksums, page checksums, compression, parallel backup/restore, delta restore, parallel asynchronous archiving, partial/failed backup resume, backup from standby, tablespaces and links, expiration, full/differential/incremental, local/remote operation via SSH, and more. This talk will introduce the features, give sample configurations, and talk about design philosophy.

    pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads. It supports per file checksums, page checksums, compression, parallel backup/restore, delta restore, parallel asynchronous archiving, partial/failed backup resume, backup from standby, tablespaces and links, expiration, full/differential/incremental, local/remote operation via SSH, and more. This talk will introduce the features, give sample configurations, and talk about design philosophy.

    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.

    Primary PgBackRest Features:
    Parallel Backup/Restore with Compression
    Per File Checksums for Backup Integrity
    Page Checksums (when enabled) Verified During Backup
    Full, Differential, and Incremental Backups
    Backup from Standby
    Delta Restore for Fast Recovery
    Restore Single Database from a Cluster
    Backup and Archive Expiration
    Parallel Archive Command with Compression
    Full Support for Tablespaces and Links with Remapping

    Back to the list of talks

    Buy tutorial:

    Price:
    Enter your e-mail and we will send you payment details soon.