Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7fK7-005Zgd-1J for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Mar 2026 20:04:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w7fK5-00D73s-2s for pgsql-hackers@arkaria.postgresql.org; Tue, 31 Mar 2026 20:04:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w7fK5-00D73j-1s for pgsql-hackers@lists.postgresql.org; Tue, 31 Mar 2026 20:04:26 +0000 Received: from mail-oa1-x31.google.com ([2001:4860:4864:20::31]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w7fK3-00000002ELB-24Jk for pgsql-hackers@postgresql.org; Tue, 31 Mar 2026 20:04:25 +0000 Received: by mail-oa1-x31.google.com with SMTP id 586e51a60fabf-41c4d660b19so1940245fac.1 for ; Tue, 31 Mar 2026 13:04:23 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1774987462; cv=none; d=google.com; s=arc-20240605; b=iK1Fs/07N3AuGW2pnsLcQS9HbYWn3kIFjqI79kt1/mt4Z/SjU5V6D8sS5ss/PF+aQc 3sMlcAhNi27aw/jZfr3PcC+9mJm70BkDmtEQUYQXlp0YQBTIymxwK1Lk4qr+vT+qpD3X nh+eApILtLXC3fwqXpQP2KUVwn8WA5LIz3knbX+5ASo3biASl4ZGo2OQlMMjS2KmxU94 9FCoqq3CqIMZB2Ec0JYdmaDGtfywLKR//iwoz+Mwybek8hksPPVPspcfB1PqEYANJbTb chcogqMFNOpnQODlg8txL0j7BrPfI8/hkGPoOoiHulR4gIAz+GO49OBc2dEjtH+Elapa wK7w== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:dkim-signature; bh=DRJooYigOTqm/LTvf3VxI8jGwOJtI4T0ZJ8Z6HJisPQ=; fh=xhnwQ6Dwm9f+HpkdFcPNwDeptiI09eiNto5YTXzVkv4=; b=Hpk8laASClm7wQxH/oCYY41NfDDMEmM7M9/HNOkxnfegKc7Nnk3PWgkfXmqCMlDpph 6Nr/DrmHbxV355e1Edrt5cz607BEXT1G16mrqQmopxwh95foYyr88fDj+rlS4C+ZL4Vr S3qcrn9984Zx0dNqaI/AvkWJjTWvhg8amb5ZTSssrE9326e+WninXDV0RYtR3Yo004tf N+Aid8yAc/s9BZlb4MSaTmljc7NW5tBFYsU0ZEZvPRXrXwHleSA6wK7aOGayvasNiUOi kv9Gg+TgObRlUb+itRAPn+TIuhzheCCVQLVdqTBp+tg/lLzX6qho0ht6FPLYWv9L93Sc DJPw==; darn=postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20251104; t=1774987462; x=1775592262; darn=postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=DRJooYigOTqm/LTvf3VxI8jGwOJtI4T0ZJ8Z6HJisPQ=; b=P3YSReEgSF9DroV5poshLi52g8jUqkZ3dkoD6EyT/sU6XPIfaWdJ9bFyMj+gS4rtoP JjfG2ZJIaoFatQOQfYt17Fh6PuTohVk3lpL+0oQxiv8rRxzqZvNX85i1zG2EUqTbM+DJ F9MQKcG6GOzHnnFQEsHvQwd6C6hiS1GXe8+gD5GgY3i9G2UMz4Du3jNiDMNfPy/amjI3 9GkgA1yBtPT5I8j/dGGIxZ0BGVxsbjy2ioenNAw4Llex7HgE6gX0bXUcwEDhb4TJt246 rzFiVLRk42/NOKmPpriyEIbQEEKMSsLu5rtSdQuzB41UqC0iqvPZwqXTUBeJCsjA+uFk 0xkA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1774987462; x=1775592262; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=DRJooYigOTqm/LTvf3VxI8jGwOJtI4T0ZJ8Z6HJisPQ=; b=NECICcLN4CnK1UVELyrZih675ns4ErrqCk8/yk6o9eaUhUoXqT8gEXtkaZJDfTzxFJ l2KfLirJdxhubeQIY25b1/BgnaFdRKscCLhWK02Fl7LIp4mfkz6B3oGHVMOMNmjTui8Z AT5ScYhAXB/sPpl0iPcCrj63/WW+AEd72l5Tm9lYoP//V+o0jAnL8yP15jA/iWSh6Obq hSMVhKS7D243AVBfZic4jCtlF1gRIqRjpH0Pd66Nf3fkcFBbbnipmP2NJvSNPJbP6Mpl I2VfF11DCM4gLuxTGzZR5Xf9F+q7DyDHHa16QiLxyPxgloC4MHc7v9c+xYdaLeapqheD JIbw== X-Forwarded-Encrypted: i=1; AJvYcCVLf/bH6/NuUFdymJ5K8frBHcDiYYUuxCn9puR9Sv+OGDLnpycDbkbLy6VQ4CxHG/Arw8bCDqlujPjqUb7T@postgresql.org X-Gm-Message-State: AOJu0YwVQeALKGF1KtTo9a4uOgzWUwDl5geNcSiPIUC5CmQT9IcOxvl7 GdDecG4frA7ONSVKiOyeZK/tzed4qH6groFcwnEaE6AW41+MhisZSQhHcLDLdZEnrpFSFwBQXmh 0VFb3hg8Pm9hyM1w8kEBmWYNeD4Gjp+Y= X-Gm-Gg: ATEYQzx+fZ6afFkt+3ZLyRC5400/a7M/mWWBL7Wf/caXQbJ2KO4vr3YaaBGUHuM6mgK HOIKJkavFGCFkPO/PvYtzTyvq2niZuuNI9IznGRWHDPjT+ancLyXnE66p439oDtK+h+iy1gjCWq KBKOpe75xtNKeh/Hpe8hfH26YCREwEPMocZNXtWwAqm34b3azBH8CzPx2SFwgMqKuucCY+JuuLE wVTSzaqt3HX75RX4fddi2LapAL4CFzmP3k+dZ3dJI6vxm1uFSrZcPSXsZ/lpfbFjC0izn5/sLgf 0/buhqUjCWaiU8pmYgZ5UXiHcCmw/Phf5nl3/riL X-Received: by 2002:a05:6871:6685:b0:41c:bbc8:71e6 with SMTP id 586e51a60fabf-422cfe594c1mr654060fac.37.1774987462112; Tue, 31 Mar 2026 13:04:22 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:a05:6802:5112:10b0:625:aba4:b950 with HTTP; Tue, 31 Mar 2026 13:04:21 -0700 (PDT) In-Reply-To: <2768410.1774987231@sss.pgh.pa.us> References: <1849705.1774809224@sss.pgh.pa.us> <2739511.1774981880@sss.pgh.pa.us> <2768410.1774987231@sss.pgh.pa.us> From: "David G. Johnston" Date: Tue, 31 Mar 2026 13:04:21 -0700 X-Gm-Features: AQROBzDx8c1sYhUXYIgYkR3Zc6nHtuY8Lbcyalg-xaSZ_fXMkajXQc1sJLEcC3w Message-ID: Subject: Re: docs: warn about post-data-only schema dumps with parallel restore. To: Tom Lane Cc: vaibhave postgres , "pgsql-hackers@postgresql.org" Content-Type: multipart/alternative; boundary="00000000000028fa9a064e577943" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000028fa9a064e577943 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, March 31, 2026, Tom Lane wrote: > "David G. Johnston" writes: > > On Tuesday, March 31, 2026, Tom Lane wrote: > >> Hmm, I think we could be a bit more definite than that. What do you > >> think of this advice: > >> > >> > >> When creating an archive (non-text) output file, it is advisable not t= o > >> restrict the set of database objects dumped, but instead plan to apply > >> any desired object filtering when reading the archive > >> with pg_restore. This will preserve > >> flexibility and possibly avoid problems at restore time; for details > >> see the documentation. However, > >> omitting table data () or large objects > >> () does not have any surprising > >> consequences. > >> > > > I=E2=80=99m against including that final sentence. The rest seems ok b= ut I=E2=80=99 > > suggest going with an explicit mention that =E2=80=9C=E2=80=94no-schema= is risky=E2=80=9D (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. --00000000000028fa9a064e577943 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Tuesday, March 31, 2026, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"= ;David G. Johnston" <= david.g.johnston@gmail.com> writes:
> On Tuesday, March 31, 2026, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Hmm, I think we could be a bit more definite than that.=C2=A0 What= do you
>> think of this advice:
>>
>> <para>
>> When creating an archive (non-text) output file, it is advisable n= ot to
>> restrict the set of database objects dumped, but instead plan to a= pply
>> any desired object filtering when reading the archive
>> with <application>pg_restore</application>.=C2=A0= This will preserve
>> flexibility and possibly avoid problems at restore time; for detai= ls
>> see the <xref linkend=3D"app-pgrestore"/> document= ation.=C2=A0 However,
>> omitting table data (<option>--no-data</option>) or la= rge objects
>> (<option>--no-large-objects</option>) does not ha= ve any surprising
>> consequences.
>> </para>

> I=E2=80=99m against including that final sentence.=C2=A0 The rest seem= s ok but I=E2=80=99
> suggest going with an explicit mention that =E2=80=9C=E2=80=94no-schem= a is risky=E2=80=9D (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.
=C2=A0
--00000000000028fa9a064e577943--