Home > mailing lists

pg_dump: error: could not open large object - Mailing list pgsql-admin

From	Ankur Kaushik
Subject	pg_dump: error: could not open large object
Date	February 24, 2023 17:55:09
Msg-id	CALXoLqw9DXmk7aiC0xRW95iA8GWLBg43wtkhuupRC13DNB+OFg@mail.gmail.com Whole thread Raw
Responses	Re: pg_dump: error: could not open large object (Ankur Kaushik <ankurkaushik@gmail.com>)
List	pgsql-admin

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 --port=5432 dbname

pg_dump: error: could not open large object 3628599: ERROR: permission denied for large object 3628599

From: Laurenz Albe
Date: 24 February 2023, 16:00:12
Subject: Re: PostgreSQL, change encoding preserving data

From: Ankur Kaushik
Date: 24 February 2023, 17:58:40
Subject: Re: pg_dump: error: could not open large object