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@xxxxxxxxxxx
