CentOS7 yum 安装 PostgreSQL

yum install -y wget

wget https://download-ib01.fedoraproject.org/pub/epel/7/x86_64/Packages/l/libzstd-1.5.4-1.el7.x86_64.rpm
yum install -y libzstd-1.5.4-1.el7.x86_64.rpm

yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install -y postgresql11-server

postgresql-11-setup initdb

systemctl enable postgresql-11
systemctl start postgresql-11

su - postgres
psql -U postgres
ALTER USER postgres WITH PASSWORD '123456';

vi /var/lib/pgsql/11/data/postgresql.conf
listen_addresses = '*'

vi /var/lib/pgsql/11/data/pg_hba.conf
host all all 0.0.0.0/0 md5

systemctl restart postgresql-11

 

注：如果需要安装其他版本，只需把里面11的字样改为其他就可以，例如：13或15等