Re: BUG #17212: pg_amcheck fails on checking temporary relations

Mark Dilger <mark.dilger@enterprisedb.com>

From: Mark Dilger <mark.dilger@enterprisedb.com>

To: Peter Geoghegan <pg@bowt.ie>

Cc: Robert Haas <robertmhaas@gmail.com>, Pavel Borisov <pashkin.elfe@gmail.com>, Alexander Lakhin <exclusion@gmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2021-10-11T20:20:26Z

Lists: pgsql-bugs, pgsql-hackers

Attachments

v3-0001-Fix-BUG-17212.patch (application/octet-stream) patch v3-0001
(unnamed) (text/plain)

> On Oct 11, 2021, at 12:25 PM, Mark Dilger <mark.dilger@enterprisedb.com> wrote:
> 
> Your proposal sounds good.  Let me try it and get back to you shortly.

Ok, I went with this suggestion, and also your earlier suggestion to have a <warning> in the pg_amcheck docs about using --parent-check and/or --rootdescend against servers in recovery.

Commits

Remove unstable pg_amcheck tests.
- cd3f429d9565 15.0 landed
- 5863115e4cb1 14.1 landed
pg_amcheck: avoid unhelpful verification attempts.
- d2bf06db3779 15.0 landed
- dd58194cf563 14.1 landed
amcheck: Skip unlogged relations in Hot Standby.
- 292698f158dd 15.0 landed
- e7712155ea08 14.1 landed
amcheck: Skip unlogged relations during recovery.
- 6754fe65a4c6 13.0 cited