Re: pg_waldump: support decoding of WAL inside tarfile

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Tomas Vondra <tomas(at)vondra(dot)me>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, 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-04-02 17:43:36
Message-ID: 3579709.1775151816@sss.pgh.pa.us
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tomas Vondra <tomas(at)vondra(dot)me> writes:
> On 4/2/26 18:29, Tom Lane wrote:
>> Pushed, thanks for reviewing! In the event I decided to back-patch to
>> v18, where these fixes could protect pg_verifybackup against tar files
>> it can't handle.

> It seems jay/hippopotamus failed on this, for some reason.

Hmm:

# Failed test 'corrupt backup fails verification: extra_file: matches'
# at t/003_corruption.pl line 198.
# 'pg_verifybackup: error: pax extensions to tar format are not supported
# '
# doesn't match '(?^:extra_file.*present (on disk|in archive "[^"]+") but not in the manifest)'

> Maybe there's something special about OpenSUSE?

Apparently its version of "tar" will produce pax-extended files
at the drop of a hat. I have an OpenSUSE image around here
somewhere, will see if I can reproduce this. But while I'm
asking, what filesystem are those animals running on top of?

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Rafia Sabih 2026-04-02 18:00:25 Re: Bypassing cursors in postgres_fdw to enable parallel plans
Previous Message Corey Huinker 2026-04-02 17:14:35 Re: Import Statistics in postgres_fdw before resorting to sampling.