backup Archives - 2ndQuadrant

Posts

Support for PostgreSQL’s System identifier in Barman

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

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 […]

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.

Barman 2.1 and the new –archive option

January 9, 2017/0 Comments/in Giulio's PlanetPostgreSQL /by Giulio Calacoci

Barman 2.1 Version 2.1 of Barman, backup and recovery manager for PostgreSQL, was released Thursday, Jan. 5. The new release, along with several bugfixes, introduces preliminary support for the upcoming PostgreSQL 10, and adds the –archive option to the switch-xlog command. switch-xlog –archive The new –archive option is especially useful when setting up a new […]

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. […]