Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_restore 14 skips ACL COLUMN when --schema is used - Mailing list pgsql-bugs

From Euler Taveira
Subject Re: pg_restore 14 skips ACL COLUMN when --schema is used
Date
Msg-id ece8667d-9824-4740-a150-617c9b3d9284@app.fastmail.com
Whole thread Raw
In response to Re: pg_restore 14 skips ACL COLUMN when --schema is used  ("Euler Taveira" <euler@eulerto.com>)
Responses Re: pg_restore 14 skips ACL COLUMN when --schema is used
List pgsql-bugs
Tree view
On Wed, Aug 2, 2023, at 5:53 PM, Euler Taveira wrote:
On Wed, Aug 2, 2023, at 5:06 PM, Tom Lane wrote:
Yeah, ignoring dependencies on ACLs in this logic seems like the best
way forward.  Do you want to write a patch?

I like your suggestion. Let me give it a try.

This patch should apply on all supported back branches (11-16).

In my previous email I forgot the --schema option in the pg_restore. The
correct steps are:

pg_dump -Fc -f /u/d.dump -d test
pg_restore -l /u/d.dump > /u/d.toc
pg_restore --schema=public --use-list=<(grep "ACL" /u/d.toc) -f - /u/d.dump


--
Euler Taveira
EDB   https://www.enterprisedb.com/

Attachment

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index
Next
From: PG Bug reporting form
Date:
Subject: BUG #18051: char(N) and varchar(N) behave opposite to the documentation