pg_restore: fails to restore post-data items due to circular FK deadlock - Mailing list pgsql-bugs

From vaibhave postgres
Subject pg_restore: fails to restore post-data items due to circular FK deadlock
Date
Msg-id CAM_eQjwLbRsdPF2=Yip05QNb-tyb2LXkAqfSkuVKpZRNhRmJmA@mail.gmail.com
Whole thread Raw
Responses Re: pg_restore: fails to restore post-data items due to circular FK deadlock
List pgsql-bugs
Repro steps

1. Create a database which has circular foreign key dependencies. (or use the sql script which I have shared), restore the pre-data section first.
2. pg_dump -Fc --section=post-data
3. pg_restore --jobs > 1

pg_restore fails to record the dependency between the foreign keys and tries to process them in parallel (see the attached log file for details)
Attachment

pgsql-bugs by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: BUG #18484: "Cannot enlarge string buffer" during parallel execution of prepared statement/partitioning
Next
From: Etsuro Fujita
Date:
Subject: Re: BUG #18467: postgres_fdw (deparser) ignores LimitOption