PostgreSQL10数据库源码安装及plpython2u、uuid-ossp插件安装

1、环境

centos 7 、 postgresql 10.19

2、安装包下载

postgres 源码安装包

3、安装

3.1 、解压

cd /tmp
tar -xzvf postgresql-10.19.tar.gz

3.2、配置

注：配置的时候一定要带上这两个选项，因为后面我要安装 uuid-ossp 、plpython2u插件
–with-python
–with-uuid=ossp \

./configure \
--prefix=/pg \
--exec-prefix=/pg \
--bindir=/pg/bin \
--sysconfdir=/pg/etc \
--libdir=/pg/lib \
--includedir=/pg/include --mandir=/pg/man --docdir=/pg/doc \
--htmldir=/pg/html \
--enable-nls='zh_CN en_US' \
--with-pgport=5432 \
--with-perl \
--with-python \
--with-tcl \
--with-icu \
--with-openssl \
--with-pam \
--with-ldap \
--with-systemd \
--with-readline \
--with-libxml \
--with-libxslt \
--with-segsize=1 \
--with-blocksize=8 \
--with-wal-segsize=16 \
--with-wal-blocksize=8 \
--with-uuid=ossp \
--without-zlib

配置的过程中，会提示缺少包，需要根据提示，手动安装这些包

yum install -y gcc
yum install -y libicu-devel.x86_64
yum install -y perl-ExtUtils-Embed.noarch
yum install -y readline-devel.x86_64
yum -y install openssl-devel
yum -y install pam-devel.x86_64
yum install -y libxml2-devel.x86_64
yum install -y libxslt.x86_64
yum install -y libxslt-devel.x86_64
yum install -y openldap-devel.x86_64
yum install -y systemd-devel.x86_64
yum install -y tcl-devel.x86_64
yum install -y python-devel.x86_64
yum install -y  uuid-devel