Re: how robust are custom dumps? - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: how robust are custom dumps?
Date
Msg-id 20120424152853.GA11265@tux
Whole thread Raw
In response to how robust are custom dumps?  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-general
Willy-Bas Loos <willybas@gmail.com> wrote:

> Hi,
>
> Some 6 years ago, i had a bad experience with a custom dump. It wouldn't
> restore and my data was lost.
> I was a beginner then, and working under windows, and i wasn't on the mailing
> list yet.
> It was no critical data, we could build the database again, which was then
> easier than figuring out what exactly went wrong with the backup.
>
> Since then i have refused to trust custom dumps.
> But they do provide some very nice functionality, like restoring a single
> table.
>
> So my question is: what is your advice on custom dumps? Can i bet my life on
> them?

I think so, yes.

Early versions contains some errors with the correct order of objects
(dumping a view before the table -> error whilst restore ...)


Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: Re: Simple way to get missing number
Next
From: Steve Crawford
Date:
Subject: Re: [SQL] Simple way to get missing number