public inbox for [email protected]  

help / color / mirror / Atom feed

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

On Sun, Mar 29, 2026 at 11:33 AM Tom Lane <[email protected]> wrote:

> "David G. Johnston" <[email protected]> writes:
> > On Sun, Jan 25, 2026 at 10:23 PM vaibhave postgres <
> > [email protected]> wrote:
> >> 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.
>
> > 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.
>
> Yeah, dropping this into the list of options is bad.  We put caveats
> like that into the Notes section usually.
>
> I also tend to think that it'd be better to document this under
> pg_restore: when people run into this type of failure, they are going
> to go to the pg_restore docs not the pg_dump docs to understand it.
> I guess there could be a case for repeating the info in both the
> pg_dump and pg_restore pages, but that feels a bit verbose.
>
> So maybe like the attached?
>
>
Works for me.

But how about adding something like the following to the pg_dump notes?  We
already have the corresponding link going to pg_dump in the pg_restore
notes.

"If producing a non-plaint-text format output see also the pg_restore
documentation for details on how the restore process uses the different
sections."

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], [email protected]
  Subject: Re: docs: warn about post-data-only schema dumps with parallel restore.
  In-Reply-To: <CAKFQuwYtdN4chM2HzcNsOJMvsVqE2LnKGTvndNeGW8s66g0Acg@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