Re: permission denied for large object 200936761

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