To install ossp-uuid on postgres 10.7 on centos 7 from source
1. install missing lib
yum -y install e2fsprogs-devel uuid-devel libuuid-devel2. simple get into source folder(e.g. postgresql-19.7/contrib/uuid-ossp), then
make && make install3. Install in pgsql
CREATE EXTENSION IF NOT EXISTS "uuid-ossp";4. Test the function
select uuid_generate_v4();From: https://www.fengiling.com/blog/view/?id=612683
Comments