I recently setup users on my RDS PostgreSQL DB to authenticate with their IAM User credentials using generated and short lived Tokens, along the lines of this article: Allow users to connect to RDS with IAM credentials. Everything works like a charm from the command line. However some users would like to access the DB with tools such as pgAdmin.
Is there a way to enable pgAdmin to generate these tokens when necessary?
As far as I am aware you cannot use PGAdmin to generate these tokens. That doesn't mean you cannot use pgadmin to connect to your database with IAM authentication.
You can upload the AWS database root certificate to PGAdmin local storage, and have your database users generate db tokens when they want to connect to the database.
These tokens can be copy pasted into pg-admin's password field when connecting to a server. (Note: The tokens will be far longer than regular passwords typically are)
