postgres barman - ghdrako/doc_snipets GitHub Wiki

Barman (Backup and Recovery Manager) is a Postgres backup tool and an open-source project with contributors from around the globe. Barman provides robust backup and recovery solutions for Postgres. Key features of Barman include

  • support for multiple Postgres servers,
  • easy configuration of backup retention policies,
  • backup compression,
  • WAL archiving and WAL streaming (RPO=0), and
  • flexible restore options
  • remote command (backup zdalny i odtworzenie)

Barman was the first PostgreSQL backup tool to offer incremental backups, using innovative techniques like Linux file hard links and rsync for file-level incremental backups. This was a significant enhancement in PostgreSQL backup capabilities at the time. The new incremental backup feature in PostgreSQL 17 extends earlier innovations by providing block-level incremental backup directly within the PostgreSQL core codebase.

  • RPO=0 - oferuje zerowa utrate danych. pg_recval przy replikacji synchronicznej ale kosztem predkosci zapisu na serwerze
  • streaming Barman - Barman -w obie strony
  • uzywa pg_basebackup lub rsync