On Thu, Mar 9, 2017 at 8:55 PM, mac pack <mac.apxz@gmail.com> wrote:
> pg_restore db.backup > out.sql
>
> pg_restore: [custom archiver] unrecognized data block type (0) while
> searching archive
>
> The follow commands works fine:
> pg_restore -s db.backup > out.sql
> pg_restore -l db.backup
If you are lucky and as -l is able to print out the complete list of
objects and is able to dump all the schema, perhaps not everything is
lost. You may want to restore a limited set of objects by using
--use-list first, and see what can be saved.
> Do you think it's possible to recover the dump file, is there any method or
> tool to recover dump files?
Lost data would be lost. Likely you can still recover portions of it,
perhaps most of it.
--
Michael