Postgres 12 + Postgis 3

[AbelVM]

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]

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 CartoDB/cartodb#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]

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]

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]

🔝

Thanks a lot!