How we discovered, and recovered from, Postgres corruption on the homeserver
PostgreSQL index corruption silently broke the matrix.org homeserver. State groups were corrupted, active data was deleted, and restoring consistency took a week of forensic debugging and reindexing. The root cause? Unclear. Hardware, maybe. But not Postgres or Synapse. The team’s fix involved disab..