On Mon, 2021-02-01 at 18:32 +0200, Andrus wrote: > > > 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? > > No. > > pg_dump needs to be invoked by non-superuser also. It backs up two schemas, public and firma74 . 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. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
