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