1、检查扩展
在postgresql的源码目录执行
./configure --prefix=/opt/postgresql/pginstalldir/ --with-uuid=e2fs
结果会有如下报错
处理方式:
在usr/local/src下安装:e2fsprogs-devel,libuuid-devel,uuid-devel
rpm -ivh e2fsprogs-devel-1.42.9-19.el7.x86_64.rpm
rpm -ivh libuuid-devel-2.23.2-65.el7.x86_64.rpm
rpm -ivh uuid-devel-1.6.2-26.el7.x86_64.rpm
如果联网,可以直接使用yum安装
yum -y install e2fsprogs-devel
yum -y install libuuid-devel
yum -y install uuid-devel
2、安装扩展
扩展安装之后还是在postgresql的源码文件夹执行
./configure --prefix=/opt/postgresql/pginstalldir/ --with-uuid=e2fs
无报错
执行编译(勿忘)
make
make install
切换到postgres,登录数据库,查看扩展
select * from pg_extension ;
查看可用扩展
select * from pg_available_extensions;
创建扩展uuid_ossp
create extension “uuid-ossp”;