Over the last few years, Patroni has established itself as the main reference for PostgreSQL High Availability and we are witnessing its adoption increase among our customers following this trend in popularity. It has not been, however, a straightforward journey for many of them: the robustness of the Patroni project was built on top of solid layers provided by different components and it is necessary to understand how they connect with each other and what happens when one of them “breaks”.
In this talk, we are going to review the most common failure scenarios and how Patroni recovers the PostgreSQL cluster in each of these cases. We’ll also discuss the most common mistakes we have observed and how you can avoid these.
Speakers: Fernando Laudares Camargos and Jobin Augustine – Percona