Temporary permissions conflict with IAM authentication

[mythus]

I use terraform postgresql provider to create roles that have rds_iam role and assign these roles to separate postgres databases. After https://github.com/terraform-providers/terraform-provider-postgresql/pull/71 was merged the provider temporary assign rds_iam roles to the user managing the connection. This invalidates the consequent login attempts with username/password and the state apply fails with: Error: Error dropping database: pq: PAM authentication failed for user xxxxxx

Terraform v0.12.18

[benkeil]

Did you find a solution? Its basically not usable for ads aurora with IAM authentication.