tencent cloud

TencentDB for PostgreSQL

Account Conflict Check

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2025-04-30 18:01:00

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;
# If the conflicting user has resource dependencies, please first modify the owner of the dependent object. For example, the modification statement for the owner of a table is:
alter table table name owner to new user;
Once the conflicting user deletion is completed, please re-run the verification task.

Ajuda e Suporte

Esta página foi útil?

comentários