Stefan Fercot: pgBackRest and PostgreSQL failover: why archive_mode matters

Archived In the live feed 23 Sep 2026 – 30 Sep 2026. This page is permanent.

Database Vendors · Data Security & Resilience

From Planet PostgreSQL

A recent question on the community channels described a difficult situation: a standby had been promoted with archive_mode=off, and restarting the new primary was something the team wanted to avoid. Could they enable archiving on a downstream standby and take a pgBackRest backup from there instead? Their attempt failed with archive_mode must be enabled, even with archive-mode-check=n. Removing the checks…

— Planet PostgreSQL. Read the full story

Key words

Technologies
PostgreSQL · Progress

Sources

Primary sourceStefan Fercot: pgBackRest and PostgreSQL failover: why archive_mode mattersPlanet PostgreSQL · 23 Sep 2026Read original (opens in a new tab)

Privacy Preference Center