I am investigating the possibility of using AWS IAM role based authentication with PGAdmin. The use case would be to give non technical team members read only access to our Postgresql databases of which we have quite a few. They will use the interface to run adhoc queries for QA and testing.