Re: What is the meaning of pg_restore output?

On 03/08/2018 09:06 AM, Alexandru Lazarev wrote:
> client_min_messages GUC didn't change
>
> Commands are:
> pg_dump --host 127.0.0.1 --port 5432 --username postgres --format custom
> --blobs --file /tmp/postgresql.backup -Z9 my_db
>
> pg_restore -h 127.0.0.1 -p 5432 -U postgres -Fc -v -j$(nproc) -d my_db
> /tmp/postgresql.backup 2>&1 | tee /tmp/restore.txt
>
>

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:

https://git.postgresql.org/gitweb/?p=postgresql.git&a=search&h=HEAD&st=commit&s=+ACL

Someone with more knowledge of this will need to confirm or deny.

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com