Re: Suggestion: pg_dump self-cleanup if out-of-disk

On Sun, Nov 17, 2013 at 11:12 PM, David Johnston <polobo(at)yahoo(dot)com> wrote:

> Having recently had a pg_dump error out due to not having enough disk it
> occurs to me that it would be nice for pg_dump to remove the partial dump
> file it was creating (if possible/known) instead of having it sit around
> taking up that last bit of available space and itself being unusable for
> restore purposes anyway. Given these tend to be large the benefit to
> cleanup seems quite strong and fairly direct to accomplish since we just
> created the file only a short while previous. Call it a beginner or
> part-time-dba usability feature.
>

I don't think I like this. If I unexpectedly filled up a partition with a
dump file, I think the first thing I would want to do is 'head' or 'more'
the partial dump to see what is making it so big--e.g. that I am dumping
the wrong cluster/database/schema. I wouldn't want the software to hide
the evidence.

Cheers,

Jeff