Re: Dump & restore in directory format and permissions are largely lost? - Mailing list pgsql-admin

From Tom Lane
Subject Re: Dump & restore in directory format and permissions are largely lost?
Date
Msg-id 592237.1623807036@sss.pgh.pa.us
Whole thread Raw
In response to Re: Dump & restore in directory format and permissions are largely lost?  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Dump & restore in directory format and permissions are largely lost?
List pgsql-admin
Wells Oliver <wells.oliver@gmail.com> 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



pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Re: Dump & restore in directory format and permissions are largely lost?
Next
From: Wells Oliver
Date:
Subject: Re: Dump & restore in directory format and permissions are largely lost?