Implement a pipeline to check the logical status from structures in the database

To check the logical consistency of the structures if the database we should have a process using amcheck. (https://www.postgresql.org/docs/11/amcheck.html)

Basically we will need a pipeline executing:

  • Restore a backup.
  • Executing the amcheck on all the structures -- In case of errors generate alerts/issues.

We will need to scan the logs from the amcheck and in case of any errors generate an alert.

Edited by Jose Finotto