Corrupt indexes in PG12, how do I fix?

Installation
2

See:

So you have 2 things you can do if you see this error:

  1. You can work around the issue … in this case the table tags has a duplicate row with the name chronicillness

    1. Do a data explorer query searching for the rows select * from tags where name = 'chronicillness

    2. Delete the duplicate:

      ./launcher enter app
rails c
Tag.find_by(id: ID_YOU_FOUND_IN_DATA_EXPLORER).destroy

  2. If you have a backup of your database and details you would like to share with Peter… share with Peter either privately or on the PG mailing list.

8 Likes