MIME-Version: 1.0
In-Reply-To: <19379-089536632927293f@postgresql.org>
References: <19379-089536632927293f@postgresql.org>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 15 Jan 2026 06:36:35 -0700
Message-ID: <CAKFQuwZbtoAs1Ew62aC25R1r7i=M1J_3UmCsssidwDn2Xe6XhA@mail.gmail.com>
Subject: BUG #19379: Role pg_read_all_data don't allowed read large objects
To: "long76.git@mail.ru" <long76.git@mail.ru>, 
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000052f19f06486d505f"
Archived-At: <https://www.postgresql.org/message-id/CAKFQuwZbtoAs1Ew62aC25R1r7i%3DM1J_3UmCsssidwDn2Xe6XhA%40mail.gmail.com>
Precedence: bulk

--00000000000052f19f06486d505f
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thursday, January 15, 2026, PG Bug reporting form <noreply@postgresql.or=
g>
wrote:

> The following bug has been logged on the website:
>
> Bug reference:      19379
> Logged by:          Misha Shaygu
> Email address:      long76.git@mail.ru
> PostgreSQL version: 17.7
> Operating system:   Kubuntu 24.04
> Description:
>
> My goal: create role for backup any database on server
>
> Steps:
> 1. CREATE USER backup_user;
> 2. GRANT pg_read_all_data TO backup_user;
> 3. pg_dump my_db
> 4. got error to read large object
>
> Following by links
> https://www.postgresql.org/docs/17/predefined-roles.html
> https://www.postgresql.org/docs/17/lo-implementation.html
> "SELECT privileges are required to read a large object" and role
> "pg_read_all_data" grant it, but it don't work!
>
> Please fix it, thanks!
>

The docs you link note that all data is =E2=80=9Ctables, views, sequences=
=E2=80=9D.  Large
objects are not listed.  Maybe that means the name is a bit misleading but
it=E2=80=99s working as documented.

Likewise, the LO page doesn=E2=80=99t say anything about read all being app=
licable.

David J.

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

On Thursday, January 15, 2026, PG Bug reporting form &lt;<a href=3D"mailto:=
noreply@postgresql.org" target=3D"_blank">noreply@postgresql.org</a>&gt; wr=
ote:<br><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border=
-left:1px #ccc solid;padding-left:1ex">The following bug has been logged on=
 the website:<br>
<br>
Bug reference:=C2=A0 =C2=A0 =C2=A0 19379<br>
Logged by:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Misha Shaygu<br>
Email address:=C2=A0 =C2=A0 =C2=A0 <a href=3D"mailto:long76.git@mail.ru" ta=
rget=3D"_blank">long76.git@mail.ru</a><br>
PostgreSQL version: 17.7<br>
Operating system:=C2=A0 =C2=A0Kubuntu 24.04<br>
Description:=C2=A0 =C2=A0 =C2=A0 =C2=A0 <br>
<br>
My goal: create role for backup any database on server<br>
<br>
Steps:<br>
1. CREATE USER backup_user;<br>
2. GRANT pg_read_all_data TO backup_user;<br>
3. pg_dump my_db<br>
4. got error to read large object<br>
<br>
Following by links<br>
<a href=3D"https://www.postgresql.org/docs/17/predefined-roles.html" target=
=3D"_blank">https://www.postgresql.org/doc<wbr>s/17/predefined-roles.html</=
a><br>
<a href=3D"https://www.postgresql.org/docs/17/lo-implementation.html" targe=
t=3D"_blank">https://www.postgresql.org/doc<wbr>s/17/lo-implementation.html=
</a><br>
&quot;SELECT privileges are required to read a large object&quot; and role<=
br>
&quot;pg_read_all_data&quot; grant it, but it don&#39;t work!<br>
<br>
Please fix it, thanks!<br>
</blockquote><div><br></div><div>The docs you link note that all data is =
=E2=80=9Ctables, views, sequences=E2=80=9D.=C2=A0 Large objects are not lis=
ted.=C2=A0 Maybe that means the name is a bit misleading but it=E2=80=99s w=
orking as documented.</div><div><br></div><div>Likewise, the LO page doesn=
=E2=80=99t say anything about read all being applicable.</div><div><br></di=
v><div>David J.</div><div>=C2=A0</div>

--00000000000052f19f06486d505f--