Migration/ Install to External Database fails with: "migrations found.."

When installing or migrating to an external database it will fail with "migrations found: failed migrations in the target database, new migrations will not be applied" This is due to a not empty data

Issue Attempting to install or migrate an external database to a previously used or non-empty database Cause Due to the migrations required to execute to properly install Immuta, when the migrate procedure begins it will attempt to drop and recreate the database and assume it is empty. If it is not empty the migration will execute in a failed state and block migrations from completing leaving the database in a corrupted state. Resolution

• Drop the bometadata database entirely from the remote external database instance

• Drop the bometa role entirely from the remote external database instance

• Run line by line the pre-req steps in our docs and ensure each command ran is successful