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

RDS does not provide the super permissions for the root user. That's because the super permissions allow you to execute management commands, such as reset master, set global, and reset slave. These operations can cause primary/standby replication errors.

If you need to perform operations that require super permissions, RDS provides alternative methods.

• Scenario 1: If you cannot run the following command on an RDS instance to modify parameter values, you can modify parameter values through the RDS 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 RDS 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)...

• Scenario 3: If you cannot create RDS for PostgreSQL extensions due to lack of super permissions, see Managing Extensions.