create a runbook for interact with some use cases of data corruption

We need to have at least an initial guide on how to react in case of data corruption.

I would consider the following initial steps:

  • How to verify if we have more blocks corrupted in the database.
  • How to identify what is the database object that is corrupted.
  • Some initial troubleshooting in some cases.

In case of a secondary node:

  • drain the traffic and recreate a new node.

In the case of the primary:

  • Verify if it is an index:

    -If yes recreate CONCURRENTLY the index.

If it is a table verify what rows are affected.

Please contact support ( DBRE and Ongres As soon as Possible)

Edited by Jose Finotto