PostgreSQL Backup and Recovery with Barman

dbRecently a friend pointed me in the direction of a rather useful piece of software for doing quite funky things with backing up and restoring PostgreSQL databases.

Most organizations I have seen using PostgreSQL and MySQL have always chosen to perform database backups locally on each server. This is fine and it works, but you need to ensure you take a backup of those backup files. I’ve not come across any piece of software that will do complete database backups remotely… that is, until now. This is where “barman” fits in. You can check out what they are all about on the project’s website. http://www.pgbarman.org/

In this article I’ll be going through a really quick howto on getting up and running with Barman in order to perform remote backups of postgresql servers.

In this example I will be using the below details. Read more