From: Tom Lane <tgl@sss.pgh.pa.us>
To: Erwin de Haan <erwin.de.haan@calcasa.nl>
cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: pg_restore with -j > 1 breaks the "clean" phase by not removing
 dependencies in order
In-reply-to: 
 <DU2PR01MB862463D00FF021DB969FE61CC82D2@DU2PR01MB8624.eurprd01.prod.exchangelabs.com>
References: 
 <DU2PR01MB862463D00FF021DB969FE61CC82D2@DU2PR01MB8624.eurprd01.prod.exchangelabs.com>
Comments: In-reply-to Erwin de Haan <erwin.de.haan@calcasa.nl>
	message dated "Mon, 18 Mar 2024 09:34:29 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3563772.1710772842.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 18 Mar 2024 10:40:42 -0400
Message-ID: <3563773.1710772842@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/3563773.1710772842%40sss.pgh.pa.us>
Precedence: bulk

Erwin de Haan <erwin.de.haan@calcasa.nl> writes:
> I'm having some trouble getting parallel restores to work. When running =
pg_restore like this:

> pg_restore --no-password --host=3D$MAIN_CLUSTER-pg-cluster --port=3D5432=
 --dbname=3D$name --jobs=3D4 --format=3Dd --no-owner --clean --if-exists -=
-disable-triggers --role=3D${name}_owner "/temp_data/data-$name-$UNIQUE_SU=
FFIX"

> the restore errors on foreign key constraints while removing tables, is =
there anyway to keep this parallel but have it respect the tree of depende=
ncies.

pg_restore does not parallelize the DROP stage of the process, so
I can't help thinking you've misidentified the source of the problem.

Can you provide a concrete example that misbehaves?
Also, what PG version is this?

			regards, tom lane