I have worked with Databases for 25 years across Oracle, SQL Server, DB2, mysql, MongoDB and have over 4 year postgres experience at Rakuten and EnterpriseDB.
In this talk we start by describing a very simple and common scenario, where a PostgreSQL admin configures a postgres backup tool such as Barman to take regular backups, but then never tests the restore. This can happen if the user does not think “what problem we need to solve” before performing the deploy.
We will use this scenario as an ongoing example to illustrate the proper approach to a production implementation, based on:
- Documenting requirements
- Thinking how to cover open requirements
- Writing down appropriate Standard Operating Procedures
- Validate SOPs by running them
- Retest SOPs regularly