install postgresql

yum

https://www.postgresql.org/download/linux/redhat/
https://wiki.postgresql.org/wiki/YUM_Installation

# Install the repository RPM:
yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

# Install PostgreSQL:
yum install postgresql10-server

# Optionally initialize the database and enable automatic start:
/usr/pgsql-10/bin/postgresql-10-setup initdb
systemctl enable postgresql-10
systemctl start postgresql-10


###
  postgresql-setup initdb
  systemctl enable postgresql.service
  systemctl start postgresql.service



##开启远程
echo -e "listen_addresses = '*'\nmax_connections = 100">>    /var/lib/pgsql/12/data/postgresql.conf
echo 'host all all 0.0.0.0/24   md5'         >>  /var/lib/pgsql/12/data/pg_hba.conf

systemctl   restart  postgresql-12.service
su - postgres
psql 
alter user postgres with password '123456';  #修改密码

yum 安装需要的文件:

  libicu-50.2-4.el7_7.x86_64.rpm 
  postgresql12-12.3-1PGDG.rhel7.x86_64.rpm
  postgresql12-libs-12.3-1PGDG.rhel7.x86_64.rpm
  postgresql12-server-12.3-1PGDG.rhel7.x86_64.rpm

源码编译安装

安装postgresql

#安装基础安装包
yum install -y readline-devel zlib-devel make gcc


wget wget https://ftp.postgresql.org/pub/source/v12.0/postgresql-12.0.tar.gzpostgresql-12.0.tar.gz
https://ftp.postgresql.org/pub/source/v12.0/


#创建组和用户
groupadd postgres
useradd -g postgres -G postgres -d /home/postgresql postgres


#将安装包放在/opt 路径中并解压
tar xf /opt/postgresql-12.0.tar.gz -C /home/postgresql/postgresql-12.0



###编译
cd /home/postgresql/postgresql-12.0
./configure --prefix=/usr/share/postgresql-12
make && make install


#配置环境变量
echo 'export PGHOME=/usr/share/postgresql-12/
export PGDATA=/data/pgsql-12
export PATH=$PGHOME/bin:$PATH
export LANG=en_US.utf8
export LD_LIBRARY_PATH=$PGHOME/lib:$LD_LIBRARY_PATH'>>/etc/profile
source /etc/profile


#初始化数据
创建数据目录并授权

mkdir -p /data/pgsql-12
chown -R postgres:postgres /data/pgsql-12
chown -R postgres:postgres /usr/share/postgresql-12



#初始化
su - postgres
initdb -E utf8 -D $PGDATA


##切换到root下操作
#配置数据库

echo -e "listen_addresses = '*'\nmax_connections = 100">>/data/pgsql-12/postgresql.conf


echo 'host all all 0.0.0.0/24   md5'>>/data/pgsql-12/pg_hba.conf


echo -e "listen_addresses = '*'\nmax_connections = 100">>    /var/lib/pgsql/12/data/postgresql.conf
echo 'host all all 0.0.0.0/24   md5'         >>  /var/lib/pgsql/12/data/pg_hba.conf



##修改配置启动脚本
启动pg_ctl -D /data/pgsql-12/ -l logfile start
cp /home/postgresql/postgresql-12.0/contrib/start-scripts/linux /etc/init.d/postgresql-12
chmod 777 /etc/init.d/postgresql-12
sed -i '/prefix=/s#prefix=.*#prefix=/usr/share/postgresql-12#' /etc/init.d/postgresql-12
sed -i 's#PGDATA=.*#PGDATA=/data/pgsql-12#' /etc/init.d/postgresql-12




##启动检查
/etc/init.d/postgresql-12 start
ps -ef|grep post


su - postgres
psql 
alter user postgres with password '123456';  #修改密码

编译需要的依赖:

cpp-4.8.5-39.el7.x86_64.rpm
gcc-4.8.5-39.el7.x86_64.rpm
glibc-2.17-307.el7.1.i686.rpm
glibc-2.17-307.el7.1.x86_64.rpm
glibc-common-2.17-307.el7.1.x86_64.rpm
glibc-devel-2.17-307.el7.1.x86_64.rpm
glibc-headers-2.17-307.el7.1.x86_64.rpm
kernel-headers-3.10.0-1127.10.1.el7.x86_64.rpm
libgcc-4.8.5-39.el7.i686.rpm
libgcc-4.8.5-39.el7.x86_64.rpm
libgomp-4.8.5-39.el7.x86_64.rpm
libmpc-1.0.1-3.el7.x86_64.rpm
libstdc++-4.8.5-39.el7.i686.rpm
libstdc++-4.8.5-39.el7.x86_64.rpm
make-3.82-24.el7.x86_64.rpm
mpfr-3.1.1-4.el7.x86_64.rpm
ncurses-devel-5.9-14.20130511.el7_4.x86_64.rpm
ncurses-libs-5.9-14.20130511.el7_4.i686.rpm
nspr-4.21.0-1.el7.x86_64.rpm
nss-softokn-freebl-3.44.0-8.el7_7.i686.rpm
nss-softokn-freebl-3.44.0-8.el7_7.x86_64.rpm
nss-util-3.44.0-4.el7_7.x86_64.rpm
readline-6.2-11.el7.i686.rpm
readline-6.2-11.el7.x86_64.rpm
readline-devel-6.2-11.el7.i686.rpm
readline-devel-6.2-11.el7.x86_64.rpm
zlib-1.2.7-18.el7.i686.rpm
zlib-devel-1.2.7-18.el7.i686.rpm
zlib-devel-1.2.7-18.el7.x86_64.rpm

参考:https://www.cnblogs.com/wzstudy/p/11793814.html