确认系统安装了uuid和uuid-devel
[root@node2 ~]# rpm -qa |grep uuid
libuuid-devel-2.23.2-33.el7.x86_64
uuid-devel-1.6.2-26.el7.x86_64
uuid-1.6.2-26.el7.x86_64
libuuid-2.23.2-33.el7.x86_64
编译postgresql时加入
[root@node2 ~]# ./configure --prefix=/data/pg96 --with-uuid=ossp
安装插件
[root@node2 uuid-ossp]# make && make install
idaas=# create extension "uuid-ossp";
CREATE EXTENSION
验证
idaas=# SELECT uuid_generate_v3(uuid_ns_url(), 'http://www.postgresql.org');
uuid_generate_v3
--------------------------------------
cf16fe52-3365-3a1f-8572-288d8d2aaa46
(1 row)