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.klaver@aklaver.com