On 2/1/21 6:43 AM, Andrus wrote:
Hi!
Database does not contain large objects.
pg_dump starts to throw error
ERROR: permission denied for large object 200936761
Did you do the pg_dump as a superuser?
More below.
Tried
select * from "200936761"
but it returned "relation does not exist"
How to fix this ? How to find which table causes this error ?
Large objects are stored in a system catalog(table):
https://www.postgresql.org/docs/12/catalog-pg-largeobject.html
You can query that to see what is there. I would not go about deleting
until you find what the large objects are for.
How to find and delete all large objects in database ? Maybe it is
created accidently .
Using
PostgreSQL 12.2 (Debian 12.2-2.pgdg100+1) on x86_64-pc-linux-gnu,
compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
Andrus.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
