# שחזור נכשל, נתקע, פג תוקף על ALTER TABLE

**URL:** <https://meta.discourse.org/t/restore-fails-hangs-timeouts-on-alter-table/185309>\
**Category:** Product Support\
**Created:** [2 באפריל,‏ 2021,‏ 11:43pm UTC](https://meta.discourse.org/t/restore-fails-hangs-timeouts-on-alter-table/185309 "2021-04-02T23:43:10Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![deargle](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/deargle/32/120295_2.png) [@deargle](https://meta.discourse.org/u/deargle)\
**Post date:** [3 באפריל,‏ 2021,‏ 12:57am UTC](https://meta.discourse.org/t/restore-fails-hangs-timeouts-on-alter-table/185309/2 "2021-04-03T00:57:15Z")

</div>

I think I figured it out. I should have run `./discourse-setup` once on the new host to (1) get a swap file created, and (2) to get a sane `db_shared_buffers` set. One of those two being wrong, maybe both, was causing the consistent hang.

---

_[View the full topic](https://meta.discourse.org/t/restore-fails-hangs-timeouts-on-alter-table/185309)._
