RE: Error while exporting large objects.

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(at)kemper(dot)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(at)lists(dot)postgresql(dot)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