retention policy Archives - 2ndQuadrant

Posts

How monitoring of WAL archiving improves with PostgreSQL 9.4 and pg_stat_archiver

January 23, 2015/1 Comment/in Gabriele's PlanetPostgreSQL /by Gabriele Bartolini

PostgreSQL 9.4 introduces a new statistic in the catalogue, called pg_stat_archiver. Thanks to the SQL language it is now possible, in an instant, to check the state of the archiving process of transactional logs (WALs), crucial component of a PostgreSQL disaster recovery system.

Configuring retention policies in Barman

May 19, 2013/7 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.

Posts

Support & Services

Products

Postgres Learning Center

About Us