On 2/1/21 6:43 AM, Andrus wrote:
> 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?
More below.
>
> Tried
>
> select * from "200936761"
>
> but it returned "relation does not exist"
>
> How to fix this ? How to find which table causes this error ?
Large objects are stored in a system catalog(table):
https://www.postgresql.org/docs/12/catalog-pg-largeobject.html
You can query that to see what is there. I would not go about deleting
until you find what the large objects are for.
>
> How to find and delete all large objects in database ? Maybe it is
> created accidently .
>
> Using
>
> PostgreSQL 12.2 (Debian 12.2-2.pgdg100+1) on x86_64-pc-linux-gnu,
> compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
>
> Andrus.
>
--
Adrian Klaver
adrian.klaver@aklaver.com