Re: permission denied for large object 200936761

Andrus <kobruleht2@xxxxxx> · Tue, 2 Feb 2021 00:20:45 +0200



    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.