What we're about

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.

Upcoming events (1)

PostgreSQL HA with Patroni, etcd and HAProxy

Online event

PostgreSQL HA with Patroni, etcd and HAProxy

RSVP:

https://postgresconf.org/conferences/2021_Postgres_Conference_Webinars/tickets

Silicon Valley In-Person event CFP:

https://postgresconf.org/conferences/SV2022

Community Chat:

https://discord.gg/ghJ6vBKTrd

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]

Past events (103)

Photos (34)