Fencing a Postgres primary that might still be alive
Promoting a standby doesn't stop the old Postgres primary from taking writes. Here's how the control plane behind ClickHouse Managed Postgres fences it on bare metal, AWS and GCP, and why the design is fail-open.
Sources
- T1Fencing a Postgres primary that might still be aliveDatabricks / ClickHouse / DuckDB / Supabase / Neon / PlanetScale