postgres 创建 extension的时候报错,网上搜了好久终于找到了
postgres=# create extension file_fdw;
error: could not open extension control file "/usr/local/pgsql/share/extension/file_fdw.control": no such file or directory2.这个扩展默认没有按照,需要手动安装:
cd /usr/local/pgsql/contrib/file_fdw
make
make install
3.再次执行:create extension file_fdw;