Re: [PATCH] add relation and block-level filtering to pg_waldump

On Fri, 25 Feb 2022 at 03:02, David Christensen <david(dot)christensen(at)crunchydata(dot)com> wrote:
> Greetings,
>
> This patch adds the ability to specify a RelFileNode and optional BlockNum to limit output of
> pg_waldump records to only those which match the given criteria. This should be more performant
> than `pg_waldump | grep` as well as more reliable given specific variations in output style
> depending on how the blocks are specified.
>
> This currently affects only the main fork, but we could presumably add the option to filter by fork
> as well, if that is considered useful.
>

Cool. I think we can report an error instead of reading wal files,
if the tablespace, database, or relation is invalid. Does there any
WAL record that has invalid tablespace, database, or relation OID?

--
Regrads,
Japin Li.
ChengDu WenWu Information Technology Co.,Ltd.