Check Details
Check whether the target database user conflicts with the source database user in a data migration scenario.
Troubleshooting
In full database migration, if the target database has the same account as that in the source database, you need to delete it.
If the account in the target database is the initial account, use it to log in to the database and run 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 new user, use it to log in to the database and delete the conflicting user.
DROP USER conflicting user;
ALTER TABLE table name OWNER TO new user;
After the conflicting user is deleted, run the verification task again.
Was this page helpful?