Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Dev-diplodocus & GDAL support #60

Open
illpack opened this issue Dec 26, 2019 · 3 comments
Open

Dev-diplodocus & GDAL support #60

illpack opened this issue Dec 26, 2019 · 3 comments

Comments

@illpack
Copy link

illpack commented Dec 26, 2019

I ran into problems while trying to run my local ogr2ogr on the Docker's port - versioning problem.
Solution: include supported versions of GDAL in the Docker-compose definition:

version: "3"
services:
  postgis:
    image: geographica/postgis:dev_diplodocus
    ports:
      - "5433:5432"
    volumes:
      - ./db-data:/data
    environment:
      - POSTGRES_PASSWD=postgres
  gdal:
    image: geographica/gdal2:2.4.3
    volumes:
      - ./:/data
    command:
      - sleep
      - 999d

This will ensure compatibility (worked for me at least!) and then you'll be able to run ogr2ogr from the container, and point towards the postgis container on the localhost:

ogr2ogr -f 'PostgreSQL' PG:"host=postgis port=5432 dbname=dbname user=postgres password=XXXXXX" ${FILEPATH} -nln schema.component --config PG_USE_COPY YES -progress -nlt PROMOTE_TO_MULTI -lco PRECISION=NO

cheers mighty @ManuelLR for the fix

@ManuelLR
Copy link
Member

The problem is the same as: https://stackoverflow.com/questions/59190010/psycopg2-operationalerror-fatal-unsupported-frontend-protocol-1234-5679-serve

@illpack used locally gdal2 2.4.2 running over Mac

@ManuelLR
Copy link
Member

@illpack to better focus the error you could run locally the postgis container in the geographica/postgis:tasty_termite version and check if the error still exists.

@cayetanobv
Copy link
Member

Anyway, we are going (soon) to release a new version of dev_diplodocus using postgresql 12.1.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants