PostgreSQL 安装gis插件 CREATE EXTENSION postgis_topology

postgres-# ;
ERROR: could not open extension control file “/usr/pgsql-10/share/extension/postgis_topology.control”: No such file or directory
postgres=# CREATE EXTENSION postgis_topology
;
ERROR: could not open extension control file “/usr/pgsql-10/share/extension/postgis_topology.control”: No such file or directory

!

1 错误信息

postgres-# ;
ERROR:  could not open extension control file "/usr/pgsql-10/share/extension/postgis_topology.control": No such file or directory
postgres=# CREATE EXTENSION postgis_topology
;
ERROR:  could not open extension control file "/usr/pgsql-10/share/extension/postgis_topology.control": No such file or directory
1
2
3
4
5

2 yum安装

yum search postgis  ； yum install -y postgis25_10(yum install -y postgis30_10)
1

3 pgsql创建

postgres=# CREATE EXTENSION postgis_topology
;
ERROR:  required extension "postgis" is not installed
HINT:  Use CREATE EXTENSION ... CASCADE to install required extensions too.
postgres=# CREATE EXTENSION postgis         
;
CREATE EXTENSION
postgres=# CREATE EXTENSION postgis_topology
;
CREATE EXTENSION
1
2
3
4
5
6
7
8
9
10