Check Detail
Check whether the users in the target database are duplicates of the users in the source database in migration scenarios.
Remediation Method
In the scenario of full instance migration, if an account identical to that in the source instance exists in the target instance, it is necessary to delete the account with the same name in the target instance.
If the account in the target database is an initialized account, please use the initialized account to log in to the database and execute the following statements:
create user new user with password 'password';
grant pg_tencentdb_superuser to new username;
alter user new user with CREATEDB;
alter user new user with CREATEROLE;
If the account in the target database is a user addition, use the newly created user to log in to the database and delete the conflicting user.
drop user conflicting user;
alter table table name owner to new user;
Once the conflicting user deletion is completed, please re-run the verification task.