Re: pgsql: Add contrib/pg_walinspect. - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: pgsql: Add contrib/pg_walinspect.
Date
Msg-id Ymd/e5eeZMNAkrXo@paquier.xyz
Whole thread Raw
Responses Re: pgsql: Add contrib/pg_walinspect.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi Jeff,

On Fri, Apr 08, 2022 at 07:27:44AM +0000, Jeff Davis wrote:
> Add contrib/pg_walinspect.
>
> Provides similar functionality to pg_waldump, but from a SQL interface
> rather than a separate utility.

The tests of pg_walinspect look unstable:
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=topminnow&dt=2022-04-25%2001%3A48%3A47

 SELECT COUNT(*) >= 0 AS ok FROM
 pg_get_wal_records_info_till_end_of_wal(:'wal_lsn1');
- ok
-----
- t
-(1 row)
-
+ERROR:  could not read WAL at 0/1903E40

This points out at ReadNextXLogRecord(), though I would not blame this
test suite as you create a physical replication slot beforehand.
Could this be an issue related to the addition of the circular WAL
decoding buffer, aka 3f1ce97?

I am adding an open item about that.

Thanks,
--
Michael

Attachment

pgsql-hackers by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: BUG #17448: In Windows 10, version 1703 and later, huge_pages doesn't work.
Next
From: Michael Paquier
Date:
Subject: Re: CLUSTER on partitioned index