Re: What is the meaning of pg_restore output?

Поиск
Список
Период
Сортировка
От Alexandru Lazarev
Тема Re: What is the meaning of pg_restore output?
Дата
Msg-id CAL93h0EC5bVf3nCp9OJCMo3d8Z9n7VTU--JfFoH1Nj3v6a7b5g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: What is the meaning of pg_restore output?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: What is the meaning of pg_restore output?
Список 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?

Virus-free. www.avast.com

On Thu, Mar 8, 2018 at 11:32 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Adrian Klaver <adrian.klaver@aklaver.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Could not open extension control file “/usr/share/postgresql/10/extension/pg_similarity.control”: No such file or directory
Следующее
От: wambacher@posteo.de
Дата:
Сообщение: changing my mail address