search

sverhoeven / docker-cartodb

Dockerized CartoDB
BSD 3-Clause "New" or "Revised" License
148 stars 116 forks source link

Postgres 12 + Postgis 3 #85

Open AbelVM opened 4 years ago

AbelVM commented 4 years ago

I have realised there's a branch with that stack and as of today CARTO is using those versions within.

How safe is to use that branch? Why is the master branch using old Postgres10?

sverhoeven commented 4 years ago

The https://github.com/sverhoeven/docker-cartodb/tree/py3pg12postgis3 branch is unable to create users, it dies due to non existing raster_overviews table. So it is not usable at the moment.

Carto has https://github.com/CartoDB/cartodb/pull/15479 open PR that will fix the raster_overviews error. Waiting for that PR to be merged.

The master branch is using most of the installation instructions of Carto themselves. They still point to Postgres10

AbelVM commented 4 years ago

Cool! I will watch that CARTO issue and wait. I was mistaken about the current prod versions used by CARTO.

On the other hand, the installation instructions say it requires PostgreSQL 10+ and as of today, AFAIK, CARTO is deployed with 11.x version and I am pretty sure it's pg12 compatible. The raster tables problems might be PostGIS 3.x to blame as vector and raster are managed by two different extensions now.

sverhoeven commented 4 years ago

The raster_overviews PR has been merged.

The branch now can be build an usable Carto instance. I have tested import, analysis and visualizations, but geocoding is broken at the moment.

The image of py3pg12postgis3 branch has been build and has been pushed to Docker Hub, it can be pulled with docker pull sverhoeven/cartodb:py3pg12postgis3.

AbelVM commented 4 years ago

:top:

Thanks a lot!