On 2/1/21 2:20 PM, Andrus wrote:
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.
What code changed between the last backup and today?
Application does not create large objects. It uses bytea columns instead.
How to figure out what is this large object ?
You could try some of the functions here:
https://www.postgresql.org/docs/12/lo-funcs.html
to see if you can figure it out.
Andrus.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
