pg_restore and psql version are not the same on Rstudio and python environnement - Githubissues

InseeFrLab / images-datascience

Collection of Docker images to build the data science catalog of the Onyxia project

MIT License

24 stars 22 forks source link

pg_restore and psql version are not the same on Rstudio and python environnement #141

Closed JackLemaitre closed 11 months ago

JackLemaitre commented 1 year ago

R:
pg_restore --version
pg_restore (PostgreSQL) 14.9 (Ubuntu 14.9-0ubuntu0.22.04.1)
Python
pg_restore --version
pg_restore (PostgreSQL) 15.4

avouacr commented 11 months ago

Indeed. It is not the case in all our Python images, only in the ones based on the python-datascience image. The reason is that a Python package in our datascience environment has Postgresql as dependency, and the latest version packaged on Conda Forge (v16 now) is much newer than the one in apt's repositories (v14.9 now).

I guess we could add the PostgreSQL repository (https://computingforgeeks.com/install-and-configure-postgresql-on-ubuntu/) to our install-system-libs.sh script to download the latest version in all images. The versions won't be exactly matched this way, but it will already be much closer. @JackLemaitre interested in doing a PR for this ?