Create event trigger as non-superuser in Postgres
I was just looking into this topic, found this question, and another one with the answer. I figured I'd link back to the original answer, and the RDS docs.

The short answer is:


Yes you can, using the RDS master account.
You have to delete the event triggers before upgrading between major versions.


Details:

http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.EventTriggers