neon
neon copied to clipboard
[Compute]: different SFCGAL versions in Dockerfile.compute-node (1.3.10) vs neon console (1.3.8)
Probably this is not a critical issue, but it seems that the version of sfcgal used during the building and running of postgis_sfcgal might differ.
Steps to reproduce
in the neon console - checking SFCGAL version = "1.3.8"
CREATE EXTENSION IF NOT EXISTS postgis;
CREATE EXTENSION IF NOT EXISTS postgis_sfcgal;
SELECT version(), PostGIS_Full_Version();
output: SFCGAL="1.3.8"
# version postgis_full_version
1 PostgreSQL 15.5 on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit
POSTGIS="3.3.3 2355e8e" [EXTENSION] PGSQL="150" GEOS="3.9.0-CAPI-1.16.2" SFCGAL="1.3.8" PROJ="7.2.1" LIBXML="2.9.10" LIBJSON="0.15" LIBPROTOBUF="1.3.3" WAGYU="0.5.0 (Internal)"
In the Dockerfile.compute-node : SFCGAL-v1.3.10
-
RUN wget https://gitlab.com/Oslandia/SFCGAL/-/archive/v1.3.10/SFCGAL-v1.3.10.tar.gz
- https://github.com/neondatabase/neon/blob/aa9f1d4b697eefb48e4ebff4aebb4881d2bb29c4/Dockerfile.compute-node#L90
Expected result
same version.
Actual result
different version
- Dockerfile.compute-node (1.3.10) vs neon console (1.3.8)
My theory:
in the Dockerfile.compute-node - in the final part - the system libsfcgal1
has been installed.
https://github.com/neondatabase/neon/blob/aa9f1d4b697eefb48e4ebff4aebb4881d2bb29c4/Dockerfile.compute-node#L921