search

openego / eGon-data

GNU Affero General Public License v3.0
10 stars 4 forks source link

psycopg2 looks for postgis-2.5 instead of postgis-3 #113

Open gplssm opened 3 years ago

gplssm commented 3 years ago

After a fresh install with https://github.com/openego/eGon-data/tree/features/%235-demandregio-integration, psycopg2 tries to find a postgis-2.5 file. Actually, it should use postgis-3 as specified in Dockerfile.postgis.

I wanted to test once at least, but I constantly run into the following error [2021-02-09 18:57:00,611] {taskinstance.py:1150} ERROR - (psycopg2.errors.UndefinedFile) could not access file "$libdir/postgis-2.5": No such file or directory which seems to be unrelated to this PR. For some reason, psycopg2 looks for postgis 2.5 instead of using version 3 which is specified in the docker-compose.yml.

Originally posted by @gplssm in https://github.com/openego/eGon-data/issues/100#issuecomment-776127717

gplssm commented 3 years ago

After trying to understand where it comes from, I decided to remove the container including its volume plus deleting the local path where the docker container volume data is stored

docker-compose down -v
sudo rm -r $HOME/docker/volumes/postgres/egon-data

If some finds this relevant to be included in the trouble shooting section :point_up: and I add it as fix to this issue. Otherwise, I'll simply close this issue.