By default you aren’t able to use pg_activity to connect directly to your Amazon RDS instance.
This is due to two things:
- You don’t have superuser, ever, on Amazon RDS
- pg_activity tries to get information on all databases, which includes the rdsadmin database that you will never have access to. This database is owned/managed by Amazon and is used for things like upgrades, maintenance, backups, etc…
The solution is just to ignore the check for superuser within pg_activity, and ignore the database named rdsadmin. Pretty straightforward, you can check out my feature branch here:
https://github.com/Geesu/pg_activity/tree/feature/amazon-rds
Enjoy!