I fixed this by using a fresh install and externalizing the database to an RDS Postgres instance with this documentation.
Worth noting I ran into another issue where the retool docker containers could not connect to the RDS Postgres db.
"PostgreSQL 14.x and above major version use a newer JDBC driver which introduced the 'scram-sha-256' algorithm. This causes connections to fail due to a change made to the password authentication method used in the newer versions of PostgreSQL (scram-sha-256) whereby the client driver you are using only supports connecting via md5 passwords."
I had to add a parameter group to the RDS db instance to set rds.force_ssl = 0 and password_encryption = md5. I found that solution here