Shrinking a 130 GB Postgres to a Native Copy with Greenmask: What Labored and What Broke
rubyinsights.weblog
Staging hit 130 GB and was stuffed with PII, so I [built a small, FK-consistent, masked subset of a Rails app’s Postgres with Greenmask](https://rubyinsights.weblog/en/weblog/shrinking-a-130-gb-postgres-to-a-local-copy-with-greenmask-what-worked-and-what-broke). Covers digital references for associations with out FKs, PII masking, and fixes for what broke, together with planner panics, orphan rows, temp-space exhaustion and a PostGIS NOTICE that aborts the restore.
