PostGIS on WSL2 -扩展"postgis“没有安装脚本，也没有X.X.X版本的更新路径
PostGIS on WSL2 -扩展"postgis“没有安装脚本，也没有X.X.X版本的更新路径
提问于 2021-01-20 02:16:03
我正在尝试将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.controlPostgis.control的内容：
comment = 'PostGIS geometry and geography spatial types and functions'
default_version = '3.1.0'
module_pathname = '$libdir/postgis-3'
relocatable = false 回答 1
Stack Overflow用户
发布于 2022-08-22 07: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;
- 查询
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/65807449
复制相关文章
相似问题
使用Javascript数组创建HTML表？
数组javascript的HTML表
来自Javascript数组的Html表
Javascript数组到html表
html输入表中数组的Javascript数组
腾讯云开发者
