public inbox for pgsql-bugs@postgresql.org  

help / color / mirror / Atom feed

From: Глеб Борков <long76.git@mail.ru>
To: Pierre Forstmann <pierre.forstmann@gmail.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re[2]: BUG #19379: Role pg_read_all_data don't allowed read large objects
Date: Thu, 15 Jan 2026 17:05:07 +0300
Message-ID: <1768485907.635425063@f474.i.mail.ru> (raw)
In-Reply-To: <908bf36d-51e5-469e-aa2e-062ab68dca59@gmail.com>
References: <19379-089536632927293f@postgresql.org>
	<CAKFQuwZbtoAs1Ew62aC25R1r7i=M1J_3UmCsssidwDn2Xe6XhA@mail.gmail.com>
	<908bf36d-51e5-469e-aa2e-062ab68dca59@gmail.com>


Thanks for answers. And maybe pg_read_all_data without read lo don't allow read all data because need read data from lo. It's makes role pg_read_all_data useless. I hope for a speedy fix. четверг, 15 января 2026г., 16:47 +03:00 от Pierre Forstmann  pierre.forstmann@gmail.com :

>It could be interesting to have a new predefined role
>      pg_read_all_lo to be able to read all LO.
>Maybe it could be done with an extension with some background
>      task to take into account newly created LO but it should be easier
>      to have this coded without an extension.
>Le 15/01/2026 à 14:36, David G.
>      Johnston a écrit :
>>On Thursday, January 15, 2026, PG Bug reporting form < noreply@postgresql.org> 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 “tables, views,
>>        sequences”.  Large objects are not listed.  Maybe that means the
>>        name is a bit misleading but it’s working as documented.
>>
>>Likewise, the LO page doesn’t say anything about read all
>>        being applicable.
>>
>>David J.
>> 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: long76.git@mail.ru, pierre.forstmann@gmail.com, david.g.johnston@gmail.com, pgsql-bugs@lists.postgresql.org
  Subject: Re: Re[2]: BUG #19379: Role pg_read_all_data don't allowed read large objects
  In-Reply-To: <1768485907.635425063@f474.i.mail.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox