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等