Re: pg_restore fails on extracted tar archives with large objects

From: Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>
To: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_restore fails on extracted tar archives with large objects
Date: 2026-11-20 19:41:01
Message-ID: awCiTRpMjV0cE4QN@bdtpg
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

On Fri, Nov 20, 2026 at 11:03:04AM -0600, Nathan Bossart wrote:
> On Fri, Nov 20, 2026 at 08:04:19AM +0000, Bertrand Drouvot wrote:
> > It looks like _PrepParallelRestore() is affected by the same issue. The stat()
> > fails, leaving the BLOBS entry’s dataLength at zero, so the parallel scheduler
> > cannot use the intended size estimate. Should this use the same filename
> > construction as _LoadLOs()?
>
> Good catch. Here's an updated patch.

Thanks for the new patch version! LGTM.

Regards,

--
Bertrand Drouvot
PostgreSQL Contributors Team
RDS Open Source Databases
Amazon Web Services: https://aws.amazon.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Antonin Houska 2026-11-20 19:41:58 Re: Table AM callback for logical decoding support (REPACK CONCURRENTLY)
Previous Message Muzzammil Sarwar 2026-11-20 19:11:11 Re: [PATCH] Fix leak when a plpgsql exception block catches an error from CALL