| From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Cc: | long76(dot)git(at)mail(dot)ru |
| Subject: | BUG #19379: Role pg_read_all_data don't allowed read large objects |
| Date: | 2026-01-15 11:57:14 |
| Message-ID: | 19379-089536632927293f@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 19379
Logged by: Misha Shaygu
Email address: long76(dot)git(at)mail(dot)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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2026-01-15 13:36:35 | BUG #19379: Role pg_read_all_data don't allowed read large objects |
| Previous Message | Amit Langote | 2026-01-15 11:39:01 | Re: BUG #19355: Attempt to insert data unexpectedly during concurrent update |