Evolution of Fault Tolerance in PostgreSQL
PostgreSQL is an awesome project and it evolves at an amazing rate. The talk will focus on evolution of fault tolerance capabilities in PostgreSQL throughout its versions.
The talk will cover the topics listed below:
- Robustness of PostgreSQL
- PostgreSQL Fault Tolerance: WAL
- Transaction? Commit? Checkpoint?
- Replication Methods for PostgreSQL
- Physical Replication
- Standby Modes
- Streaming Replication and WAL
- Failover and Switchover
- Synchronous Commit
- Managing Timeline Issues: pg_rewind
- Trigger-based Replication
- Logical Decoding : BDR and pglogical
There are several ways of how to look at fault tolerance. In this sense PostgreSQL provides different means of achieving fault tolerance and dependability either out of the box solutions or using extensions depending on what are the user’s priorities about their system. General fault tolerance in PostgreSQL is improving over time and I expect this trend to continue.