Re: permission denied for large object 200936761

From: Andrus <kobruleht2(at)hot(dot)ee>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: permission denied for large object 200936761
Date: 2021-02-01 20:07:26
Message-ID: b0c71270-e5dd-76d8-8488-3e5ba3ace4ef@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-02-01 20:40:27 Re: Segmentation fault on startup
Previous Message Adrian Klaver 2021-02-01 19:59:53 Re: permission denied for large object 200936761