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: [imagen] 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 report…

Corrupt indexes in PG12, how do I fix?

Soporte Instalación

sam (Sam Saffron) 25 Mayo, 2020 03:16 11

Same fix you got to repeat the process.

1 me gusta

Move a Discourse site to another VPS with rsync

Tema		Respuestas	Vistas
Can't restore due to corrupt indexes (with some clues on how to deal with corrupt indexes) Self-hosting	13	4713	5 Febrero 2020
Restoring from backup failing: failure creating postgres index Self-hosting	7	975	28 Mayo 2020
Restore fails - could not create unique index Self-hosting	22	3918	6 Julio 2020
2.7.0.beta2 upgrade failed with ERROR: duplicate key Self-hosting	25	2228	25 Febrero 2021
PostgreSQL 13 update Announcements	3	11056	12 Mayo 2025

Corrupt indexes in PG12, how do I fix?

Temas relacionados