Building Enterprise-Grade Postgres Services via Debian Packages and systemd-Integration

Speaker: Michael Banck

Track: Systems administration, automation and orchestration

Type: Long talk (45 minutes)

Room: Talks

Time: Aug 27 (Thu): 11:00

Duration: 0:45

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