# PG12 中索引损坏，如何修复？

**URL:** https://meta.discourse.org/t/corrupt-indexes-in-pg12-how-do-i-fix/152570
**Category:** Self-hosting
**Created:** [2020 年5 月 25 日 02:45 UTC](https://meta.discourse.org/t/corrupt-indexes-in-pg12-how-do-i-fix/152570 "2020-05-25T02:45:43Z")
**Posts on this page:** 1
**Showing post:** 14

<div class="post-metadata">

### Author: ![itsbhanusharma](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/itsbhanusharma/32/180717_2.png) [@itsbhanusharma](https://meta.discourse.org/u/itsbhanusharma)
#### Post date: [2020 年5 月 25 日 03:31 UTC](https://meta.discourse.org/t/corrupt-indexes-in-pg12-how-do-i-fix/152570/14 "2020-05-25T03:31:27Z")

</div>

所以所有的复制索引现在都已清除，我在重新索引时只剩下这些警告：

```plaintext
discourse=# REINDEX SCHEMA CONCURRENTLY public;
WARNING: cannot reindex invalid index "public.tags_pkey_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_tags_on_name_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_tags_on_lower_name_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.tags_pkey_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_tags_on_name_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_tags_on_lower_name_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_309322_index_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_309322_index_ccnew1" concurrently, skipping
REINDEX

```

是否需要采取某些措施来消除这些警告，还是我们只能接受这些警告的存在？

---

_[View the full topic](https://meta.discourse.org/t/corrupt-indexes-in-pg12-how-do-i-fix/152570)._