Centos7安装PostgresSQL
sudo yum update -y
sudo yum install -y https://download./pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
sudo yum install -y postgresql13-server postgresql13
sudo rpm -qi postgresql13-server
sudo /usr/pgsql-13/bin/postgresql-13-setup initdb sudo systemctl enable postgresql-13 sudo systemctl start postgresql-13 # 停止数据库 sudo systemctl stop postgresql-13
vim /var/lib/pgsql/13/data/postgresql.conf listen_addresses = '*'
vim /var/lib/pgsql/13/data/pg_hba.conf 主要就是在ip4下加 # IPv4 local connections: host all all 0.0.0.0/0 trust 修改postgres密码 su postgres psql alter user postgres with password 'postgres';
#登陆postgresql sudo -u postgres psql #修改i登陆postgresql密码 alter user postgres with password 'postgres';
firewall-cmd --zone=public --add-port=5432/tcp --permanent firewall-cmd --reload # 查看是否开放 firewall-cmd --query-port=5432/tcp 安装PostGIS
EPEL存储库中有许多依赖项,运行以下命令在CentOS 7计算机中安装epel存储库: sudo yum -y install epel-release
sudo yum -y install postgis31_13 |
|