CREATE EXTENSION postgis_topology + yum install --downloadonly --downloaddir=/home/postgis postgis30_10

1.postgresql

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

2. yum search postgis  ； yum install -y postgis25_10(yum install -y postgis30_10)

 

3. 安装插件 - 重要：要在对应的租户库下面创建

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

 4. 用yum直接安装postgis插件，显示大量依赖包报错 ，尝试yum下载对应依赖包失败 

• 通过yum install --downloadonly --downloaddir=/home/postgis postgis30_10,将所有对应的依赖版本包对应下载到/home/postgis目录下
• 将该目录下所有文件拷贝到九江IDC数据库服务器上，在文件所在目录运行rpm -ivh *.rpm --force，提示安装成功