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@xxxxxxxxxxx
