backup Archives - Page 3 of 4 - 2ndQuadrant

Posts

Automating Barman with Puppet: it2ndq/barman (part three)

April 22, 2015/1 Comment/in Francesco's PlanetPostgreSQL /by Francesco Canovai

In the second part of the Automating Barman with Puppet series we configured, via Puppet, two virtual machines: a PostgreSQL server and a Barman server to back it up. However, human intervention was required to perform the SSH key exchange and most of the manifest was written to allow the servers to access each other. […]

Automating Barman with Puppet: it2ndq/barman (part two)

April 1, 2015/1 Comment/in Barman, Francesco's PlanetPostgreSQL, PostgreSQL /by Francesco Canovai

In the first part of this article we configured Vagrant to execute two Ubuntu 14.04 Trusty Tahr virtual machines, respectively called pg and backup. In this second part we will look at how to use Puppet to set up and configure a PostgreSQL server on pg and back it up via Barman from the backup […]

Automating Barman with Puppet: it2ndq/barman (part one)

March 17, 2015/1 Comment/in Barman, Francesco's PlanetPostgreSQL, PostgreSQL /by Francesco Canovai

This is not the first time that 2ndQuadrant has looked at Puppet. Gabriele Bartolini has already written an article in two parts on how to rapidly configure a PostgreSQL server through Puppet and Vagrant, accompanied by the release of the code used in the example on GitHub (http://github.com/2ndquadrant-it/vagrant-puppet-postgresql).

What’s new about Barman 1.4.0?

March 9, 2015/2 Comments/in Barman, Giulio's PlanetPostgreSQL /by Giulio Calacoci

The 1.4.0 version of Barman adds new features such as incremental backup and automatic integration with pg_stat_archiver which aim to simplify the life of DBAs and system administrators.

Incremental backup with Barman 1.4.0

January 26, 2015/0 Comments/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

Today version 1.4.0 of Barman has been officially released. The most important feature is incremental backup support, which relies on rsync and hard links and helps you reduce both backup time and disk space by 50-70%.

Detecting smelly backups with Barman

August 27, 2014/0 Comments/in Barman, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

“Ooooh that smell! Can’t you smell that smell?“. That’s a classic rock song by legends Lynyrd Skynyrd, I know. But also a warning that your new Barman 1.3.3 installation can now emit.

Announcing Barman 1.3.3

August 21, 2014/1 Comment/in Barman, International News /by Gabriele Bartolini

Version 1.3.3 of Barman, Backup and Recovery Manager for PostgreSQL, has been released.

Announcing Barman 1.3.1

April 14, 2014/0 Comments/in Barman, International News /by Gabriele Bartolini

Version 1.3.1 of Barman, Backup and Recovery Manager for PostgreSQL, has been released. Barman now supports concurrent backup from PostgreSQL 9.2 and 9.3 servers, using the pgespresso extension, allowing users to issue backups from a streaming replicated standby server. Read the full announcement at http://www.pgbarman.org/barman-1-3-1-released/. Many thanks for funding towards the development of this release […]

Configuring retention policies in Barman

May 19, 2013/6 Comments/in Barman, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

In our previous article we went through describing what retention policies are and how they can be enforced on your PostgreSQL server backups with Barman 1.2. In this post, we will go through the configuration aspects.

Retention of backups with Barman

April 15, 2013/0 Comments/in Barman, Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

Defining a disaster recovery plan involves defining backup policies. A key aspect of backup policies is to define how long backup data is retained for disaster recovery purposes. This applies to all digital content, including PostgreSQL databases. Barman 1.2.0 introduces automated management of backup retention policies of PostgreSQL servers.