pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feed From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Tomas Vondra <tomas@vondra.me>
Cc: Andres Freund <andres@anarazel.de>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: Amul Sul <sulamul@gmail.com>
Cc: Zsolt Parragi <zsolt.parragi@percona.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Chao Li <li.evan.chao@gmail.com>
Cc: Anthonin Bonnefoy <anthonin.bonnefoy@datadoghq.com>
Cc: Fujii Masao <masao.fujii@gmail.com>
Cc: Jakub Wartak <jakub.wartak@enterprisedb.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: pg_waldump: support decoding of WAL inside tarfile
Date: Thu, 02 Apr 2026 18:50:50 -0400
Message-ID: <3676229.1775170250@sss.pgh.pa.us> (raw )
In-Reply-To: <CA+hUKG+A-=BKP69ze5oc4O5RSBZtKk7dGoqYLeOUQSo8xugTyg@mail.gmail.com >
References: <2250061.1774104346@sss.pgh.pa.us >
<3341199.1774221191@sss.pgh.pa.us >
<3424809.1774234940@sss.pgh.pa.us >
<acIA8KKBTv-T53YG@paquier.xyz >
<x2tknjejjouleunkqrvpnwn2tuulunybinycidefm3wmnsyhht@pw5uo3wrqx43 >
<CA+hUKGL2dppjO4o28ZY7n_LTWviKLAi-7KZ=tx5w2HGevCEYPA@mail.gmail.com >
<1624716.1774736283@sss.pgh.pa.us >
<1626907.1774737417@sss.pgh.pa.us >
<97a382c0-1f19-4ea0-951f-e37e6abc34a3@vondra.me >
<1630755.1774739531@sss.pgh.pa.us >
<c3a2b730-9d90-4a66-ae5e-50f6d77922d6@vondra.me >
<CA+hUKGJyvdyWMC-RW1njqevD-q_gTbFq+DyDiFpUJVaG+DY20w@mail.gmail.com >
<1873141.1774823011@sss.pgh.pa.us >
<CA+hUKG+Pqz5=YQG_=8ho0YsTfn2HWOsJQWqS4j0q8QQWweJP9w@mail.gmail.com >
<3049460.1775067940@sss.pgh.pa.us >
<3118179.1775092964@sss.pgh.pa.us >
<CA+hUKG+-pn14s_tjEBO6YKHmc=uRhGVn=w2oM91KKnEUc7pH0Q@mail.gmail.com >
<3565835.1775147392@sss.pgh.pa.us >
<3579709.1775151816@sss.pgh.pa.us >
<63de1553-829a-488d-8ee0-976afb8dd32c@vondra.me >
<3586483.1775155672@sss.pgh.pa.us >
<CA+hUKG+A-=BKP69ze5oc4O5RSBZtKk7dGoq! YLeOUQSo8xugTyg@mail.gmail.com >
Thomas Munro <thomas.munro@gmail.com> writes:
> On Fri, Apr 3, 2026 at 7:48 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Interestingly, pg_verifybackup's t/003_corruption.pl test also fails
>> with the same issue, so apparently this platform is even more
>> aggressive about sparse-ifying files than Thomas' FreeBSD box.
> Looks like sparse files and BTRFS might be a red herring then, if it's
> simply been told to put a pax header on every file?
It looked to me that it was only putting a pax header on sparse-ified
WAL files.
> How about using --format=ustar, instead of that sparse control stuff?
I did it that way for GNU tar, but did not research whether bsdtar
will take that option. Feel free to hack on ebba64c08 some more.
(It seems though that the two tars' locutions for "write to stdout"
are different, so we might have to have separate tests even if they
end up pushing the same option.)
regards, tom lane
view thread (122+ messages) latest in thread
Message-ID: <3676229.1775170250@sss.pgh.pa.us>
Permalink: ../3676229.1775170250@sss.pgh.pa.us/
Also on: postgresql.org/message-id/3676229.1775170250@sss.pgh.pa.us
copy link · copy postgr.es
reply Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, thomas.munro@gmail.com, tomas@vondra.me, andres@anarazel.de, michael@paquier.xyz, andrew@dunslane.net, sulamul@gmail.com, zsolt.parragi@percona.com, robertmhaas@gmail.com, li.evan.chao@gmail.com, anthonin.bonnefoy@datadoghq.com, masao.fujii@gmail.com, jakub.wartak@enterprisedb.com, pgsql-hackers@lists.postgresql.org
Subject: Re: pg_waldump: support decoding of WAL inside tarfile
In-Reply-To: <3676229.1775170250@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox