【PgSQL extension】源码安装Pg，默认未安装postgres_fdw

$ psql -V
psql (PostgreSQL) 12.3

安装postgres_fdw

$ cd /usr/local/pgsql/contrib/
$ ls |grep postgres_fdw/
$ cd postgres_fdw/
$ ls
connection.c deparse.c expected option.c postgres_fdw--1.0.sql postgres_fdw.control postgres_fdw.o shippable.c sql
connection.o deparse.o Makefile option.o postgres_fdw.c postgres_fdw.h postgres_fdw.so shippable.o
$ make && make install

postgres=# \c zedb;
You are now connected to database "zedb" as user "postgres".
zedb=# create extension postgres_fdw ;
CREATE EXTENSION

赋予业务用户权限
zedb=# grant usage on FOREIGN DATA WRAPPER postgres_fdw to srv_resid;
GRANT
zedb=#
zedb=#