安装UUID

确认系统安装了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)