Why Does the Root User of My RDS for PostgreSQL Instance Not Have the SUPER Privileges?

For security, stability, and management purposes, RDS for PostgreSQL does not grant SUPER privileges to root. The SUPER privileges allow you to perform many critical operations, such as modifying system catalogs and executing system-level commands. These operations may severely impact the operational stability of DB instances and compromise data integrity.

If you need to perform operations that require the SUPER privileges, RDS provides alternative methods. For details about the privileges supported by root, see Privileges of the Root User.