# Unable to restore/update discourse (PG::InvalidTextRepresentation: ERROR: invalid input syntax for type integer: "\[\]")

**URL:** <https://meta.discourse.org/t/unable-to-restore-update-discourse-pg-error-invalid-input-syntax-for-type-integer/229828>\
**Category:** Product Support\
**Created:** [June 13, 2022, 4:41pm UTC](https://meta.discourse.org/t/unable-to-restore-update-discourse-pg-error-invalid-input-syntax-for-type-integer/229828 "2022-06-13T16:41:19Z")\
**Posts on this page:** 1\
**Showing post:** 1

<div class="post-metadata">

**Author:** ![Spitap](https://avatars.discourse-cdn.com/v4/letter/s/ac8455/32.png) [@Spitap](https://meta.discourse.org/u/Spitap)\
**Post date:** [June 13, 2022, 4:41pm UTC](https://meta.discourse.org/t/unable-to-restore-update-discourse-pg-error-invalid-input-syntax-for-type-integer/229828/1 "2022-06-13T16:41:19Z")

</div>

Hi !

I have an instance currently running on 2.9.0.beta4, and I needed to migrate it, so I did the basic backup/restore, but restore failed on the new instance. I decided then to try to update the original instance, but it failed also. Both failed, seemingly for the same reason, during the db:migrate command.

Update error : [https://pastebin.com/raw/sQrnMe27](https://pastebin.com/raw/sQrnMe27)  
Restore error : [https://pastebin.com/raw/idWYmEFq](https://pastebin.com/raw/idWYmEFq)

Thanks for the help !

---

_[View the full topic](https://meta.discourse.org/t/unable-to-restore-update-discourse-pg-error-invalid-input-syntax-for-type-integer/229828)._