| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | "Singh, Gambhir" <gsingh2(at)kemper(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Error while exporting large objects. |
| Date: | 2023-06-05 13:53:55 |
| Message-ID: | 9a869f91ea1eb760fb38c144ccad2f747bc68e38.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mark McMillan | 2023-06-05 14:11:15 | Fatal Error KeyError: 'ck_port_range' after upgrade |
| Previous Message | Singh, Gambhir | 2023-06-05 11:44:48 | RE: Error while exporting large objects. |