When we want to setup PMM PostgreSQL for RDS environments, the superuser role as mentioned in the PMM documentation does not exist. Instead, it is required to grant rds_superuser role.
This needs to be a documentation fix.
Also, please see if the following blog post of using Security Definer works for RDS as well. It should. Once tested, it can be documented.