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.
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.)