3

In 2022-06-16 Postgres released version 14.4, which fixes possible corruption on indexes created with the concurrently option.

The release notes suggest using pg_amcheck to check if we have corrupt indexes.

However, when running pg_amcheck --heapallindexed my_database_name, I get

pg_amcheck: warning: skipping database "my_database_name": amcheck is not installed
pg_amcheck: error: no relations to check

How one is supposed to install pg_amcheck on Ubuntu 20.04 LTS?

I tried installing sudo apt install postgresql-contrib, because pg_amcheck was supposed to be included, but to no avail, the same error message persists.

I even ran CREATE EXTENSION amcheck; inside psql, but I'm still getting the same error message.

mustaccio
  • 28,207
  • 24
  • 60
  • 76
sandre89
  • 133
  • 1
  • 5

0 Answers0