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 16:32:54
Message-ID: 08f90e7b-8d08-d46e-abb7-85dd68bc3078@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!
>>
>> Database does not contain large objects.
>>
>> pg_dump starts to throw error
>>
>> ERROR:  permission denied for large object 200936761
>
> Did you do the pg_dump as a superuser?

No.

pg_dump needs to be invoked by non-superuser also. It backs up two
schemas, public and firma74 .

-n public -n firma74

command line options are used.

>
> You can query that to see what is there. I would not go about deleting
> until you find what the large objects are for.
>
select * from pg_largeobject

returns empty table.

Database has approx 50 schemas and many thousands of tables.

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2021-02-01 16:58:58 Re: permission denied for large object 200936761
Previous Message Adrian Klaver 2021-02-01 16:15:51 Re: permission denied for large object 200936761