Re: permission denied for large object 200936761

On 2/1/21 12:07 PM, Andrus wrote:
> Hi!
>>>
>>>  >Large objects exist independent of those. The important part of the 
>>> above is lomowner. Use that oid to find the role that owns the 
>>> objects here:
>>>
>>> /select rolname from pg_roles where oid = 30152 ; // 
> 
>>> Not sure what the above is supposed to be doing?
>>
> I showed the user definition
>>>
>>> It havent created any large objects.
>>
>> What hasn't created large objects?
> I
>>
>>>
>>> How to use this information to fix the issue ?
>>
>> Do the pg_dump as user clusteradmin.
> 
> This works. However I need to allow non-supoeruser to create backup 
> also. How to do this ?

Short term grant the dump user permissions on the large objects.

Long term figure out what they are and if they are needed or not.

> 
> Andrus.
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com