pg_restore with --use-list and --jobs and depdendencies

From: Wells Oliver <wells(dot)oliver(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: pg_restore with --use-list and --jobs and depdendencies
Date: 2022-01-07 21:04:14
Message-ID: CAOC+FBV6y-skipCOyrjRxEow1xD9wD-i6PiADTG324_cMpDqaQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi all: I just wanted to clarify something for myself: how does pg_restore
determine restore order if you're using a --use-list and --jobs parameters.
Given the concurrency of jobs and (assuming) it goes in order of what's in
the list, does it... well, does it sort out dependencies properly so data
is inserted that foreign keys need, etc?

--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2022-01-07 22:26:31 Re: pg_restore with --use-list and --jobs and depdendencies
Previous Message ldh@laurent-hasson.com 2022-01-03 21:33:27 RE: CREATE TYPE error in PostgreSQL database!!!!!!