0

QGIS is unable to access one my DB.

Tracking the issue, I found that the broken relation was pg_attribute.

From there, I managed to identify the table causing the issue. select * from pg_attribute limit 593 --->> table foo

Trying to delete that table returns the same error ... invalid block in pg_attribute...

How can I drop that table/fix pg_attribute?

I don't need to restore it.

Thanks

2
  • Do you have a recent backup?
    – Vérace
    Commented Dec 15, 2021 at 21:24
  • No backup, It seems it has been broken for 100 day, which is longer than what we keep.
    – Boodoo
    Commented Dec 20, 2021 at 13:52

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.