我在postgresql和Docker中创建扩展postgis时遇到了问题。我读过许多帖子和教程,但失败了:)我正在编写WSL:
# uname -a
Linux 6019b3c71dfc 5.10.16.3-microsoft-standard-WSL2 #1 SMP Fri Apr 2 22:23:49 UTC 2021 x86_64 GNU/Linux
# psql -U user -d database -h db
psql (11.14 (Debian 11.14-0+deb10u1), server 10.18)
Type "help" for help.
massifs=# CREATE EXTENSION postgis;
ERROR: could not open extension control file "/usr/local/share/postgresql/extension/postgis.control": No such file or directory
因此,我找到了postgis.control文件:
# find /usr -name postgis.control
/usr/share/postgresql/11/extension/postgis.control
并在正确的文件夹中复制它(并在需要时更改权限):cp /usr/share/postgresql/11/extension/postgis.control /usr/local/share/postgresql/extension
但是错误是相同的:
我已经安装了所有所需的库:
# dpkg -l | grep postgis
ii postgis 2.5.1+dfsg-1 amd64 Geographic objects support for PostgreSQL
ii postgis-doc 2.5.1+dfsg-1 all Geographic objects support for PostgreSQL -- documentation
ii postgis-gui 2.5.1+dfsg-1 amd64 Geographic objects support for PostgreSQL -- GUI programs
ii postgresql-11-postgis-2.5 2.5.1+dfsg-1 amd64 Geographic objects support for PostgreSQL 11
ii postgresql-11-postgis-2.5-scripts 2.5.1+dfsg-1 all Geographic objects support for PostgreSQL 11 -- SQL scripts
相同错误:(
我的船坞-合成人。
#./dj/docker-compose.yml
version: '3.7'
services:
web:
env_file:
- ./env/django.env
build:
context: ./myproject
dockerfile: Dockerfile
command: python manage.py runserver 0.0.0.0:8000
volumes:
- ./myproject:/opt/myproject
ports:
- "8050:8000"
depends_on:
- db
restart: always
db:
env_file:
- ./env/postgresql.env
image: postgis/postgis
#image: postgres:10-alpine
container_name: postgres_container_myproject
hostname: db
volumes:
- /var/lib/postgresql/data-myproject:/var/lib/postgresql/data
ports:
- "5432:5432"
restart: always
pgadmin:
env_file:
- ./env/pgadmin.env
image: dpage/pgadmin4
container_name: pgadmin_container_myproject
ports:
- "8059:80"
volumes:
- /var/lib/pgadmin/data:/var/lib/pgadmin/data
links:
- "db:pgsql-server"
restart: always
logging:
driver: none
volumes:
pgadmin_data:
postgres_data:
driver: local
你有什么主意吗?
发布于 2022-01-19 17:42:04
我一直在使用船坞-邮递员,因为如果您想检查他们是如何做的,Dockerfile是个不错的地方
发布于 2022-01-19 17:31:49
请注意,您正在连接到错误的服务器或有一个错误版本的服务器。
psql (11.14 (Debian 11.14-0+deb10u1), server 10.18)
报告10 (10.18)的服务器版本,它肯定不是由包postgresql-11-postgis-2.5
(即11版本)安装的。
我假设您正在连接到没有安装正确包的另一个机器/容器(而不是localhost)。
https://stackoverflow.com/questions/70774725
复制相似问题