"EXCEPTION: psql failed: DETAIL: Key (post_id)=(36946) is duplicated."

Yes, I think it’s corrupt. Would love it if someone could tell me how to fix it :slight_smile:

Postgres is 13.6. I’m trying to move it to a new instance on a different server.

I tried rake search:reindex inside the docker container, and it fails with:

........rake aborted!
PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "posts_search_pkey"
DETAIL:  Key (post_id)=(86919) already exists.

Is it possible to just drop the offending record and re-index or something?

Any help appreciated!