Patroni: what the blog posts don't tell you...
October 21–24
Level: Intermediate
Patroni has become the Gold Standard for managing High Availability Postgres clusters. It has great documentation and there are hundreds of blog posts detailing how to set up your first cluster.
However, there is a large gap between the blog posts and having a production ready system that you actually trust.
This talk will briefly describe a typical Patroni setup before discussing/demonstrating the following topics that the blog posts never have enough space for!
- Security hardening for Patroni, HAProxy, etcd and Postgres
- Proxy layer considerations
- Configuration best practice: what goes in the DCS?
- Tips and tricks for managing several Patroni clusters
- Backups
- Upgrades
- Failover testing
Whether you are looking to build your first Patroni cluster or you already run several, there should be something in this talk for you!