Centos7安装postgresql

1、安装postgresql预制的环境
使用root账户

yum install gcc
yum install readline
yum install readline-devel
yum install zlib-devel
yum install zlib* library*

解压postgresql文件到 /home/datacenter
cd /home/datacenter
mkdir postgresql92
mv postgresql-9.2.24 postgresql

进入解压目录，进行安装
cd /home/datacenter/postgresql
./configure --prefix=/home/datacenter/postgresql92
make
make install
进入安装目录，创建Data目录
cd /home/datacenter/postgresql92
mkdir data
#把文件所有者授权给postgres
chown -R postgres:postgres /home/datacenter/postgresql
chown -R postgres:postgres /home/datacenter/postgresql92

配置环境变量 vim /etc/profile
export PGHOME=/home/datacenter/postgresql92
export PGDATA=/home/datacenter/postgresql92/data
export PATH=$PATH:${PGHOME}/bin
保存之后，执行source /etc/profile 让环境变量生效

更改防火墙让端口正常通信:
firewall-cmd --zone