RE: Error while exporting large objects. - Mailing list pgsql-admin

Please provide some update on this. This is showstopper in my prod env.

Thanks & Regards

Gambhir Singh

____ Gambhir   Singh Contractors ‑ Projects Kemper Corporate Services Chicago ,  IL   60601 E  gsingh2@kemper.com kemper.com

CONFIDENTIALITY NOTICE: This communication may contain ​ confidential information intended only for the addressee(s). If you received  this communication in error, please notify the sender and delete it from your  system. ​

From: Singh, Gambhir
Sent: Friday, June 2, 2023 09:44 AM
To: pgsql-admin@lists.postgresql.org
Subject: Error while exporting large objects.

Hi,

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

Format used to do export is :-

./pg_dump -f 'C:\Users\101\Desktop\abc.dmp' -v -b -h ************.amazonaws.com -n abc -U admin1 -d db1 > 'C:\Users\101\Desktop\export.log'

Thanks & Regards

Gambhir Singh