Ah, I'm sorry, is there a way to see grants contained in a dump?
On Tue, Jun 15, 2021 at 6:30 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Wells Oliver <wells.oliver@xxxxxxxxx> writes:
> pg_restore -Fd -l db.full.dump/ | grep ACL | grep webaccess
> Shows nothing, though I use this role on many schemas and relations.
What do you think you're filtering for there? The -l output for ACL entries
will show the names of the objects and their owners, but not the grantees.
> Is there anything about this dump statement that would prevent some ACL
> lines from being generated?
Not that I see.
regards, tom lane
Wells Oliver
wells.oliver@xxxxxxxxx
wells.oliver@xxxxxxxxx
