Horton

docs: warn about post-data-only schema dumps with parallel restore.

vaibhave postgres <postgresvaibhave@gmail.com>

View thread View on postgr.es
From: vaibhave postgres <postgresvaibhave@gmail.com>
To: pgsql-hackers@postgresql.org
Date: 2026-01-26T05:23:19Z
Lists: pgsql-hackers

Attachments

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/3908.1717093769@sss.pgh.pa.us>

Commits

  1. Doc: warn that parallel pg_restore may fail if --no-schema was used.