Lesson 0: PostgreSQL High Availability with Patroni & etcd
Complete course on deploying PostgreSQL High Availability clusters using Patroni and etcd with automated failover and monitoring.
#Database#PostgreSQL#High Availability
replication
Explore articles on replication
Lesson 1: Overview of PostgreSQL High Availability
Understanding the fundamentals of PostgreSQL High Availability, including why HA is critical, different HA methods, and comparing Patroni vs Repmgr vs Pacemaker solutions.
#Database#PostgreSQL#High Availability
Lesson 10: Replication Management
Learn how to manage PostgreSQL replication in a Patroni cluster including synchronous vs asynchronous replication, monitoring replication lag, configuring replication settings, and handling replication issues.
#PostgreSQL#replication#synchronous
Lesson 2: PostgreSQL Streaming Replication
Deep dive into PostgreSQL Streaming Replication, covering WAL mechanisms, synchronous vs asynchronous replication, replication slots, and hands-on lab setup.
#Database#PostgreSQL#Replication
Lesson 21: Multi-datacenter Setup
Designing and implementing cross-datacenter replication architectures for disaster recovery and geographic load balancing.
#PostgreSQL#Multi-DC#Replication
Lesson 8: Detailed Patroni Configuration
Learn detailed Patroni configuration including all sections of patroni.yml, bootstrap options, PostgreSQL parameters tuning, authentication setup, tags and constraints, and timing parameters optimization.
#Patroni#configuration#parameters
Lesson 9: Bootstrap PostgreSQL Cluster
Learn how to bootstrap a Patroni cluster including starting Patroni for the first time on 3 nodes, verifying cluster status with patronictl, checking replication, troubleshooting common issues, and testing basic failover.
#Patroni#bootstrap#cluster