| From: | Tomas Vondra <tomas(at)vondra(dot)me> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| 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-03-29 13:33:10 |
| Message-ID: | c3a2b730-9d90-4a66-ae5e-50f6d77922d6@vondra.me |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 3/29/26 00:12, Tom Lane wrote:
> Tomas Vondra <tomas(at)vondra(dot)me> writes:
>> On 3/28/26 23:36, Tom Lane wrote:
>>> 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's running on ufs. But I think the explanation is very simple. We had
>> a short power outage on Thursday, and the FreeBSD machine failed to boot
>> properly after the power was restored. IIUC this test is new, right?
>
> Not that new, it dates to b15c15139, about a week ago.
>
> I've reproduced Thomas' failure on a local FreeBSD 15.0 image
> using zfs, and confirmed that this cowboy hack fixes it:
>
Interesting. Then I guess it has to be due to some difference in ufs vs.
zfs, when handling sparse files. It might be useful to add a bit more
variation here, and switch some of the animals to non-default
filesystems (not just the FreeBSD ones, which we seem to have only two
that run reasonably often). I'd bet most of the linux systems run on
ext4/xfs, few on btrfs/zfs.
regards
--
Tomas Vondra
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Jackson | 2026-03-29 13:55:54 | Re: Add ldapservice connection parameter |
| Previous Message | Andrew Dunstan | 2026-03-29 13:16:16 | Re: astreamer fixes |