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

From Andrus
Subject Re: permission denied for large object 200936761
Date
Msg-id 6f141378-2651-3c71-1bab-8b5700e45fbd@hot.ee
Whole thread Raw
In response to permission denied for large object 200936761  (Andrus <kobruleht2@hot.ee>)
Responses Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general

Hi!

>Obviously large objects *are* used.

>You have to grant the database use permissions with

>  GRANT SELECT ON LARGE OBJECT 200936761 TO dumpuser;

>Alternatively, use the -B option of pg_dump to skip dumping
>large objects.

I added -B option and changed postgresql.conf  to  lo_compat_privileges=on   as temporary fix.

dumpuser has created backups of same two schemas for years without issues. The issue starts to occur today.

Application does not create large objects. It uses bytea columns instead.

How to figure out what is this large object ?

Andrus.

pgsql-general by date:

Previous
From: Martín Marqués
Date:
Subject: Re: vacuum is time consuming
Next
From: Adrian Klaver
Date:
Subject: Re: permission denied for large object 200936761