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.