Michael Banck is a senior consultant at credativ GmbH. He joined the company in 2009 and is a Debian Developer since 2001, besides being active in several other open source projects like PostgreSQL.
As a member of the Database Team in credativ's PostgreSQL Competence Center, he has supported various customers over the last years, both in the daily operations of PostreSQL and in the planning and implementation of high-availability and other solutions.
Nowadays, companies use more and more SaaS providers in the cloud for their operations. However, there can still be a lot value in operating your own infrastructure, be it for compliance reasons or in order to better control your costs. In particular, we think running highly integrated services on bare Debian systems makes it very easy to update and (in case of problems) debug those services.
Two examples will be discussed in this session: 1. Building a 3-node highly available PostgreSQL cluster using the Patroni Debian package and 2. Installing a stand-alone PostgreSQL installation fully featured with backups, monitoring and administration tools via the Elephant-Shed packages. Both can be deployed non-interactively via e.g. Ansible.
The first uses Debian-specific scripts which allow to configure a 3-way cluster identically on each node based off a template configuration. The second uses extensive integration of systemd services to configure and automate e.g. backups, as well as provisioning capabilities provided by Grafana.
Links: https://www.credativ.com/blog/integrating-patroni-debian https://www.credativ.com/blog/debian-integration-patroni-and-vip-manager https://github.com/credativ/ansible-playbook-patroni-debian https://elephant-shed.io