docker-library/postgres

Need an image based on Trixie

fguiet opened this issue · 2 comments

fguiet commented

Hi,

Can you create this image based on Trixie ?

GEOS is too obsolete in the Bookworm repo

  • Bookworm comes with GEOS 3.11.1-1

https://packages.debian.org/source/bookworm/geos

  • Trixie comes with GEOS 3.13.0-1

https://packages.debian.org/source/trixie/geos

I need to use this function but it requires GEOS >=3.12.0
https://postgis.net/docs/ST_CoverageSimplify.html

Thank you

yosifkit commented

Debian Trixie is still unstable/testing, we only use stable releases of distributions. Once Trixie is released later this year, we will build the postgres images on it.

ImreSamu commented

@fguiet :

I need to use this function but it requires GEOS >=3.12.0
https://postgis.net/docs/ST_CoverageSimplify.html

( Side note for readers looking for a workaround )

You can use Alpine 3.21 version, which includes GEOS 3.13.0.

For example, you can use the postgres:17-alpine3.21 image, as seen in the ~official Postgis Dockerfile:

For more details, check the Alpine-based section in the README https://github.com/postgis/docker-postgis?tab=readme-ov-file#alpine-based

Log Output for postgis/postgis:17-3.5-alpine

PostgreSQL 17.2 on x86_64-pc-linux-musl, compiled by gcc (Alpine 14.2.0) 14.2.0, 64-bit

POSTGIS="3.5.2 0" [EXTENSION] PGSQL="170" GEOS="3.13.0-CAPI-1.19.0" 
   SFCGAL="SFCGAL 2.0.0, CGAL 5.6, BOOST 1.84.0" 
   PROJ="9.5.0 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/var/lib/postgresql/.local/share/proj DATABASE_PATH=/usr/share/proj/proj.db" (compiled against PROJ 9.5.0) 
   GDAL="GDAL 3.10.1, released 2025/01/08" LIBXML="2.13.4" 
   LIBJSON="0.18" LIBPROTOBUF="1.5.0" WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER
  • ❤️2