Ansible is an amazing product used by enterprises to automate their tasks. Pgbackrest allows simple and efficient backups of PostgreSQL. Combining the two tools it is possible to setup an environment where the backups are dynamically configured, performed and tested. The audience will learn how to configure two database servers in hot standby with a backup server and a fourth machine used for testing the backups.
Federico is a freelance devops & data engineer with long experience on PostgreSQL. He started his career as Oracle DBA in 2004 and fell in love with PostgreSQL in 2007. Previously he worked as data engineer for Transferwise. After several years spent in the UK he is now back in Italy. He’s an amateur analogue photographer and Python developer. In the free time he likes to cook traditional Neapolitan recipes.