Connection to Postgresql hosted on AWS RDS using assume role and IAM

justwatchcom / sql_exporter

Flexible SQL Exporter for Prometheus.

MIT License

393 stars 107 forks source link

Connection to Postgresql hosted on AWS RDS using assume role and IAM #114

Open arthurzenika opened 7 months ago

arthurzenika commented 7 months ago

Looking at https://go.dev/wiki/SQLDrivers I don't see a reference to iam/passwordless based connexion to Postgresql hosted on RDS. Is this possible with sql_exporter ?

A quick search leads me to other projets such as https://github.com/labd/go-rds-iam and https://github.com/krotscheck/go-rds-driver ... do you think they would be "compatible" with sql_exporter ? (sorry not a golang developer)

dewey commented 7 months ago

Hey @arthurzenika, unfortunately I don't have any experience with that. It seems that it would be possible to implement it based on other discussions I found (https://github.com/califlower/golang-aws-rds-iam-postgres/issues/5), so it seems that it would definitely need some code changes.

For now I'd say it's not supported. If someone wants to take this up and implement it we would support it.

arthurzenika commented 6 months ago

Hi @dewey, hope you are well.

Here is a first attempt to contributing some rds+postgres+iam specific code. I am not a golang dev so I hope I didn't do anything wrong, feel free to correct or as me for corrections. (especially the vendor stuff which I am not used to)