Re: permission denied for large object 200936761

[Andrus <kobruleht2@xxxxxx>]

    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 ?

Andrus.