CentOS7上為PostgreSQL11安裝PostGIS

yum -y install epel-release

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

# rpm -qi postgis30_11
Name        : postgis30_11
Version     : 3.0.2
Release     : 2.rhel7
Architecture: x86_64
Install Date: Thu 15 Oct 2020 09:09:30 AM CST
Group       : Unspecified
Size        : 34467716
License     : GPLv2+
Signature   : DSA/SHA1, Tue 29 Sep 2020 08:15:51 PM CST, Key ID 1f16d2e1442df0f8
Source RPM  : postgis30_11-3.0.2-2.rhel7.src.rpm
Build Date  : Tue 29 Sep 2020 08:15:47 PM CST
Build Host  : koji-centos7-x86-64-pgbuild
Relocations : (not relocatable)
Vendor      : PostgreSQL Global Development Group
URL         : http://www.postgis.net/
Summary     : Geographic Information Systems Extensions to PostgreSQL
Description :
PostGIS adds support for geographic objects to the PostgreSQL object-relational
database. In effect, PostGIS "spatially enables" the PostgreSQL server,
allowing it to be used as a backend spatial database for geographic information
systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS
follows the OpenGIS "Simple Features Specification for SQL" and has been
certified as compliant with the "Types and Functions" profile.

create extension postgis;