Re: docs: warn about post-data-only schema dumps with parallel restore. - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: docs: warn about post-data-only schema dumps with parallel restore.
Date
Msg-id CAKFQuwbHpDVQt0=nfC7To=AxAkDs6fmvv-40Qcw6z=VtW23GEQ@mail.gmail.com
Whole thread Raw
In response to docs: warn about post-data-only schema dumps with parallel restore.  (vaibhave postgres <postgresvaibhave@gmail.com>)
List pgsql-hackers
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.


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.

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: pgsql: Prevent invalidation of newly synced replication slots.
Next
From: Greg Burd
Date:
Subject: Re: pgsql: Prevent invalidation of newly synced replication slots.