Re: how robust are custom dumps?

From: Thom Brown <thom(at)linux(dot)com>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how robust are custom dumps?
Date: 2012-04-24 20:04:07
Message-ID: CAA-aLv5XNJOK-9mhnaBENWWZjOoPMYCpW66J2E3eF5JskZukWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 24 April 2012 16:17, Willy-Bas Loos <willybas(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yunong J Xiao 2012-04-24 21:08:57 Backups using Solaris ZFS Snapshots
Previous Message Vick Khera 2012-04-24 19:39:24 Re: how robust are custom dumps?