Re: Error while exporting large objects.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


On Mon, 2023-06-05 at 11:44 +0000, Singh, Gambhir wrote:
> > While exporting the large objects getting error mentioned below. I’m trying to take export on Aurora PostgreSQL.
> >
> > pg_dump: error: could not open large object 28534: ERROR:  permission denied for large object 28534
> Please provide some update on this. This is showstopper in my prod env.

You have to use a database user that has the required permission.

Connect with "psql" and run

 \lo_list+ 28534

to see the permissions on the large object.

Laurenz Albe

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux