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,

주제

데이터베이스

태그

PostgreSQL VMware의 아마존 RDS

언어

English

jm favaro

질문됨 일 년 전487회 조회

2개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

수락된 답변

I think this document may help you. Using PostgreSQL extensions with Amazon RDS for PostgreSQL

tedtrent

답변함 일 년 전

rudileibbrandt_aws
일 년 전
Also review this: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html#PostgreSQL.Concepts.General.FeatureSupport.Extensions.Restriction

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.

jm favaro

답변함 일 년 전

postgres_fdw extension not available on RDS/Postgres 14.4

관련 콘텐츠