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