Barman Archives - 2ndQuadrant

Posts

Barman 2.11: barman-cloud-restore and barman-cloud-wal-restore

July 21, 2020/2 Comments/in 2ndQuadrant, Anna's PlanetPostgreSQL, Barman, DevOps, PostgreSQL /by Anna Bellandi

Thanks to the new utilities barman-cloud-restore and barman-cloud-wal-restore introduced in Barman 2.11, it is now possible to execute the recovery of a PostgreSQL instance using a full backup previously executed using barman-cloud-wal-archive and barman-cloud-backup commands. Let’s discover together how to implement this in the following article.

Barman Cloud – Part 2: Cloud Backup

July 16, 2020/0 Comments/in 2ndQuadrant, Anna's PlanetPostgreSQL, Barman, DevOps, PostgreSQL /by Anna Bellandi

In the first part of this blog, Jonathan explained how the barman-wal-archive command works. Now, assuming you followed those instructions, you have a properly configured PostgreSQL instance up and running. In this second part, I will show you how the barman-cloud-backup command works.

PG Phriday: 10 Things Postgres Could Improve – Part 2

June 19, 2020/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

Last week, we examined Postgres XID wraparound complications in greater depth to see exactly how easily they can surprise even prepared enterprises. But we also found the real problem areas and how to mitigate them specifically. In this continuing series to plumb the depths of Postgres constructively, we’re going to focus on some of the […]

Webinar: PostgreSQL continuous backup and PITR with Barman [Follow Up]

June 15, 2020/0 Comments/in Webinars /by Bilal Ibrar

How can you achieve an RTO of 5 minutes for the backups of your PostgreSQL databases? And what about RPO=0 for zero data loss backups? To tackle such questions and more, 2ndQuadrant arranged a live webinar “PostgreSQL continuous backup and PITR with Barman”. The session was hosted by Gabriele Bartolini, Head of Support at 2ndQuadrant. […]

Backup manifests and pg_verifybackup in PostgreSQL 13

May 4, 2020/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

PostgreSQL 13 introduces two useful features to enhance automated validation of physical backups: backup manifests and a new tool called pg_verifybackup. In this short article I attempt to provide an overview of them.

Barman Cloud – Part 1: WAL Archive

January 27, 2020/0 Comments/in 2ndQuadrant, Barman, DevOps, Featured, Jonathan's PlanetPostgreSQL, PostgreSQL /by Jonathan Battiato

Preamble How many current Barman users have thought about saving backups in a remote destination in the cloud? How many have thought about taking that backup directly from the PostgreSQL server itself? Well, since Barman 2.10 this is now possible! How? Let’s discover that together in the following articles.

Support for PostgreSQL’s System identifier in Barman

January 9, 2020/3 Comments/in Florins PlanetPostgreSQL /by Florin Irion

The latest Barman 2.10 release introduces support for the system identifier of a PostgreSQL instance. In this article, I will answer a few questions explaining what a system identifier is and why it is a good thing that Barman uses it. What is the PostgreSQL system identifier? PostgreSQL gives a unique system identifier to every […]

Barman 2.10 – Recovery of partial WAL files

December 11, 2019/0 Comments/in Anna's PlanetPostgreSQL /by Anna Bellandi

Being a PostgreSQL database administrator and managing backups on a daily basis, one of the new features of Barman 2.10 that I liked the most is the transparent management of .partial WAL files during recovery. And, most likely, you feel the same if you have been using Barman with WAL streaming and have been asked […]

Geo-redundancy of PostgreSQL database backups with Barman

February 19, 2019/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

Barman 2.6 introduces support for geo-redundancy, meaning that Barman can now copy from another Barman instance, not just a PostgreSQL database.

PG Phriday: Adventures in BAR Management

January 19, 2018/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

Backups are a critical component to a fully covered Postgres database infrastructure. In some ways, it’s fair to say a database without a backup is no database at all—sometimes literally. 2ndQuadrant’s Barman tool is aptly named as a Backup And Recovery Manager for Postgres, and it exists primarily for encouraging a stable and robust backup […]

Posts

PG Phriday: 10 Things Postgres Could Improve – Part 2

Webinar: PostgreSQL continuous backup and PITR with Barman [Follow Up]

Backup manifests and pg_verifybackup in PostgreSQL 13

Support for PostgreSQL’s System identifier in Barman

Barman 2.10 – Recovery of partial WAL files

Geo-redundancy of PostgreSQL database backups with Barman

PG Phriday: Adventures in BAR Management

Support & Services

Products

Postgres Learning Center

About Us