# Restoring from backup failing: failure creating postgres index

**URL:** <https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014>\
**Category:** Self-hosting\
**Created:** [27 במאי,‏ 2020,‏ 7:59pm UTC](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014 "2020-05-27T19:59:18Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![Dustin\_Lang](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dustin_lang/32/182052_2.png) [@Dustin\_Lang](https://meta.discourse.org/u/Dustin_Lang)\
**Post date:** [28 במאי,‏ 2020,‏ 1:02am UTC](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014/6 "2020-05-28T01:02:46Z")

</div>

> [@Dustin\_Lang](#):
>
> `WARNING: cannot reindex invalid index "pg_toast`

Oh, need pg\_toast prefix:

```plaintext
discourse=# drop index pg_toast.pg_toast_19337_index_ccnew1;
DROP INDEX
discourse=# drop index pg_toast.pg_toast_19337_index_ccnew;
DROP INDEX
discourse=# REINDEX SCHEMA CONCURRENTLY public;
REINDEX

```

---

_[View the full topic](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014)._
