LinuxFest Northwest 2019: PostgreSQL: An Introduction to BARMAN

Описание

Presented by Robert

I've uploaded the scripts and slides on gitlab

https://gitlab.com/rbernier/linuxfest-2019-all-about-barman

**

The PostgreSQL ecosystem is incredibly sophisticated. At one time the only thing a PostgreSQL DBA had to worry about was to master this opensource database engine and leverage his knowledge of the operating system. Well, times have changed. The world for the DBA has expanded such that now he has to think in terms of whole clusters of database farms with all the requisite minutia of tasks including backups and disaster recovery on an ever increasing scale and that's not even talking about the cloud.

This talk focuses on what is becoming a very important requisite piece of technology called Barman.

Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python. It allows your organisation to perform remote backups of multiple servers in business critical environments to reduce risk and help DBAs during the recovery phase.

I will cover the installation of Barman and how it can be used in conjunction with PostgreSQL. Such tasks as backups, restoration, replication, disaster recovery will be covered. Frankly, it's a very impressive piece of software because it simplifies a lot of tasks that were at one time manually managed by the DBA.