Presented by:

A6f98bfb307b51393c9986e5bcdcf6c8

Andrew Dunstan

2ndQuadrant

Andrew has been contributing to PostgreSQL since 2002 and has been a committer since 2005. He has contributed in a many areas, including configuration and logging enhancements, dollar quoting, CSV import and export, improvements to plperl, the Windows port, rewriting the initdb and pg_ctl scripts in C, parallel pg_restore and more recently JSON features and fast column addition. He created and maintains the PostgreSQL Buildfarm.

No video of the event yet, sorry!

A backup solution is an essential part of almost any Disaster Recovery Plan. Barman is a mature, well maintained, open source, continuous backup solution for PostgreSQL. This talk will explain the various options for running Barman, and how using it you can have robust protection against data loss from system failure or corruption. Topics will include

  • prerequisites for running Barman
  • the different backup methods supported
  • the different WAL archiving methods supported
  • use of replication slots
  • geo-redundant backups for off-site protection
  • monitoring requirements
  • storage requirements
  • where you should run Barman
  • configuring PostgreSQL for use with Barman
  • configuring SSH for Barman

Date:
Duration:
50 min
Room:
Conference:
Postgres Conference 2020
Language:
Track:
Ops and Administration
Difficulty:
Easy