pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedError while exporting large objects.
3+ messages / 2 participants
[nested] [flat]
* Error while exporting large objects.
@ 2023-06-02 13:43 Singh, Gambhir <gsingh2@kemper.com>
0 siblings, 1 reply; 3+ messages in thread
From: Singh, Gambhir @ 2023-06-02 13:43 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
____
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.
Attachments:
[image/jpeg] image163140.jpg (28.5K, ../../PH7PR10MB64571AB071CA4DAA867C1EED9F4EA@PH7PR10MB6457.namprd10.prod.outlook.com/3-image163140.jpg)
download | view image
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: Error while exporting large objects.
@ 2023-06-05 11:44 Singh, Gambhir <gsingh2@kemper.com>
parent: Singh, Gambhir <gsingh2@kemper.com>
0 siblings, 1 reply; 3+ messages in thread
From: Singh, Gambhir @ 2023-06-05 11:44 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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
Attachments:
[image/jpeg] image589919.jpg (28.5K, ../../PH7PR10MB64577E029B3CF4B92A149F589F4DA@PH7PR10MB6457.namprd10.prod.outlook.com/3-image589919.jpg)
download | view image
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Error while exporting large objects.
@ 2023-06-05 13:53 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Singh, Gambhir <gsingh2@kemper.com>
0 siblings, 0 replies; 3+ messages in thread
From: Laurenz Albe @ 2023-06-05 13:53 UTC (permalink / raw)
To: Singh, Gambhir <gsingh2@kemper.com>; pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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.
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-06-05 13:53 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-06-02 13:43 Error while exporting large objects. Singh, Gambhir <gsingh2@kemper.com>
2023-06-05 11:44 ` Singh, Gambhir <gsingh2@kemper.com>
2023-06-05 13:53 ` Laurenz Albe <laurenz.albe@cybertec.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox