About PGHoard

Features

  • Automatic periodic basebackups

  • Automatic transaction log (WAL/xlog) backups (using either pg_receivewal (formerly pg_receivexlog), archive_command or experimental PG native replication protocol support with walreceiver)

  • Optional Standalone Hot Backup support

  • Cloud object storage support (AWS S3, Google Cloud, OpenStack Swift, Azure, Ceph)

  • Backup restoration directly from object storage, compressed and encrypted

  • Point-in-time-recovery (PITR)

  • Initialize a new standby from object storage backups, automatically configured as a replicating hot-standby

Fault-resilience and monitoring

  • Persists over temporary object storage connectivity issues by retrying transfers

  • Verifies WAL file headers before upload (backup) and after download (restore), so that e.g. files recycled by PostgreSQL are ignored

  • Automatic history cleanup (backups and related WAL files older than N days)

  • “Archive sync” tool for detecting holes in WAL backup streams and fixing them

  • “Archive cleanup” tool for deleting obsolete WAL files from the archive

  • Keeps statistics updated in a file on disk (for monitoring tools)

  • Creates alert files on disk on problems (for monitoring tools)

Performance

  • Parallel compression and encryption

  • WAL pre-fetching on restore