Why PostgreSQL Kept Saying “No space left on device” with 20TB Still Free
A little while ago, we ran into a customer issue that turned out to be way more interesting than it looked at first glance. The customer was trying to generate a backup using pg_dump, and the job kept failing halfway through with this error: pg_dump: error: could not write to output file: No space left on device When I first saw it, I honestly felt pretty relaxed. This kind of error looks like a standard problem. If the disk is full, you make the disk bigger and move on. ...