BUG #19379: Role pg_read_all_data don't allowed read large objects - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #19379: Role pg_read_all_data don't allowed read large objects
Date
Msg-id 19379-089536632927293f@postgresql.org
Whole thread Raw
Responses BUG #19379: Role pg_read_all_data don't allowed read large objects
List pgsql-bugs
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!





pgsql-bugs by date:

Previous
From: Amit Langote
Date:
Subject: Re: BUG #19355: Attempt to insert data unexpectedly during concurrent update
Next
From: "David G. Johnston"
Date:
Subject: BUG #19379: Role pg_read_all_data don't allowed read large objects