Using pg_activity with Amazon RDS

By | June 9, 2015

By default you aren’t able to use pg_activity to connect directly to your Amazon RDS instance.

This is due to two things:

  1. You don’t have superuser, ever, on Amazon RDS
  2. 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!

Leave a Reply

Your email address will not be published. Required fields are marked *