Monday, February 22, 2016

How to recover from disasters with Barman

Disaster recovery for PostgreSQL databases.
  1. Knowledge
    1. Barman is a database recovery tool.
  2. Strategy
    1. Install Barman with yum on the backup server.
    2. Verify the barman user has ssh access to the postgres user on the main server.
    3. Verify the postgres user has ssh access to the barman user on the backup server.
    4. Verify the barman user can connect to the database on the main server.
    5. Configure Barman with default settings, noting the incoming_wals_directory.
    6. Configure Barman to enable continuous WAL archiving.
    7. Restart the server.
    8. Test new backup and restore functionality.
  3. Execution