Recovery of all databases
Some complexities are discussed here, though most are covered in later recipes.
Find a suitable server on which to perform the restore.
Before you recover onto a live server, always make another backup. Whatever problem you thought you had can get worse if you aren't prepared.
Physical backups (including Barman ones) are more efficient than logical ones, but they are subject to additional restrictions.
To be precise, a single instance of Barman can manage backups of several servers having different versions of PostgreSQL. However, when it comes to recovery, the same requirements for the PITR technology of PostgreSQL apply – in particular, the following:
- You must recover on a server with the same hardware architecture and...