Project

General

Profile

Actions

Task #3244

open

Implement PostgreSQL PITR streaming backups with Barman

Added by Brett Cornwall over 4 years ago. Updated over 3 years ago.

Status:
In Progress
Priority:
Normal
Category:
-
Target version:
Team - Q2/2021
Start date:
Due date:
% Done:

0%

Tags:
Salt

Description

PostgreSQL maintains a Write-ahead log (WAL), which is a record of transactions that can be "replayed" on top of an older backup to recover data.

Barman is an application for physical backups of PostgreSQL servers that manages base backups and WAL archiving.

Features include:

  • Retention policies (e.g. `recovery window of 30 days` or `redundancy 3`:
  • GPL3
  • Debian inclusion
  • Backed by a company affiliated with core PostgreSQL development
  • Focuses on backup/recovery procedures
  • Promotes testing backups
  • Geographical redundancy reduces single points of failure (e.g. backup/prod being in the same datacenter).

A reasonable way to start modelling disaster recovery architecture is to design
a couple of possible architectures in respect to PostgreSQL and Barman, such as
evaluating the pros and cons of:

  • Same-data-center backups
  • Different data center backups in the same metropolitan area
  • Different data center backups

Evaluate the single points of failure (SPOF) of the system, with a cost-benefit analysis.

Having said this, a very common setup for Barman is to be installed in the same data center where the PostgreSQL servers are. In this case, the single point of failure is the data center. Fortunately, the impact of such a SPOF can be alleviated thanks to two features that Barman provides to increase the number of backup tiers.

Planning for disk space is important: Plan the required disk space based on the size of the cluster, number of WAL files generated per day, frequency of backups, and retention policies.

Plan for having an identical recovery environment that are as similar as possible, if not identical, to the original server. Doing so eases burdens of maintenance.

Streaming backup is recommended from PostgreSQL 9.4 or higher and is easier to set up.

Actions #1

Updated by Guilhem Moulin over 4 years ago

  • Status changed from New to In Progress
  • Assignee set to Guilhem Moulin
Actions #2

Updated by Florian Effenberger about 4 years ago

  • Target version set to Q4/2020
Actions #3

Updated by Guilhem Moulin over 3 years ago

  • Target version changed from Q4/2020 to Q2/2021

We'll reuse the old Pootle box (upgraded to XXL) for that, Brett is taking care of the initial deployment and will hook a RDBMS or two.

Actions

Also available in: Atom PDF