Re: permission denied for large object 200936761

On 2/1/21 8:32 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?
>
> No.
>
> pg_dump needs to be invoked by non-superuser also. It backs up two
> schemas, public and firma74 .

Well the user that runs the pg_dump needs to have permissions on the
large objects. For more information see below.

>
> -n public -n firma74
>
> command line options are used.
>
>>
>> You can query that to see what is there. I would not go about deleting
>> until you find what the large objects are for.
>>
> select * from pg_largeobject
>
> returns empty table.

I haven't used large objects in a while. Forgot that they now have
permissions associated with them. Try:

https://www.postgresql.org/docs/12/catalog-pg-largeobject-metadata.html

instead.

>
> Database has approx 50 schemas and many thousands of tables.
>
> Andrus.
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com