postgres_fdw extension not available on RDS/Postgres 14.4

Question

Hi everybody,

We are running a postgresql 14.4 with RDS. We want to use the **postgres_fdw** extension which is a supported and available extension according to the AWS documentation (https://docs.amazonaws.cn/en_us/AmazonRDS/latest/PostgreSQLReleaseNotes/postgresql-extensions.html#postgresql-extensions-14x).
 
But  `CREATE EXTENSION postgres_fdw` returns:

*SQL Error [42501]: ERROR: permission denied to create extension "postgres_fdw"
  Hint: This extension is not specified in "rds.allowed_extensions".*

What's going on ? How can we use that extension ?

best,

Accepted Answer

I think this document may help you.
[Using PostgreSQL extensions with Amazon RDS for PostgreSQL ](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Extensions.html)

Answer

Thanks a lot.

We finally figured out what's happened . For unknown reason, the dynamic parameter "allowed_extensions" of our parameter group for that instance was set to NULL  instead of '*'.

Once we changed this parameter, we were able to use the extension.

postgres_fdw extension not available on RDS/Postgres 14.4

Contenuto pertinente