[critical]: DBD::Pg::st execute failed

I’m migrating from a RHEL 6, PGSQL 9, RT 4.4.1 to RHEL 8.5, PGSQL 11, RT 5.0.2. I have done the basic install and can connect to the server by running /opt/rt/sbin/rt-server, and make a test ticket. I’m not sure of the order of operations from here.

I exported my database from the old server, and imported it into the new one. However, I do not see any of the old tickets - just the new, test ticket #1 that I created. I decided to try to upgrade the database. Attempting to go from 4.4.1 → 5.0.2 results in the following error:

[1858307] [Mon Apr 4 21:14:47 2022] [critical]: DBD::Pg::st execute failed: ERROR: column “uniquevalues” of relation “customfields” already exists at /home/nikolaidisp/rt-5.0.2/sbin/…/lib/RT/Handle.pm line 551. (/home/nikolaidisp/rt-5.0.2/sbin/…/lib/RT.pm:409)
DBD::Pg::st execute failed: ERROR: column “uniquevalues” of relation “customfields” already exists at /home/nikolaidisp/rt-5.0.2/sbin/…/lib/RT/Handle.pm line 551.
make: *** [Makefile:393: upgrade-database] Error 255

Attempting to skip 4.4.1 and start at 4.4.2 results in:
Processing 4.5.0
Now populating database schema.
[1858406] [Mon Apr 4 21:17:18 2022] [critical]: DBD::Pg::st execute failed: ERROR: column “hotlist” of relation “classes” does not exist at /home/nikolaidisp/rt-5.0.2/sbin/…/lib/RT/Handle.pm line 551. (/home/nikolaidisp/rt-5.0.2/sbin/…/lib/RT.pm:409)
DBD::Pg::st execute failed: ERROR: column “hotlist” of relation “classes” does not exist at /home/nikolaidisp/rt-5.0.2/sbin/…/lib/RT/Handle.pm line 551.
make: *** [Makefile:393: upgrade-database] Error 255

I’m not sure how to proceed or if I even have the order of operations (install PGSQL, restore from backup, upgrade database?) right.

Thanks,

Peter