Re: Forensic recovery deleted pgdump custom format file

From: David Guimaraes <skysbsb(at)gmail(dot)com>
To: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
Cc: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Forensic recovery deleted pgdump custom format file
Date: 2015-07-14 01:58:52
Message-ID: CAJNfudLhjWw-6=D6U9b-zAqDOF6DmGYEnNiGWHHXihfTCLqhgw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The backups were deleted. I need them to use pg_restore.
Em 13/07/2015 21:18, "Michael Paquier" <michael(dot)paquier(at)gmail(dot)com> escreveu:

> On Tue, Jul 14, 2015 at 9:28 AM, David Guimaraes <skysbsb(at)gmail(dot)com>
> wrote:
> > So I decided to try to understand the file format generated by
> > pgdump. Analyzing the source code of pgdump/recovery, i concluded a few
> > things:
> >
> > The header of the file always starts with "PGDMP" followed by pgdump
> version
> > number used, followed by int size, offset, etc. followed by TOCs.
> >
> > My question is how to know the end of the file? Are there any signature
> that
> > I can use? Or would have to analyze the whole file?
>
> Why are you trying to reinvent the wheel? pg_restore is not available?
> --
> Michael
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2015-07-14 02:11:54 Re: Forensic recovery deleted pgdump custom format file
Previous Message Fujii Masao 2015-07-14 01:45:53 Re: Support for N synchronous standby servers - take 2