Re: [PATCH] add relation and block-level filtering to pg_waldump - Mailing list pgsql-hackers

From David Christensen
Subject Re: [PATCH] add relation and block-level filtering to pg_waldump
Date
Msg-id E0653476-25FB-42E3-9F41-47651AEB4323@crunchydata.com
Whole thread Raw
In response to Re: [PATCH] add relation and block-level filtering to pg_waldump  (Japin Li <japinli@hotmail.com>)
Responses Re: [PATCH] add relation and block-level filtering to pg_waldump  (Japin Li <japinli@hotmail.com>)
List pgsql-hackers
> 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?

The only sort of validity check we could do here is range checking for the underlying data types (which we certainly
could/shouldadd if it’s known to never be valid for the underlying types); non-existence of objects is a no-go, since
thatdepends purely on the WAL range you are looking at and you’d have to, you know, scan it to see if it existed before
markingas invalid. :) 

Thanks,

David




pgsql-hackers by date:

Previous
From: "osumi.takamichi@fujitsu.com"
Date:
Subject: RE: Optionally automatically disable logical replication subscriptions on error
Next
From: "osumi.takamichi@fujitsu.com"
Date:
Subject: RE: Optionally automatically disable logical replication subscriptions on error