Linux（centos7）如何安装postgresql+postgis

在CentOS 7上安装PostgreSQL和PostGIS的步骤如下：




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




sudo yum clean all




sudo yum install -y postgresql12-server postgresql12-contrib postgis24_12




sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
sudo systemctl enable postgresql-12
sudo systemctl start postgresql-12




psql -U postgres
postgres=# CREATE EXTENSION postgis;
postgres=# \q

以上步骤会安装PostgreSQL 12和PostGIS 2.4，请根据需要选择合适的PostgreSQL和PostGIS版本。