Why Does the Root User of My TaurusDB for PostgreSQL Instance Not Have the Super Permissions?

TaurusDB for PostgreSQL does not provide the super permissions for the root user. The super permissions allow you to execute management commands, such as reset master, set global, kill thread_ID, and reset slave. These operations may cause primary/standby replication errors.

If you need to perform operations that require super permissions, TaurusDB for PostgreSQL provides alternative methods.

• Scenario 1: If you cannot run the following command on a TaurusDB for PostgreSQL instance to modify parameter values, you can modify parameter values through the TaurusDB for PostgreSQL console.

  set global parameter name=Parameter value;

  If the script contains the set global command, delete the set global command and modify parameter values on the TaurusDB for PostgreSQL console.

• Scenario 2: An error is reported after you run the following command because the root user does not have the super permissions. To solve this problem, delete definer='root' from the command.

  create definer='root'@'%' trigger(procedure)...