Re: permission denied for large object 200936761 - Mailing list pgsql-general

From Andrus
Subject Re: permission denied for large object 200936761
Date
Msg-id b0c71270-e5dd-76d8-8488-3e5ba3ace4ef@hot.ee
Whole thread Raw
In response to Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: permission denied for large object 200936761
List pgsql-general
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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: permission denied for large object 200936761
Next
From: Tom Lane
Date:
Subject: Re: Segmentation fault on startup