MIME-Version: 1.0
From: vaibhave postgres <postgresvaibhave@gmail.com>
Date: Mon, 26 Jan 2026 10:53:19 +0530
Message-ID: <CAM_eQjzTLtt1X9WKvMV6Rew0UvxT3mmhimZa9WT-vqaPjmXk-g@mail.gmail.com>
Subject: docs: warn about post-data-only schema dumps with parallel restore.
To: pgsql-hackers@postgresql.org
Content-Type: multipart/mixed; boundary="0000000000001ba6e7064943b52b"
Archived-At: <https://www.postgresql.org/message-id/CAM_eQjzTLtt1X9WKvMV6Rew0UvxT3mmhimZa9WT-vqaPjmXk-g%40mail.gmail.com>
Precedence: bulk

--0000000000001ba6e7064943b52b
Content-Type: multipart/alternative; boundary="0000000000001ba6e7064943b529"

--0000000000001ba6e7064943b529
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=99m 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/3908.1717093769@sss.pgh.pa.us>

--0000000000001ba6e7064943b529
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi hackers,<div><br></div><div>Following up on the discuss=
ion in [1] about pg_restore failing to restore post-data items due to circu=
lar foreign key deadlocks.=C2=A0=C2=A0</div><div><br></div><div>I=E2=80=99m=
 attaching a doc patch that adds a warning about using post-data-only schem=
a dumps together with parallel restore.</div><div><br></div><div>Thanks.</d=
iv><div><br></div><div>[1]=C2=A0<a href=3D"https://postgrespro.com/list/id/=
3908.1717093769@sss.pgh.pa.us">Re: pg_restore: fails to restore post-data i=
tems due to circular FK deadlock - Mailing list pgsql-bugs : Postgres Profe=
ssional</a></div></div>

--0000000000001ba6e7064943b529--
--0000000000001ba6e7064943b52b
Content-Type: application/octet-stream; 
	name="0001-doc-warn-about-post-data-only-schema-dumps-with-para.patch"
Content-Disposition: attachment; 
	filename="0001-doc-warn-about-post-data-only-schema-dumps-with-para.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mkupvb0o0>
X-Attachment-Id: f_mkupvb0o0

RnJvbSAyZDQzODI3OGRlYmY0MzIxNWUyMTg1NjExZDJmOTk2ZDA5ODg2MjY4IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBWYWliaGF2ZSBTZWthciA8dnNla2FyQG1pY3Jvc29mdC5jb20+
CkRhdGU6IFN1biwgMjUgSmFuIDIwMjYgMTA6NTQ6MDAgKzAwMDAKU3ViamVjdDogW1BBVENIXSBk
b2M6IHdhcm4gYWJvdXQgcG9zdC1kYXRhLW9ubHkgc2NoZW1hIGR1bXBzIHdpdGggcGFyYWxsZWwK
IHJlc3RvcmUuCgotLS0KIGRvYy9zcmMvc2dtbC9yZWYvcGdfZHVtcC5zZ21sIHwgMTEgKysrKysr
KysrKysKIDEgZmlsZSBjaGFuZ2VkLCAxMSBpbnNlcnRpb25zKCspCgpkaWZmIC0tZ2l0IGEvZG9j
L3NyYy9zZ21sL3JlZi9wZ19kdW1wLnNnbWwgYi9kb2Mvc3JjL3NnbWwvcmVmL3BnX2R1bXAuc2dt
bAppbmRleCA1YmExNjdiMzNlNy4uY2M0MTBlMDBkN2YgMTAwNjQ0Ci0tLSBhL2RvYy9zcmMvc2dt
bC9yZWYvcGdfZHVtcC5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9yZWYvcGdfZHVtcC5zZ21sCkBA
IC0xMjcyLDYgKzEyNzIsMTcgQEAgUG9zdGdyZVNRTCBkb2N1bWVudGF0aW9uCiAgICAgICAgICAg
YW5kIGNvbnN0cmFpbnRzIG90aGVyIHRoYW4gdmFsaWRhdGVkIGNoZWNrIGNvbnN0cmFpbnRzLgog
ICAgICAgICAgIFByZS1kYXRhIGl0ZW1zIGluY2x1ZGUgYWxsIG90aGVyIGRhdGEgZGVmaW5pdGlv
biBpdGVtcy4KICAgICAgICAgIDwvcGFyYT4KKyAgICAgICAgICAgPG5vdGU+CisgICAgICAgICAg
ICA8cGFyYT4KKyAgICAgICAgICAgICBBcmNoaXZlcyB0aGF0IGNvbnRhaW4gb25seSA8b3B0aW9u
PnBvc3QtZGF0YTwvb3B0aW9uPiBvbWl0IHRhYmxlIGVudHJpZXMuCisgICAgICAgICAgICAgV2hl
biBzdWNoIGFuIGFyY2hpdmUgaXMgcmVzdG9yZWQgaW4gcGFyYWxsZWwsIGNvbnN0cmFpbnQgY3Jl
YXRpb24gY2FuCisgICAgICAgICAgICAgZmFpbCBiZWNhdXNlIDxhcHBsaWNhdGlvbj5wZ19yZXN0
b3JlPC9hcHBsaWNhdGlvbj4gY2Fubm90IG9yZGVyIGZvcmVpZ24KKyAgICAgICAgICAgICBrZXlz
IHRoYXQgZGVwZW5kIG9uIHRhYmxlcyBub3QgcHJlc2VudCBpbiB0aGUgYXJjaGl2ZS4gIFRvIGF2
b2lkIHRoaXMsCisgICAgICAgICAgICAgdGFrZSBhIHNjaGVtYS1pbmNsdXNpdmUgZHVtcCAoZm9y
IGV4YW1wbGUsIDxvcHRpb24+LS1zY2hlbWEtb25seTwvb3B0aW9uPgorICAgICAgICAgICAgIG9y
IHRoZSBkZWZhdWx0KSwgdGhlbiBmaWx0ZXIgc2VjdGlvbnMgYXQgcmVzdG9yZSB0aW1lLCBvciBy
ZXN0b3JlIHRoZQorICAgICAgICAgICAgIHBvc3QtZGF0YS1vbmx5IGFyY2hpdmUgd2l0aCA8b3B0
aW9uPi1qMTwvb3B0aW9uPi4KKyAgICAgICAgICAgIDwvcGFyYT4KKyAgICAgICAgICAgPC9ub3Rl
PgogICAgICAgIDwvbGlzdGl0ZW0+CiAgICAgIDwvdmFybGlzdGVudHJ5PgogCi0tIAoyLjQzLjAK
Cg==
--0000000000001ba6e7064943b52b--