Re: pg_restore fails on extracted tar archives with large objects

From: Nathan Bossart <nathandbossart(at)gmail(dot)com>
To: Bertrand Drouvot <bertranddrouvot(dot)pg(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 17:03:04
Message-ID: awB9SALtymS9VpGp@nathan
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.

--
nathan

Attachment Content-Type Size
v2-0001-pg_restore-Fix-incompatibilities-with-extracted-t.patch text/plain 3.5 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2026-11-20 17:09:20 Re: Backpatch for fix simplehash to preserve consistency in case of OOM
Previous Message Gilles Darold 2026-11-20 16:59:09 Backpatch for fix simplehash to preserve consistency in case of OOM