Re: pg_dump: error: could not open large object

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: pg_dump: error: could not open large object
Date: 2023-02-24 15:07:38
Message-ID: a67cd6d8-c68e-8dc6-faaa-ed4deaacd970@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"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(at)gmail(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Chris Hoover 2023-02-25 02:08:58 New PG14 server won't start with >2GB shared_buffers
Previous Message Ankur Kaushik 2023-02-24 14:58:40 Re: pg_dump: error: could not open large object