Re: pg_restore fails on extracted tar archives with large objects

From: Sami Imseih <samimseih(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-19 23:11:21
Message-ID: CAN12+YL-zUa3vRFA-wrVDy_j4gcjvE2XO-x7CjDmYw-mY3vWrA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

> The attached patch fixes it by constructing the file name instead of using
> the one in the TOC entry.

I was able to reproduce this, and the patch fixes it for me. For
completeness I also tried multiple BLOBS batches and -j2, though I
didn't expect any problems, and directory-format dumps with large
objects still restore fine too. LGTM.

Maybe we could add a small test to 011_restore.pl, which already
pg_dumps and unpacks a tar archive, though if tar is headed for
deprecation it may not be worth the trouble atm.

--
Sami

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2026-11-19 23:22:19 Re: A bug in recovery prefetcher, triggering asserts / FATAL: checkpoint request failed
Previous Message Fujii Masao 2026-11-19 23:07:55 Re: A bug in recovery prefetcher, triggering asserts / FATAL: checkpoint request failed