Dallas/Fort Worth Postgres is part of the PostgresWorld network of Postgres related meetups. We specialize in building our users of Postgres and related ecosystem technologies including but not limited to RDS Postgres, Aurora for Postgres, Google Postgres, PostgreSQL.Org Postgres, Greenplum, Timescale and ZomboDB. Please join us in learning and building People, Postgres, Data.
Presented by: Abbas Butt This presentation will provide step by step details on how to deploy a highly available PostgreSQL cluster using Patroni, etcd and HAProxy. Patroni is a python based solution to provide HA and automatic failover in a PostgreSQL cluster. Patroni depends on etcd and HAProxy to provide all the features. This presentation will provide steps to deploy and test etcd and HAProxy independently. Once all the dependent modules are deployed and tested to work, the presentation will then provide steps to do and test a manual failover. The presentation will use four CentOS 7 virtual machines. On each VM we will deploy PostgreSQL 12.6, etcd version[masked] and Patroni version 2.0.2. On one of the VMs we will have HAProxy version[masked]