# Postgres Thursday s01e04: Dimitri Fontaine. The Art of PostgreSQL; pg\_auto\_failover

DevFeed: [Postgres Thursday s01e04: Dimitri Fontaine. The Art of PostgreSQL; pg\_auto\_failover](<https://devfeed.tech/articles/postgres-thursday-s01e04-dimitri-fontaine-the-art-of-postgresql-pg-auto-failover-34648.md>)

Original publisher: [Read original article](<https://tapoueh.org/conf/postgres-thursday-s01e04-dimitri-fontaine.-the-art-of-postgresql-pg_auto_failover/>)

Published: 2020-11-01T22:00:00Z

Content type: article

Language: en

Sources: [Dimitri Fontaine](<https://devfeed.tech/sources/dimitri-fontaine.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Availability](<https://devfeed.tech/topics/availability.md>), [Extension](<https://devfeed.tech/topics/extension.md>), [Processes](<https://devfeed.tech/topics/processes.md>)

Tags: [failover](<https://devfeed.tech/tags/failover.md>), [high-availability](<https://devfeed.tech/tags/high-availability.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [window-functions](<https://devfeed.tech/tags/window-functions.md>)

## AI overview

An interview with Dimitri Fontaine discusses The Art of PostgreSQL, including the practical use of window functions for ranking, running totals, and lead/lag comparisons. It also covers pg_auto_failover, a PostgreSQL high-availability extension that automates failover using a monitor process and a state machine for node roles.

## Source excerpt

In this interview we dive in my book The Art of PostgreSQL and then in the High Availability and automated failover solution that I work on, pg_auto_failover.