From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Singh, Gambhir <gsingh2@kemper.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Error while exporting large objects.
Date: Mon, 05 Jun 2023 15:53:55 +0200
Message-ID: <9a869f91ea1eb760fb38c144ccad2f747bc68e38.camel@cybertec.at> (raw)
In-Reply-To: <PH7PR10MB64577E029B3CF4B92A149F589F4DA@PH7PR10MB6457.namprd10.prod.outlook.com>
References: <PH7PR10MB64571AB071CA4DAA867C1EED9F4EA@PH7PR10MB6457.namprd10.prod.outlook.com>
<PH7PR10MB64577E029B3CF4B92A149F589F4DA@PH7PR10MB6457.namprd10.prod.outlook.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, gsingh2@kemper.com, pgsql-admin@lists.postgresql.org
Subject: Re: Error while exporting large objects.
In-Reply-To: <9a869f91ea1eb760fb38c144ccad2f747bc68e38.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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