Skip to content

Multi-page Postgres dump fails to restore #297

@dshunfen

Description

@dshunfen

Description

My team is seeing that when a Postgres dump exceeds the 100MB file size for a single page, and gets separated into two pages, the restore fails. I've confirmed by removing some of the extra data on the database and doing a dump (which brings the file size down to just under 100MB, and a single page), I'm able to restore.

The restore fails with messages like:

ERROR:  relation "public.data_historical" does not exist
LINE 1: INSERT INTO public.data_historical (data_ptr_id,...)

What other information can I provide to help to debug this? I'd look into this myself and push a fix, but I don't really know where to start.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions