search

cyrilgdn / terraform-provider-postgresql

Terraform PostgreSQL provider
https://www.terraform.io/docs/providers/postgresql/
Mozilla Public License 2.0
359 stars 182 forks source link

fix postgresql_user_mapping on AWS RDS Aurora #274

Closed fabiopaiva closed 1 year ago

fabiopaiva commented 1 year ago

AWS RDS Aurora doesn't allow reading user_mappings from pg_catalog.pg_user_mappings but allows from information_schema._pg_user_mappings, which contains the same information. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Extensions.foreign-data-wrappers.html#postgresql-oracle-fdw.permissions

I also found another bug when the password contains = in it, so I changed the way it's mapping the options

fix #280