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