postgres_fdw extension not available on RDS/Postgres 14.4

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,