Disaster recovery with pgbackrest
In Chapter 18, Logical Replication, we talked about disaster recovery and PITR, and we saw how to conduct them programmatically. In the real world, a DBA has to manage multiple PostgreSQL servers and it is useful to have some tools to make life easier. The open-source world offers us a lot of solutions to address disaster recovery in an easy way. Some of these tools are listed here:
- WAL-E
pgbarman- OmniPITR
There are many others, and at https://wiki.postgresql.org/wiki/Binary_Replication_Tools, you can find a good comparison of them all.
In this section, we will give a nod to pgbackrest; it is one of the most used tools for disaster recovery because it allows, in a very simple way, scalability on cores – and it allows the possibility of saving data on buckets in a compressed and encrypted way. The pgbackrest tool is a tool for PostgreSQL disaster recovery and PITR, and it has been designed for heavy load servers...
