public inbox for [email protected]
help / color / mirror / Atom feedFrom: David G. Johnston <[email protected]>
To: Tom Lane <[email protected]>
Cc: vaibhave postgres <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: docs: warn about post-data-only schema dumps with parallel restore.
Date: Tue, 31 Mar 2026 13:04:21 -0700
Message-ID: <CAKFQuwY_zOFGucP-x=hiPzG0KO0ngTN6aRGP9mp=LoYUw82iuQ@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]>
<CAKFQuwYtdN4chM2HzcNsOJMvsVqE2LnKGTvndNeGW8s66g0Acg@mail.gmail.com>
<[email protected]>
<CAKFQuwaL5_7wmJ5nwXDn-Vc=vivOP6AB9U2Qyg5TgnzJ1pKNFw@mail.gmail.com>
<[email protected]>
On Tuesday, March 31, 2026, Tom Lane <[email protected]> wrote:
> "David G. Johnston" <[email protected]> writes:
> > On Tuesday, March 31, 2026, Tom Lane <[email protected]> wrote:
> >> Hmm, I think we could be a bit more definite than that. What do you
> >> think of this advice:
> >>
> >> <para>
> >> When creating an archive (non-text) output file, it is advisable not to
> >> restrict the set of database objects dumped, but instead plan to apply
> >> any desired object filtering when reading the archive
> >> with <application>pg_restore</application>. This will preserve
> >> flexibility and possibly avoid problems at restore time; for details
> >> see the <xref linkend="app-pgrestore"/> documentation. However,
> >> omitting table data (<option>--no-data</option>) or large objects
> >> (<option>--no-large-objects</option>) does not have any surprising
> >> consequences.
> >> </para>
>
> > I’m against including that final sentence. The rest seems ok but I’
> > suggest going with an explicit mention that “—no-schema is risky” (or
> > otherwise omitting the entire section)
>
> How about replacing that sentence with "In particular, dumping table
> data without the corresponding table definition (via --no-schema and
> related options) is not recommended."
>
>
That should work.
David J.
view thread (4+ messages)
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: <CAKFQuwY_zOFGucP-x=hiPzG0KO0ngTN6aRGP9mp=LoYUw82iuQ@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