# Unable to restore from a backup

**URL:** https://meta.discourse.org/t/unable-to-restore-from-a-backup/69093
**Category:** Self-hosting
**Created:** [August 30, 2017, 5:38pm UTC](https://meta.discourse.org/t/unable-to-restore-from-a-backup/69093 "2017-08-30T17:38:27Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![tbryan](https://avatars.discourse-cdn.com/v4/letter/t/f14d63/32.png) [@tbryan](https://meta.discourse.org/u/tbryan)
#### Post date: [August 30, 2017, 5:38pm UTC](https://meta.discourse.org/t/unable-to-restore-from-a-backup/69093/1 "2017-08-30T17:38:27Z")

</div>

Existing system: **v1.9.0.beta7 +131**  
New System: **v1.9.0.beta7 +155**

I’m unable to restore a fresh backup of the existing system to the new system, and get the following error in the restore log.

> [2017-08-30 01:03:25] EXCEPTION: ERROR: cannot drop function raise\_users\_email\_readonly() because other objects depend on it  
> DETAIL: trigger users\_email\_readonly on table backup.users depends on function raise\_users\_email\_readonly()  
> HINT: Use DROP … CASCADE to drop the dependent objects too.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [August 30, 2017, 8:36pm UTC](https://meta.discourse.org/t/unable-to-restore-from-a-backup/69093/2 "2017-08-30T20:36:52Z")

</div>

Is this related to the unsafe column drop we did on email column in the user table @sam?

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [August 30, 2017, 8:52pm UTC](https://meta.discourse.org/t/unable-to-restore-from-a-backup/69093/3 "2017-08-30T20:52:03Z")

</div>

@tgxworld recently committed a fix in this area, our column dropper had an edge case

Rebuild

---

<div class="post-metadata">

### Author: ![tbryan](https://avatars.discourse-cdn.com/v4/letter/t/f14d63/32.png) [@tbryan](https://meta.discourse.org/u/tbryan)
#### Post date: [August 30, 2017, 9:24pm UTC](https://meta.discourse.org/t/unable-to-restore-from-a-backup/69093/4 "2017-08-30T21:24:25Z")

</div>

After updating the new server to **v1.9.0.beta7 +171** the backup restored successfully.

---

<div class="post-metadata">

### Author: ![tgxworld](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tgxworld/32/106117_2.png) [@tgxworld](https://meta.discourse.org/u/tgxworld)
#### Post date: [August 30, 2017, 9:27pm UTC](https://meta.discourse.org/t/unable-to-restore-from-a-backup/69093/5 "2017-08-30T21:27:00Z")

</div>