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

From Andrus
Subject Re: permission denied for large object 200936761
Date
Msg-id 08f90e7b-8d08-d46e-abb7-85dd68bc3078@hot.ee
Whole thread Raw
In response to Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
List 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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: permission denied for large object 200936761
Next
From: Adrian Klaver
Date:
Subject: Re: permission denied for large object 200936761