Enabling postgres_fdw on a postgres 11 instance

1

Hi!

I wanted to use the postgres_fdw extension to connect DB A (hosted on render) to DB B (also hosted on render).

They were created at different times, so DB A is postgres 11, DB B is postgres 14.

The postgres 14 instance seems to have been pre-provisioned with the postgres_fdw extension. The postgres 11 instance wasn’t, though.

If I try to create the extension myself, it fails with:

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

…which is reasonable, I guess. :slight_smile:

Is it possible to get this extension created on my postgres 11 instance? (And if so, would it actually be useable, or would there be other things that prevent it from being usable – I’ve encountered some extensions in the past that render claims to support, but which aren’t actually usable in practice.)

2

Hi Colin,

Thanks for reaching out.

Unfortunately, the postgres_fdw extension isn’t available on Render Postgres 11/12 as noted in the docs: PostgreSQL Extensions

Kind regards

Alan

1 Like
3

Thanks!

4

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.