pgsql-hackers
❮
docs: warn about post-data-only schema dumps with parallel restore.
- Jump to comment-1vaibhave postgres<postgresvaibhave@gmail.com>Jan 26, 2026, 5:23 AM UTCHi hackers,
Following up on the discussion in [1] about pg_restore failing to restore
post-data items due to circular foreign key deadlocks.
I’m attaching a doc patch that adds a warning about using post-data-only
schema dumps together with parallel restore.
Thanks.
[1] Re: pg_restore: fails to restore post-data items due to circular FK
deadlock - Mailing list pgsql-bugs : Postgres Professional
https://postgrespro.com/list/id/3908.1717093769@sss.pgh.pa.us- Jump to comment-1David G. Johnston<david.g.johnston@gmail.com>Jan 27, 2026, 4:52 PM UTCOn Sun, Jan 25, 2026 at 10:23 PM vaibhave postgres <
postgresvaibhave@gmail.com> wrote:Hi hackers,
Following up on the discussion in [1] about pg_restore failing to restore
post-data items due to circular foreign key deadlocks.
I’m attaching a doc patch that adds a warning about using post-data-only
schema dumps together with parallel restore.
Thanks.
[1] Re: pg_restore: fails to restore post-data items due to circular FK
deadlock - Mailing list pgsql-bugs : Postgres Professionalhttps://postgrespro.com/list/id/3908.1717093769@sss.pgh.pa.us
The note element would align with the sibling para element.
Not a fan of the patch overall though. I'd want to add something to
pg_restore noting that use of --jobs for constraint restoration needs
schema information to compute the restoration order.
There is also just a lot of detail here when something like:
<para>Consider always combining pre-data and post-data in the same command
so that parallel restores have the necessary dependency information to
create constraints in parallel.</para>
Any other content related to this probably belongs in the Notes section.
David J.