From: | Alexandru Lazarev <alexandru(dot)lazarev(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: What is the meaning of pg_restore output? |
Date: | 2018-03-17 14:30:14 |
Message-ID: | CAL93h0EC5bVf3nCp9OJCMo3d8Z9n7VTU--JfFoH1Nj3v6a7b5g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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"
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?
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=icon>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail&utm_term=link>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
On Thu, Mar 8, 2018 at 11:32 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
> > When I restore using 10.2 I see:
> > pg_restore: creating ACL "public.TABLE wl_week"
> > Do you see something similar?
>
> > My suspicion is that this might have something to do with the commits
> below:
>
> Yeah, this evidently changed in commits 3eb9a5e7c et al, which made ACL
> restore go through restore_toc_entry(). I think I figured that the
> "creating ACL" message that restore_toc_entry() would emit made the
> dedicated "setting owner and privileges" message redundant. It had also
> been misleading for quite some time, maybe forever: restore of that TOC
> entry would set the object's privileges all right, but if it ever had
> anything to do with setting the object's ownership, it was a really long
> time ago.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | wambacher | 2018-03-17 15:45:06 | changing my mail address |
Previous Message | Adrian Klaver | 2018-03-17 14:06:36 | Re: Could not open extension control file “/usr/share/postgresql/10/extension/pg_similarity.control”: No such file or directory |