Re: permission denied for large object 200936761

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@aklaver.com