yum install -y perl-ExtUtils-Embed readline-devel zlib-devel pam-devel libxml2-devel libxslt-devel openldap-devel      

yum install libicu-devel  python3-devel -y

useradd  postgresql
  mkdir -p /usr/local/postgresql/data
  chown -R postgresql:postgresql /usr/local/postgresql

 ./configure --prefix=/usr/local/postgresql --with-python --with-libxml --with-libxslt

make && make install       多核的可以 make -j32 && make install -j32

#拉到profile文件最下端，将下属内容追加到profile文件最后
export PATH=/usr/local/postgresql/bin:$PATH
export PGHOME=/usr/local/postgresql
export PGDATA=/usr/local/postgresql/data/
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$PGHOME/lib/
export PATH=$PGHOME/bin:$PATH:$HOME/bin

chown -R postgresql:postgresql /usr/local/postgresql

 su postgresql

./bin/initdb   或 /usr/local/postgresql/bin/initdb

chmod +x  /etc/init.d/postgresql

chkconfig --add postgresql

 vim postgresql.conf
 
#修改允许访问的ip地址
listen_addresses = '*'
#端口
port = 5432
#内存大小。可以使用默认值
max_wal_size = 1GB
min_wal_size = 80MB

#创建一个超级管理员用户
 CREATE USER superman SUPERUSER;
 
#创建一个有密码的用户
 CREATE USER user_pg WITH PASSWORD 'pgsql_DB';
 
#创建数据库
 CREATE DATABASE  test001 ;
 
 赋予超级权限
ALTER ROLE user_pg CREATEROLE CREATEDB;

ALTER ROLE user_pg CREATEROLE SUPERUSER;