Unable to `CREATE EXTENSION postgres_fdw`

Hello! I'm trying the postgres_fdw feature on my free-trial cluster with my automatically created user. However, the feature requires superuser to create the extension first, so it failed. Is this expected or any suggestion for this?

CREATE EXTENSION postgres_fdw;
ERROR:  permission denied to create extension "postgres_fdw"
HINT:  Must be superuser to create this extension.

CREATE EXTENSION postgres_fdw;
ERROR:  permission denied to create extension "postgres_fdw"
HINT:  Must be superuser to create this extension.

2 Replies

multiple-amethyst•2y ago

Today, we're not enabling extensions that require network access which is why postgres_fdw is not currently available. We do plan to remove this restriction in future however I don't have an indicative date to share right now.

flat-fuchsiaOP•2y ago

Thanks for the information. And how can I get to know when it comes back in the future?

Gaming

Programming

Unable to `CREATE EXTENSION postgres_fdw`

Did you find this page helpful?