MIME-Version: 1.0
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>
 <592237.1623807036@sss.pgh.pa.us>
In-Reply-To: <592237.1623807036@sss.pgh.pa.us>
From: Wells Oliver <wells.oliver@gmail.com>
Date: Tue, 15 Jun 2021 18:32:55 -0700
Message-ID: 
 <CAOC+FBWCXatLexA5cqG+BEkPyeyNO4eHj8VaEcDOsU2Ub7eu+g@mail.gmail.com>
Subject: Re: Dump & restore in directory format and permissions are largely
 lost?
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
 pgsql-admin <pgsql-admin@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000fd6cdc05c4d8136a"
Archived-At: 
 <https://www.postgresql.org/message-id/CAOC%2BFBWCXatLexA5cqG%2BBEkPyeyNO4eHj8VaEcDOsU2Ub7eu%2Bg%40mail.gmail.com>
Precedence: bulk

--000000000000fd6cdc05c4d8136a
Content-Type: text/plain; charset="UTF-8"

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@sss.pgh.pa.us> wrote:

> 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
>


-- 
Wells Oliver
wells.oliver@gmail.com <wellsoliver@gmail.com>

--000000000000fd6cdc05c4d8136a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Ah, I&#39;m sorry, is there a way to see grants contained =
in a dump?</div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gm=
ail_attr">On Tue, Jun 15, 2021 at 6:30 PM Tom Lane &lt;<a href=3D"mailto:tg=
l@sss.pgh.pa.us" target=3D"_blank">tgl@sss.pgh.pa.us</a>&gt; wrote:<br></di=
v><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;borde=
r-left:1px solid rgb(204,204,204);padding-left:1ex">Wells Oliver &lt;<a hre=
f=3D"mailto:wells.oliver@gmail.com" target=3D"_blank">wells.oliver@gmail.co=
m</a>&gt; writes:<br>
&gt; pg_restore -Fd -l db.full.dump/ | grep ACL | grep webaccess<br>
&gt; Shows nothing, though I use this role on many schemas and relations.<b=
r>
<br>
What do you think you&#39;re filtering for there?=C2=A0 The -l output for A=
CL entries<br>
will show the names of the objects and their owners, but not the grantees.<=
br>
<br>
&gt; Is there anything about this dump statement that would prevent some AC=
L<br>
&gt; lines from being generated?<br>
<br>
Not that I see.<br>
<br>
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 regards, tom lane<br>
</blockquote></div><br clear=3D"all"><div><br></div>-- <br><div dir=3D"ltr"=
><div dir=3D"ltr"><div>Wells Oliver<br><a href=3D"mailto:wellsoliver@gmail.=
com" target=3D"_blank">wells.oliver@gmail.com</a></div></div></div>

--000000000000fd6cdc05c4d8136a--