From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Alexandru Lazarev <alexandru(dot)lazarev(at)gmail(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: What is the meaning of pg_restore output? |
Date: | 2018-03-17 16:20:48 |
Message-ID: | a856ad02-38c1-1a9d-a655-1536d0627aad@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 03/17/2018 07:30 AM, Alexandru Lazarev wrote:
> Hi All, Thanks for your replies.
> What about "item" key-word - is it appearing only when -j > 1?
>
> Other phrases "pg_restore: processing /*item */3615 DEFAULT id
> pg_restore: creating DEFAULT "public.id <http://public.id>"
> are observed if pg_restore is executed with flag -j N (where N > 1)
> and aren't present when -j 1 (or without -j)
>
>
> 2. Are they (output phrases) documented somewhere?
Grepping source in src/bin/pg_dump/:
if (do_now)
{
/* OK, restore the item and update its dependencies */
ahlog(AH, 1, "processing item %d %s %s\n",
next_work_item->dumpId,
next_work_item->desc, next_work_item->tag);
Which is in section with this comment:
/*
* Main engine for parallel restore.
*
* Parallel restore is done in three phases. In this first phase,
* we'll process all SECTION_PRE_DATA TOC entries that are allowed to be
* processed in the RESTORE_PASS_MAIN pass. (In practice, that's all
* PRE_DATA items other than ACLs.) Entries we can't process now are
* added to the pending_list for later phases to deal with.
*/
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Johnson | 2018-03-17 17:13:16 | Re: changing my mail address |
Previous Message | wambacher | 2018-03-17 15:56:48 | Re: changing my mail address |