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.