failover

Failover testing of a Postgres cluster

30/08/201920/07/2017 by Philip

Testing failover to one of 2 slaves and reattaching to the new master.

Starting config

   master
  |      |
slave1 slave2

Post failover config

   slave1
  |      |
slave2 master

pg_cron Guide: Scheduled Jobs, Monitoring & Gotchas
Aurora PostgreSQL Storage Architecture Explained
Postgres Time-Series Partition Maintenance, Done Right
pgvector Index Tuning: HNSW vs IVFFlat, Explained
Postgres Is Down: A 5-Minute Triage Tree
pg_cancel_backend vs pg_terminate_backend: Full Runbook
Postgres TOAST: A Practical Storage Checklist
Postgres Row-Level Security: A Multi-Tenant Playbook
Postgres Full-Text Search vs Elasticsearch: A Real Comparison
Fix “No pg_hba.conf Entry for Host” in Postgres
Postgres Wait Events: A Practical Triage Guide
Postgres Replication Lag Is Four Numbers, Not One
UUID vs BigInt Primary Keys in Postgres: Index Bloat Explained
How to Increase max_connections in Postgres Safely
PostgreSQL Transaction ID Wraparound: Cause and Fix
Postgres Free Space Map: Why Deletes Don’t Shrink Tables
Partition Pruning Isn’t Magic — Here’s When It Actually Works
Auto_explain PostgreSQL: Capture Slow Query Plans in Production
Postgres jsonb_array_elements: Turn JSON arrays into queryable rows inside SQL
Physical and logical replication solve different problems at different layers of