腾讯云

文章/答案/技术大牛

发布

社区首页 >问答首页 >PostGIS on WSL2 -扩展"postgis“没有安装脚本，也没有X.X.X版本的更新路径

问PostGIS on WSL2 -扩展"postgis“没有安装脚本，也没有X.X.X版本的更新路径
EN

Stack Overflow用户

提问于 2021-01-20 10:16:03

回答 1查看 3.2K关注 0票数 2

我正在尝试将PostGIS扩展添加到我的WSL2上的postgresql数据库中(使用Ubuntu20.04)，用于django项目。

我已经安装了postgresql、postgis和所有依赖项，如下所示：

sudo apt -y install postgresql-12 postgresql-client-12
sudo apt install postgis postgresql-12-postgis-3
sudo apt-get install postgresql-12-postgis-3-scripts

一切都很顺利。

在postgresql中，我已经创建了我的db并连接到它：

sudo -u postgres psql -p 5432 -h 127.0.0.1 

postgres=# CREATE DATABASE dbname;
postgres=# \c dbname;

但是，当我尝试将postGIS扩展添加到：

postgres=# CREATE EXTENSION postgis;

我得到以下错误：

错误:扩展"postgis“没有安装脚本，也没有版本"3.1.0"的更新路径

尽管在堆栈溢出问题上寻找类似的问题，但我无法为我的案例找到任何令人满意的解决方案。知道有什么不对吗?我怎么能解决呢？谢谢!

编辑:以下命令

ls $(pg_config --sharedir)/extension/postgis*

我得到以下文件列表：

/usr/share/postgresql/12/extension/postgis--2.0.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.0.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.0.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.0.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.0.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.0.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.0.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.0.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.1.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.1.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.1.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.1.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.1.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.1.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.1.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.1.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.1.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.1.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.2.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.2.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.2.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.2.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.2.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.2.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.2.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.2.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.2.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.10--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.11--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.3.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.4.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.4.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.4.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.4.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.4.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.4.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.4.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.4.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.4.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.4.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.5.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.5.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.5.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.5.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.5.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--2.5.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--3.0.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--3.0.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--3.0.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--3.0.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--3.1.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--3.1.0--3.1.0next.sql
/usr/share/postgresql/12/extension/postgis--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--3.1.0dev--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--3.1.0next--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--ANY--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--unpackaged--3.1.0.sql
/usr/share/postgresql/12/extension/postgis--unpackaged.sql
/usr/share/postgresql/12/extension/postgis.control
/usr/share/postgresql/12/extension/postgis_raster--2.0.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.0.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.0.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.0.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.0.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.0.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.0.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.0.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.1.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.1.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.1.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.1.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.1.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.1.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.1.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.1.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.1.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.1.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.2.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.2.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.2.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.2.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.2.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.2.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.2.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.2.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.2.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.10--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.11--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.3.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.4.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.4.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.4.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.4.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.4.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.4.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.4.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.4.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.4.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.4.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.5.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.5.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.5.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.5.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.5.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--2.5.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--3.0.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--3.0.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--3.0.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--3.0.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--3.1.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--3.1.0--3.1.0next.sql
/usr/share/postgresql/12/extension/postgis_raster--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--3.1.0dev--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--3.1.0next--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--ANY--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--unpackaged--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_raster--unpackaged.sql
/usr/share/postgresql/12/extension/postgis_raster.control
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.0.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.0.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.0.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.0.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.0.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.0.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.0.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.0.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.1.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.1.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.1.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.1.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.1.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.1.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.1.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.1.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.1.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.1.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.2.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.2.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.2.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.2.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.2.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.2.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.2.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.2.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.2.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.10--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.11--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.3.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.4.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.4.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.4.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.4.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.4.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.4.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.4.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.4.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.4.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.4.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.5.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.5.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.5.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.5.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.5.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--2.5.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--3.0.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--3.0.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--3.0.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--3.0.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--3.1.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--3.1.0--3.1.0next.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--3.1.0dev--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--3.1.0next--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--ANY--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder--unpackaged--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_tiger_geocoder.control
/usr/share/postgresql/12/extension/postgis_topology--2.0.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.0.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.0.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.0.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.0.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.0.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.0.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.0.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.1.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.1.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.1.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.1.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.1.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.1.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.1.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.1.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.1.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.1.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.2.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.2.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.2.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.2.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.2.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.2.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.2.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.2.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.2.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.10--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.11--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.3.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.4.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.4.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.4.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.4.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.4.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.4.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.4.6--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.4.7--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.4.8--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.4.9--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.5.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.5.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.5.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.5.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.5.4--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--2.5.5--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--3.0.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--3.0.1--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--3.0.2--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--3.0.3--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--3.1.0--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--3.1.0--3.1.0next.sql
/usr/share/postgresql/12/extension/postgis_topology--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--3.1.0dev--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--3.1.0next--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--ANY--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--unpackaged--3.1.0.sql
/usr/share/postgresql/12/extension/postgis_topology--unpackaged.sql
/usr/share/postgresql/12/extension/postgis_topology.control

Postgis.control的内容：

comment = 'PostGIS geometry and geography spatial types and functions'
default_version = '3.1.0'
module_pathname = '$libdir/postgis-3'
relocatable = false

postgresql

postgis

windows-subsystem-for-linux

django

回答 1

Stack Overflow用户

发布于 2022-08-22 15:43:17

把这个留给使用pgAdmin的人。

我试图通过右键单击PostGis -> CREATE安装->。

在对话框中，我没有选择"postgis“，只有"postgis-3”。我试过了，并得到了错误消息error extension postgis 3 has no installation script nor update path for version，它让我找到了这篇文章。

但是使用SQL工具而不是对话框是有效的！

右键单击您的数据库tool

CREATE EXTENSION postgis CASCADE;

查询

票数 1

页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持

原文链接：

https://stackoverflow.com/questions/65807449

复制

相似问题

问PostGIS on WSL2 -扩展"postgis“没有安装脚本，也没有X.X.X版本的更新路径
EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PostGIS on WSL2 -扩展"postgis“没有安装脚本，也没有X.X.X版本的更新路径EN

回答 1

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问PostGIS on WSL2 -扩展"postgis“没有安装脚本，也没有X.X.X版本的更新路径
EN