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

asked Dec 15, 2021 at 20:58
2
  • Do you have a recent backup? 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. Commented Dec 20, 2021 at 13:52

0

Know someone who can answer? Share a link to this question via email, Twitter, or Facebook.

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.