Quotidien Shaarli

Tous les liens d'un jour sur une page.

March 24, 2025

How does PostgreSQL master-replica failover work? | EDB
thumbnail

./pg_ctl promote -D /usr/edb/as12/data

Once the command is executed, it verifies any files available in the pg_wal folder, replays them, and then starts as a master node. It does not try to connect to the (old) master server, and hence the promotion is very fast.