From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: pg_dump: error: could not open large object
Date: Fri, 24 Feb 2023 09:07:38 -0600
Message-ID: <a67cd6d8-c68e-8dc6-faaa-ed4deaacd970@gmail.com> (raw)
In-Reply-To: <CALXoLqyUh3gfQjuVqBNFB6ZA7ATG1fPnjiUR9bNmAo8Kvg2yEg@mail.gmail.com>
References: <CALXoLqw9DXmk7aiC0xRW95iA8GWLBg43wtkhuupRC13DNB+OFg@mail.gmail.com>
<CALXoLqyUh3gfQjuVqBNFB6ZA7ATG1fPnjiUR9bNmAo8Kvg2yEg@mail.gmail.com>
"permission denied" is a pretty good place to start researching.
On 2/24/23 08:58, Ankur Kaushik wrote:
> While taking backup we are getting below issue, Please help for this issue
>
> pg_dump --username=postgres
> --host=db-progresql-nvirgina.us-east-1.rds.amazonaws.com
> <http://db-progresql-nvirgina.us-east-1.rds.amazonaws.com/> --port=5432 dbname
>
>
> pg_dump: error: could not open large object 3628599: ERROR: permission
> denied for large object 3628599
>
>
> Posgresql version : 14.3
>
>
> On Fri, Feb 24, 2023 at 8:25 PM Ankur Kaushik <ankurkaushik@gmail.com> wrote:
>
>
> While taking backup we are getting below issue, Please help for this issue
>
> pg_dump --username=postgres
> --host=db-progresql-nvirgina.us-east-1.rds.amazonaws.com
> <http://db-progresql-nvirgina.us-east-1.rds.amazonaws.com; --port=5432
> dbname
>
>
> pg_dump: error: could not open large object 3628599: ERROR:permission
> denied for large object 3628599
>
--
Born in Arizona, moved to Babylonia.
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: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: pg_dump: error: could not open large object
In-Reply-To: <a67cd6d8-c68e-8dc6-faaa-ed4deaacd970@gmail.com>
* 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