centos7使用yum安装postgresql9.4

1

rpm -ivh https://download.postgresql.org/pub/repos/yum/9.4/redhat/rhel-7.6-x86_64/pgdg-centos94-9.4-3.noarch.rpm

1

yum install -y postgresql94-server postgresql94-contrib

1
2

# 
/usr/pgsql-9.4/bin/postgresql94-setup initdb

1
2
3

su – postgres
psql -U postgres
ALTER USER postgres with encrypted password '密码'

1
2
3
4
5
6

vim /var/lib/pgsql/9.4/data/postgresql.conf
listen_address = "*"

vim /var/lib/pgsql/9.4/data/pg_hba.conf
IPv4 local connections下方添加允许连接的IP
host     all     all     0.0.0.0/0     md5

1

systemctl restart postgresql-9.4.service