disaster recovery Archives - 2ndQuadrant

Posts

Support for PostgreSQL’s System identifier in Barman

January 9, 2020/2 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 […]

Webinar: You forgot to put the WHERE in DELETE? [Follow Up]

December 12, 2019/0 Comments/in Nouman's PlanetPostgreSQL, Webinars /by Nouman

Human oversight is one of the many reasons for compromising a database. Disasters happen, but having a solid backup and disaster recovery plan in place can help your business mitigate such risks. Martín Marqués, Head of Support Operations at 2ndQuadrant, hosted a webinar on backup and disaster recovery options in PostgreSQL. The webinar: “You forgot […]

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.

The Barman is ready for PostgreSQL 10

September 6, 2017/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

Today our Devops team at 2ndQuadrant, led by my dear friend and trusted colleague Marco Nenciarini, released version 2.3 of Barman.

Barman 2.2 and the magic of parallel copy

July 18, 2017/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

Barman 2.2 introduces support for parallel copy, by improving performance of both backup and recovery operations in your PostgreSQL disaster recovery solution.

The Best Barman Ever

September 27, 2016/0 Comments/in 2ndQuadrant, Featured, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

This is my (very) biased opinion, but I am ready to bet that once you try Barman 2.0 you’ll agree with me.

Evolution of Fault Tolerance in PostgreSQL: Synchronous Commit

August 17, 2016/2 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

PostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with a series of blog posts. This is the fourth post of the series and we’ll talk about synchronous commit and its effects on fault tolerance and dependability of PostgreSQL. […]

Evolution of Fault Tolerance in PostgreSQL: Time Travel

July 21, 2016/0 Comments/in 2ndQuadrant, Featured, Gulcin's PlanetPostgreSQL, PostgreSQL /by Gulcin Yildirim

PostgreSQL is an awesome project and it evolves at an amazing rate. We’ll focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions with a series of blog posts. This is the third post of the series and we’ll talk about timeline issues and their effects on fault tolerance and dependability of PostgreSQL. […]

Speed up getting WAL files from Barman

July 19, 2016/0 Comments/in Featured, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

Starting from Barman 1.6.1, PostgreSQL standby servers can rely on an “infinite” basin of WAL files and finally pre-fetch batches of WAL files in parallel from Barman, speeding up the restoration process as well as making the disaster recovery solution more resilient as a whole. The master, the backup and the standby Before we start, […]