# 修复已损坏的索引PG16.3（无法从备份还原 - 无法创建唯一索引）

**URL:** <https://meta.discourse.org/t/fixing-a-corrupted-index-pg16-3-unable-to-restore-from-backup-could-not-create-unique-index/326261>\
**Category:** Product Support\
**Created:** [2024 年9 月 12 日 19:41 UTC](https://meta.discourse.org/t/fixing-a-corrupted-index-pg16-3-unable-to-restore-from-backup-could-not-create-unique-index/326261 "2024-09-12T19:41:34Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

作者： ![omarfilip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/omarfilip/32/208019_2.png) [@omarfilip](https://meta.discourse.org/u/omarfilip)\
发布日期： [2024 年9 月 14 日 00:26 UTC](https://meta.discourse.org/t/fixing-a-corrupted-index-pg16-3-unable-to-restore-from-backup-could-not-create-unique-index/326261/3 "2024-09-14T00:26:38Z")

</div>

我已经删除了重复项，但剩下这些我认为应该删除的额外索引。我可以删除这里列出的所有这些吗？

```plaintext
discourse=# REINDEX SCHEMA CONCURRENTLY public;
WARNING: cannot reindex invalid index "public.topic_links_pkey_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_extension_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_link_post_id_and_reflection_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_post_id_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_topic_id_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_id_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_and_clicks_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.unique_post_links_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "public.topic_links_pkey_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_extension_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_link_post_id_and_reflection_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_post_id_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_topic_id_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_id_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_and_clicks_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.unique_post_links_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "public.topic_links_pkey_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_extension_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_link_post_id_and_reflection_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_post_id_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_topic_id_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_id_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_and_clicks_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "public.unique_post_links_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "public.topic_links_pkey_ccnew3" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_extension_ccnew3" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_link_post_id_and_reflection_ccnew3" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_post_id_ccnew3" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_topic_id_ccnew3" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_id_ccnew3" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_and_clicks_ccnew3" concurrently, skipping
WARNING: cannot reindex invalid index "public.unique_post_links_ccnew3" concurrently, skipping
WARNING: cannot reindex invalid index "public.topic_links_pkey_ccnew4" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_extension_ccnew4" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_link_post_id_and_reflection_ccnew4" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_post_id_ccnew4" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_topic_id_ccnew4" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_id_ccnew4" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_and_clicks_ccnew4" concurrently, skipping
WARNING: cannot reindex invalid index "public.unique_post_links_ccnew4" concurrently, skipping
WARNING: cannot reindex invalid index "public.topic_links_pkey_ccnew5" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_extension_ccnew5" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_link_post_id_and_reflection_ccnew5" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_post_id_ccnew5" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_topic_id_ccnew5" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_id_ccnew5" concurrently, skipping
WARNING: cannot reindex invalid index "public.index_topic_links_on_user_and_clicks_ccnew5" concurrently, skipping
WARNING: cannot reindex invalid index "public.unique_post_links_ccnew5" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_102223_index_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_102223_index_ccnew1" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_102223_index_ccnew2" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_102223_index_ccnew3" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_102223_index_ccnew4" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_102223_index_ccnew5" concurrently, skipping
REINDEX
discourse=#

```

---

_[View the full topic](https://meta.discourse.org/t/fixing-a-corrupted-index-pg16-3-unable-to-restore-from-backup-could-not-create-unique-index/326261)._