Postgres logical replication during an office move
The client was relocating between two sites. Main database downtime over half an hour was unacceptable — three legal entities ran their 1C on it. The fix: stand up a replica at the new site in advance via pglogical, wait for the full sync, switch the connection string during the accounting team's lunch break. Actual downtime — 4 minutes 18 seconds, mostly DNS cache.