On Thu, Mar 9, 2017 at 8:55 PM, mac pack <mac.a...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
