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

From Thom Brown
Subject Re: how robust are custom dumps?
Date
Msg-id CAA-aLv5XNJOK-9mhnaBENWWZjOoPMYCpW66J2E3eF5JskZukWg@mail.gmail.com
Whole thread Raw
In response to how robust are custom dumps?  (Willy-Bas Loos <willybas@gmail.com>)
Responses Re: how robust are custom dumps?  (Willy-Bas Loos <willybas@gmail.com>)
List pgsql-general
On 24 April 2012 16:17, 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.

What was the experience?  Is it possible you had specified a
compression level without the format set to custom?  That would result
in a plain text output within a gzip file, which would then error out
if you tried to restore it with pg_restore, but would be perfectly
valid if you passed the uncompressed output directly into psql.

How many times had you experienced the problem at the time?  Was is
repeatedly or just the one time?

--
Thom

pgsql-general by date:

Previous
From: Vick Khera
Date:
Subject: Re: how robust are custom dumps?
Next
From: Yunong J Xiao
Date:
Subject: Backups using Solaris ZFS Snapshots