tencent cloud

TencentDB for PostgreSQL

Account Conflict Check

Mode fokus
Ukuran font
Terakhir diperbarui: 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.

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan