Hello Team We are using postgres as the datastore for datahub. Recently we have started seeing below errors: On searching online we have found that we either need to reindex the pg_toast table or delete the corrupted rows. We tried reindexing the pg_toast but it did not help. Is there a way to restore postgres data from ES data. datahub version: v0.9.6.1 Error:

ERROR: missing chunk number 0 for toast value 734921 in pg_toast_83651

The RDBMS is considered the source of truth, we have ways to restore Elastic from SQL, but not the other way around. Elastic is a strict subset of the information in SQL so I don't think this makes sense to support either. It's highly recommended to use a managed service or otherwise be taking consistent backups of your data stores to prevent data loss in corruption scenarios. PostGres provides some instruction on detecting corruption in their wiki as well if you haven't already tried the approaches recommended there: https://wiki.postgresql.org/wiki/Corruption