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(dot)klaver(at)aklaver(dot)com