PostgreSQL HA by Patroni


You can have fully automated high availability PostgreSQL on your Kubernetes cluster ... today.  The Patroni system for automating PostgreSQL deployment, failover, and migration is ready to use and in production in several places.  In this live demo session, we will show you how you can make use of this technology.

We will run though setting up PostgreSQL clusters, both using basic Patroni and using a PostgreSQL Operator.  We will then demonstrate failover and disaster recovery, go over some basic configuration options, show how security & authentication works, and explore some plugins and options.  After that, you'll learn about the current state of the Patroni project as well as what the alternatives are.

If you need to administer more than one PostgreSQL replication cluster, you'll want to see how Patroni and Operators can make your daily DBA headaches and 2am wakeups go away.

Room 106
Thursday, March 7, 2019 - 11:00 to 12:00