The PostgreSQL community version does not come with built-in high availability. So, what can we do? By combining PostgreSQL’s streaming replication feature with other open-source tools, we can build a highly available, reliable, and validated system. Let’s explore how to integrate PostgreSQL, Patroni, ETCD, HAProxy, and pgBouncer to create an earthquake-proof architecture (well, okay, only if you have a secondary site that’s not too close to the main one)...