# Restore fails - could not create unique index

**URL:** <https://meta.discourse.org/t/restore-fails-could-not-create-unique-index/151380>\
**Category:** Self-hosting\
**Created:** [13 mei 2020 om 20:29 UTC](https://meta.discourse.org/t/restore-fails-could-not-create-unique-index/151380 "2020-05-13T20:29:04Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Chandra](https://avatars.discourse-cdn.com/v4/letter/c/57b2e6/32.png) [@Chandra](https://meta.discourse.org/u/Chandra)\
**Post date:** [13 mei 2020 om 20:29 UTC](https://meta.discourse.org/t/restore-fails-could-not-create-unique-index/151380/1 "2020-05-13T20:29:04Z")

</div>

Hi, restore of backup fails with error:

```
CREATE INDEX
ERROR: could not create unique index "index_incoming_referers_on_path_and_incoming_domain_id"
DETAIL: Key (path, incoming_domain_id)=(/m/search, 25) is duplicated.
EXCEPTION: psql failed: DETAIL: Key (path, incoming_domain_id)=(/m/search, 25) is duplicated.

```

I found a similar topic but could not make out what needs to be done: [https://meta.discourse.org/t/getting-this-error-during-restore-could-not-create-unique-index/](https://meta.discourse.org/t/getting-this-error-during-restore-could-not-create-unique-index/)

Appreciate any step by step help for dummies to fix.

---

_[View the full topic](https://meta.discourse.org/t/restore-fails-could-not-create-unique-index/151380)._
