uuid安装插件安装

yum -y install uuid uuid-devel

安装uuid包
tar -zxvf uuid-1.6.1.tar.gz
cd uuid-1.6.1
./configure
make
make install

./configure --prefix=/opt/pgsql963 --with-openssl --with-ossp-uuid --with-wal-blocksize=16 --with-blocksize=16 设定postgresql数据库管理系统安装位置

gmake world 编译源码
gmake install-world 安装源码

安装uuid插件
create extension "uuid-ossp";
安装postgres_fdw插件
CREATE EXTENSION postgres_fdw;

/usr/local/lib/libuuid.so.16.0.21
ln -s /usr/local/lib/libuuid.so.16.0.21 /usr/local/lib/libuuid.so.16

drop extension "uuid-ossp";
create extension "uuid-ossp";
select uuid_generate_v4();

巴特西