postgres_fdw.control: No such file or directory
执行
CREATE EXTENSION postgres_fdw;
的时候报错
ERROR: could not open extension control file
“/usr/local/postgresql/share/extension/postgres_fdw.control”: No such
file or directory Error position:
原因:未安装对应的postgres安装扩展
解决方法:安装对应扩展即可(本人使用源码安装)
cd /usr/local/postgresql/postgresql-14.6/contrib
进入postgres安装包的contrib目录cd postgres_fdw/
进入自己需要的扩展包make
编译make install
安装