Re: pg_dump order of operation

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump order of operation
Date: 2018-08-26 18:42:35
Message-ID: 12838.1535308955@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron <ronljohnsonjr(at)gmail(dot)com> writes:
> On 08/26/2018 10:24 AM, Tom Lane wrote:
>> Ron <ronljohnsonjr(at)gmail(dot)com> writes:
>>> In what order does the 9.6 pg_dump dump tables?

>> I don't believe the ordering rules have changed materially since 8.4;
>> it's intended to be by object kind, and within that by name, except
>> where dependencies force doing something else.

> I thought that didn't matter, since FK and PK constraints were added (in the
> required order) after all data was loaded).

>> But what are you thinking constitutes the "dump order" in a parallel dump?

> I don't understand your question.

Perhaps I don't understand *your* question. What concrete problem are you
having?

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2018-08-26 19:26:38 Re: pg_dump order of operation
Previous Message Tom Lane 2018-08-26 18:39:50 Re: "cache lookup failed for type ####" when running unit tests