How to Enable UUID Generation in AWS RDS for PostgreSQL
Troubleshoot and enable UUID generation using the uuid-ossp extension in Amazon RDS for PostgreSQL, even when it appears available but uninstalled.
RDS Guides
Resolving "Access Denied" Errors When Importing SQL Files to Amazon RDS
How to fix "access denied" due to SUPER privilege errors when importing SQL files to RDS