# awx migration 19.2.0 to 19.2.1 or higher

**URL:** <https://forum.ansible.com/t/awx-migration-19-2-0-to-19-2-1-or-higher/35742>\
**Category:** AWX Project\
**Tags:** awx\
**Created:** [September 15, 2021, 4:08pm UTC](https://forum.ansible.com/t/awx-migration-19-2-0-to-19-2-1-or-higher/35742 "2021-09-15T16:08:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Nhan](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Michael\_Nhan](https://forum.ansible.com/u/Michael_Nhan)\
**Post date:** [September 15, 2021, 4:08pm UTC](https://forum.ansible.com/t/awx-migration-19-2-0-to-19-2-1-or-higher/35742/1 "2021-09-15T16:08:51Z")

</div>

All,

Trying to migrate/upgrade an awx 19.2.0 installation with an external postgresql database but having no luck. The awx-operator and awx pods install fine, but its stuck at the db migration indefinitely. Attempting to manually migrate the db with awx-manage migrate throws an error on main.0144\_event\_partition. Having contraint errors with main\_adhoccommandevent. I installed a new instance of 19.2.0 and compared the table in that db against the db being upgraded and they are identical. So stuck with the upgrade/migration. Is there any way to dump all the sql from main.0144\_event\_partition so it can be runned manually to see what the problem is?

---

<div class="post-metadata">

**Author:** ![Michael\_Nhan](https://avatars.discourse-cdn.com/v4/letter/m/58f4c7/32.png) [@Michael\_Nhan](https://forum.ansible.com/u/Michael_Nhan)\
**Post date:** [September 20, 2021, 9:08pm UTC](https://forum.ansible.com/t/awx-migration-19-2-0-to-19-2-1-or-higher/35742/2 "2021-09-20T21:08:35Z")

</div>

create a new install of 19.2.0 with a new postgresql instance. Set the instance to log all sql. migrated to 19.2.1. Took the sql from the logs for main\_0144\_event\_partition. backup my db, ran the sql and upgrade the required tables for main\_0144\_event\_partition. There were not errors running the sql commands manually, not sure what the issue was. use awx-operator to migrate the install to 19.2.1 and db migrated fine. Everything seem to work as usual. So there’s the fix if someone runs into the same issue… get the sql being run and run it manually to see what the error is and fix them. There were no errors from any of the sql runned in my db when ran manually.