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…

Corrupt indexes in PG12, how do I fix?

תמיכה התקנה

sam (Sam Saffron) 25 במאי,‏ 2020,‏ 3:16am 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	5 בפברואר,‏ 2020
Restoring from backup failing: failure creating postgres index Self-hosting	7	978	28 במאי,‏ 2020
Restore fails - could not create unique index Self-hosting	22	3922	6 ביולי,‏ 2020
2.7.0.beta2 upgrade failed with ERROR: duplicate key Self-hosting	25	2232	25 בפברואר,‏ 2021
PostgreSQL 13 update Announcements	3	11061	12 במאי,‏ 2025

Corrupt indexes in PG12, how do I fix?

נושאים קשורים