On 2/1/21 9:55 AM, 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 ; //
/
returns my role , clusteradmin . I have superuser rights:
CREATE ROLE clusteradmin WITH
LOGIN
SUPERUSER
INHERIT
NOCREATEDB
NOCREATEROLE
NOREPLICATION:
GRANT db1_owner, db2_owner, ... to clusteradmin;
Not sure what the above is supposed to be doing?
It havent created any large objects.
What hasn't created large objects?
How to use this information to fix the issue ?
Do the pg_dump as user clusteradmin.
Andrus.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
