public inbox for [email protected]  

help / color / mirror / Atom feed

From: David G. Johnston <[email protected]>
To: vaibhave postgres <[email protected]>
Cc: [email protected]
Subject: Re: docs: warn about post-data-only schema dumps with parallel restore.
Date: Tue, 27 Jan 2026 09:51:58 -0700
Message-ID: <CAKFQuwbHpDVQt0=nfC7To=AxAkDs6fmvv-40Qcw6z=VtW23GEQ@mail.gmail.com> (raw)
In-Reply-To: <CAM_eQjzTLtt1X9WKvMV6Rew0UvxT3mmhimZa9WT-vqaPjmXk-g@mail.gmail.com>
References: <CAM_eQjzTLtt1X9WKvMV6Rew0UvxT3mmhimZa9WT-vqaPjmXk-g@mail.gmail.com>

On Sun, Jan 25, 2026 at 10:23 PM vaibhave postgres <
[email protected]> 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/[email protected];
>

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.

view thread (4+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: docs: warn about post-data-only schema dumps with parallel restore.
  In-Reply-To: <CAKFQuwbHpDVQt0=nfC7To=AxAkDs6fmvv-40Qcw6z=VtW23GEQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox