Radim Marek: Getting rid of a 4 TB table in PostgreSQL
GitLab has a public story about deleting the wrong thing. In January 2017 an engineer who was trying to restore replication wiped a data directory they believed was on the secondary. It was on the primary. The postmortem they published afterwards is still one of the better things written about a…
Sources
- T2Radim Marek: Getting rid of a 4 TB table in PostgreSQLPlanet PostgreSQL