Horton

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

Peter Geoghegan <pg@bowt.ie>

View thread View on postgr.es
From: Peter Geoghegan <pg@bowt.ie>
To: Alexander Lakhin <exclusion@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Cc: Mark Dilger <mark.dilger@enterprisedb.com>, Robert Haas <robertmhaas@gmail.com>
Date: 2021-10-02T17:32:57Z
Lists: pgsql-bugs, pgsql-hackers 
On Sat, Oct 2, 2021 at 4:49 AM PG Bug reporting form
<noreply@postgresql.org> wrote:
> Although you can add --exclude-relation=*.pg_temp*.*, this behaviour differs
> from the behaviour of pg_dump and friends, which skip such relations
> silently.

I agree -- this behavior is a bug.

Can you propose a fix, Mark?

-- 
Peter Geoghegan

Commits

  1. Remove unstable pg_amcheck tests.

  2. pg_amcheck: avoid unhelpful verification attempts.

  3. amcheck: Skip unlogged relations in Hot Standby.

  4. amcheck: Skip unlogged relations during recovery.