Re: pg_dump order of operation

On 08/26/2018 01:42 PM, Tom Lane wrote:
> 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?

I want to track the progress of pg_dump so as to estimate completion time.

--
Angular momentum makes the world go 'round.