Skip to content

Loading & saving dump file produced invalid dump file #6

@whtsky

Description

@whtsky

the dump is obtained using

pg_dump -Fc -d balisong -t django_migrations > out

out.zip

>>> pg_restore -d tmp --clean out
(works)

But pgdumplib will produce an invalid dump file:

import pgdumplib
pgdumplib.load('out').save('outd')
>>> pg_restore -d tmp --clean outd
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 317; 1259 7739671 SEQUENCE django_migrations_id_seq balisong
pg_restore: error: could not set default_table_access_method: ERROR:  zero-length delimited identifier at or near """"
LINE 1: SET default_table_access_method = "";

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions