Re: pg_waldump: support decoding of WAL inside tarfile

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>
Cc: Tomas Vondra <tomas(at)vondra(dot)me>, Andres Freund <andres(at)anarazel(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Amul Sul <sulamul(at)gmail(dot)com>, Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, Anthonin Bonnefoy <anthonin(dot)bonnefoy(at)datadoghq(dot)com>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Jakub Wartak <jakub(dot)wartak(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_waldump: support decoding of WAL inside tarfile
Date: 2026-03-28 22:36:57
Message-ID: 1626907.1774737417@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
> However ... I do not find any indication in the GNU tar docs
> that it produces sparse files by default. It looks like you
> need to say -S/--sparse to make that happen. Maybe you have
> a version that's been hacked to make that the default?

Bleah. Digging in the man pages at freebsd.org, I read

--read-sparse
(c, r, u modes only) Read sparse file information from disk.
This is the reverse of --no-read-sparse and the default behav-
ior.

It's apparently been there and been default since FreeBSD 13.1.
This leads one to wonder how come BF member dikkop is managing
to run this test successfully. I speculate that it's using a
filesystem type that doesn't do sparse files (cc'ing Vondra
for confirmation on that).

It looks like to make this test stable on modern FreeBSD,
we need to see if tar accepts --no-read-sparse and use that
switch if so.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2026-03-28 22:57:37 Re: pg_waldump: support decoding of WAL inside tarfile
Previous Message Tom Lane 2026-03-28 22:18:03 Re: pg_waldump: support decoding of WAL inside tarfile