Postgres Pro
Downloads
Home   >   mailing lists

Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tablesbelonging to an extension - Mailing list pgsql-bugs

From Moshe Jacobson
Subject Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tablesbelonging to an extension
Date
Msg-id CAJ4CxLmGST-UkYzhrS-QbXLoXeYnZPPO7m7b9U=2RRr-cTArHQ@mail.gmail.com
Whole thread Raw
In response to Re: BUG #14456: pg_dump doesn't restore permissions on tables belonging to an extension  (Stephen Frost <sfrost@snowman.net>)
Responses Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tablesbelonging to an extension
List pgsql-bugs
Tree view
I'm experiencing issues with this new "feature". 
My extension dynamically creates extension-owned tables and puts ACLs on them.
When the database is dumped, it includes grants/revokes for those tables, which will not exist when the extension is re-installed.
As a result, when the database is restored, I keep getting warnings because it's trying to apply ACLs to tables that don't exist.

Is there a way around this issue?

On Thu, Dec 8, 2016 at 2:31 PM Stephen Frost <sfrost@snowman.net> wrote:
Greetings Daniele,

* daniele.varrazzo@gmail.com (daniele.varrazzo@gmail.com) wrote:
> PostgreSQL version: 9.5.4
[...]
> As per title. To test:

Prior to 9.6, dump/reload of an extension with custom ACLs wasn't
really supported.  This should work correctly in 9.6.  Unfortunately,
the changes required are too much to be able to back-patch to prior
versions of PG.

Thanks!

Stephen
--
Moshe Jacobson
Principal Architect, Nead Werx Inc.

pgsql-bugs by date:

Previous
From: Ragnar Ouchterlony
Date:
Subject: Re: [BUGS] Problem with declarative partitioning and COPY FROM
Next
From: Stephen Frost
Date:
Subject: Re: [BUGS] BUG #14456: pg_dump doesn't restore permissions on tablesbelonging to an extension