'
Trying to rollback...
Rolling back...
Cleaning stuff up...
```
Any suggestions on how to proceed would be very welcome.
Thanks!
–dustin
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [27 mei 2020 om 20:42 UTC](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014/2 "2020-05-27T20:42:31Z")
Welcome Dustin. Sorry you’re having trouble.
You have a corrupt index. Have a look at [PostgreSQL 12 update - #238](https://meta.discourse.org/t/postgresql-12-update/151236/238).
---
### Author:  [@Dustin\_Lang](https://meta.discourse.org/u/Dustin_Lang)
#### Post date: [27 mei 2020 om 22:15 UTC](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014/3 "2020-05-27T22:15:07Z")
Thanks for your reply. In the end, instead of trying to create a new app and restore from backup, I returned to my original app and ran ‘./launcher rebuild app’ a few times (as root, which I wouldn’t have thought would be necessary, but I think I set up my site as root originally so that would make sense), and now my site is back! Yay!
Remind me never to idly touch the friendly-looking Upgrade button!
thanks,
–dustin
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [27 mei 2020 om 22:18 UTC](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014/4 "2020-05-27T22:18:40Z")
You still have the corrupt index. You still want it not to be corrupt.
---
### Author:  [@Dustin\_Lang](https://meta.discourse.org/u/Dustin_Lang)
#### Post date: [28 mei 2020 om 00:47 UTC](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014/5 "2020-05-28T00:47:57Z")
Wow, it would be _really_ nice if the upgrade process could remedy some of these issues!
So after installing the [data explorer](https://meta.discourse.org/t/32566?silent=true) plugin and poking around in the incoming\_referers index, and dropping other indices listed by the query here:
> [@Corrupt indexes in PG12, how do I fix?](https://meta.discourse.org/t/corrupt-indexes-in-pg12-how-do-i-fix/152570/35):
>
> If a concurrent REINDEX fails because the table has invalid data, you need to: Fix the invalid data, like it was done [here](https://meta.discourse.org/t/corrupt-indexes-in-pg12-how-do-i-fix/152570/5). List the invalid indexes using SELECT pg\_class.relname FROM pg\_class, pg\_index WHERE pg\_index.indisvalid = false AND pg\_index.indexrelid = pg\_class.oid; Drop each invalid index listed above using DROP INDEX \; Try the REINDEX again.
But I’m still getting:
```plaintext
discourse=# REINDEX SCHEMA CONCURRENTLY public;
WARNING: cannot reindex invalid index "pg_toast.pg_toast_19337_index_ccnew" concurrently, skipping
WARNING: cannot reindex invalid index "pg_toast.pg_toast_19337_index_ccnew1" concurrently, skipping
```
and those don’t want to be dropped!
```plaintext
# drop index pg_toast_19337_index_ccnew1;
ERROR: index "pg_toast_19337_index_ccnew1" does not exist
```
---
### Author:  [@Dustin\_Lang](https://meta.discourse.org/u/Dustin_Lang)
#### Post date: [28 mei 2020 om 01:02 UTC](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014/6 "2020-05-28T01:02:46Z")
> [@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
```
---
### Author:  [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [28 mei 2020 om 03:20 UTC](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014/7 "2020-05-28T03:20:50Z")
Yes, the corrupt indexes is something we’re looking closely at, apologies for the difficulty.. this in theory should not be possible.. but you know what they say about theory versus practice. It’s my hope that PG12 will be more resistant to.. whatever this is.
---
### Author:  [@Dustin\_Lang](https://meta.discourse.org/u/Dustin_Lang)
#### Post date: [28 mei 2020 om 03:23 UTC](https://meta.discourse.org/t/restoring-from-backup-failing-failure-creating-postgres-index/153014/8 "2020-05-28T03:23:45Z")
That’s good to hear. This is basically the first bump in the road I have experienced after years of set-it-and-forget-it enjoyment (like, I often forget which machine it’s even running on).
Thanks,
–dustin