From: Tom Lane <tgl@sss.pgh.pa.us>
To: Wells Oliver <wells.oliver@gmail.com>
cc: "David G. Johnston" <david.g.johnston@gmail.com>,
        pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Dump & restore in directory format and permissions are largely
 lost?
In-reply-to: 
 <CAOC+FBUuZ6gvhtxZknn_NbH0eMh3CTS8bf1Toq+XxPp7E4c5yg@mail.gmail.com>
References: 
 <CAOC+FBUk6FGOa0NGaFKX_jJTmOgN-xLTWFKm5MsdnDRqoQ9p-g@mail.gmail.com>
 <CAKFQuwYHezea03kxRTcHg3Jo8+c-xQo8TXdDipHj6woaKacGCw@mail.gmail.com>
 <CAOC+FBVYfA9y=QL2rvW751t3FffryTTyCJF40-phG5wEomOc9g@mail.gmail.com>
 <591499.1623806357@sss.pgh.pa.us>
 <CAOC+FBUuZ6gvhtxZknn_NbH0eMh3CTS8bf1Toq+XxPp7E4c5yg@mail.gmail.com>
Comments: In-reply-to Wells Oliver <wells.oliver@gmail.com>
	message dated "Tue, 15 Jun 2021 18:23:03 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <592236.1623807036.1@sss.pgh.pa.us>
Date: Tue, 15 Jun 2021 21:30:36 -0400
Message-ID: <592237.1623807036@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/592237.1623807036%40sss.pgh.pa.us>
Precedence: bulk

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