neon icon indicating copy to clipboard operation
neon copied to clipboard

[Compute]: different SFCGAL versions in Dockerfile.compute-node (1.3.10) vs neon console (1.3.8)

Open ImreSamu opened this issue 6 months ago • 0 comments

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

ImreSamu avatar Jan 02 '24 18:01 ImreSamu