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
,提示安装成功
用一个例子来演示会更加清晰