Yes, I think it’s corrupt. Would love it if someone could tell me how to fix it ![]()
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!