Re: [BUGS] pg_dump's results have quite different size - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: [BUGS] pg_dump's results have quite different size
Date
Msg-id CAKFQuwa7ZVH1wje55m7H6okvtKMceuE=OiAfg1-gugxSEEFT2g@mail.gmail.com
Whole thread Raw
In response to Re: [BUGS] pg_dump's results have quite different size  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-bugs
On Fri, Dec 16, 2016 at 1:47 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
The only thing we actually know with reasonable certainty is that his backup script is broken, and that this is bad. Randomly changing settings so that the brokenness is still there but just less obvious is more dangerous than helpful.


​Its been suggested before but pg_dump could be a bit more helpful if it dumped contents to a temporary location first and then, if the dump completes successfully, moves it to the user-specified location.  It would be a bit of a subtle error if the dump fails silently and the user doesn't notice that the timestamp of an already existing dump at the named location didn't change - but if the target location is already unoccupied then the absence of a file would be very obvious.

David J.

pgsql-bugs by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [BUGS] pg_dump's results have quite different size
Next
From: Mark Kirkwood
Date:
Subject: Re: [BUGS] pg_dump's results have quite different size