RE: Error while exporting large objects.

["Singh, Gambhir" <gsingh2@xxxxxxxxxx>]

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@xxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxx
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