Sorry for bumping this once again, I got a very strange discourse=# REINDEX SCHEMA CONCURRENTLY public; ERROR: could not create unique index "index_tags_on_name_ccnew" DETAIL: Key (name)=(chronicillness) is duplicated. I’m assuming it can be fixed by the solution suggested above by @riking but I…

See: [图片] Peter Geoghegan (petervgeoghegan) @codinghorror @shog9 I work on the Postgres B-Tree code. Corruption simply should not happen with any regularity. E-mail me (address is pg@bowt.ie ), or send a report to one of the community lists. Always interested in hearing problem reports, e…

Corrupt indexes in PG12, how do I fix?

支持安装

sam (Sam Saffron) 2020 年5 月 25 日 03:16 11

Same fix you got to repeat the process.

1 个赞

Move a Discourse site to another VPS with rsync

话题		回复	浏览量
Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) Self-hosting	13	4719	2020 年2 月 5 日
Restoring from backup failing: failure creating postgres index Self-hosting	7	978	2020 年5 月 28 日
Restore fails - could not create unique index Self-hosting	22	3922	2020 年7 月 6 日
2.7.0.beta2 upgrade failed with ERROR: duplicate key Self-hosting	25	2232	2021 年2 月 25 日
PostgreSQL 13 update Announcements	3	11061	2025 年5 月 12 日

Corrupt indexes in PG12, how do I fix?

相关话题