docs: warn about post-data-only schema dumps with parallel restore.

On 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 Professional
<https://postgrespro.com/list/id/3908.1717093769@sss.pgh.pa.us&gt;

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.