Roadmap for bookworm migration

[gbip]

Hi,

Are there any plan to migrate from bullseye to bookworm ? How can we help ?

I am interested in using GEOS 3.11 features (for example ST_SimplifyPolygonHull), which is the version of GEOS available on debian bookworm.

Debian bullseye only has GEOS 3.9.0-1.

Best regards,

[ImreSamu]

Are there any plan to migrate from bullseye to bookworm ?

I've been considering this for a while, but it's not that simple.

There are two expected issues with the new Debian version:
a.) libseccomp

• Docker image for Postgres 14 based on BookWarm is broken somehow docker-library/postgres#1100

b.) glibc + collation version mismatch

• Docker image for version 15.3 throws collation warnings docker-library/postgres#1099

Because of these issues, some people would prefer to stay with the bullseye version, but currently the postgis/docker-postgis repository only supports one Debian version.

The ideal solution would be to support both Debian versions, for example:

• postgis/postgis:15-3.3-bullseye
• postgis/postgis:15-3.3-bookworm

But this would require significant restructuring, and I won't be able to start working on it in the next two weeks due to other commitments.
But if it's urgent and someone makes a PR by then, I'd be happy to help with testing.
If someone starts working on it, please indicate so here in a comment.

[ImreSamu]

@gbip :

I wanted to let you know that I've started working on supporting multi-debian (bookworm, bullseye) and multi-alpine postgis images.

I hope to provide a minimal Pull Request soon for testing. However, I cannot commit to a specific deadline yet.

[RangaSamudrala]

Are there any plan to migrate from bullseye to bookworm ?

I've been considering this for a while, but it's not that simple.

There are two expected issues with the new Debian version: a.) libseccomp

• Docker image for Postgres 14 based on BookWarm is broken somehow docker-library/postgres#1100

b.) glibc + collation version mismatch

• Docker image for version 15.3 throws collation warnings docker-library/postgres#1099

Because of these issues, some people would prefer to stay with the bullseye version, but currently the postgis/docker-postgis repository only supports one Debian version.

The ideal solution would be to support both Debian versions, for example:

• postgis/postgis:15-3.3-bullseye
• postgis/postgis:15-3.3-bookworm

But this would require significant restructuring, and I won't be able to start working on it in the next two weeks due to other commitments. But if it's urgent and someone makes a PR by then, I'd be happy to help with testing. If someone starts working on it, please indicate so here in a comment.

Will there be effort to support Postgis v12 using Bookworm?

[ImreSamu]

@RangaSamudrala

Will there be effort to support Postgis v12 using Bookworm?

I'd definitely like to!

• 12-3.4-bookworm ✔️
  • https://registry.hub.docker.com/r/imresamu/postgis/tags?page=1&name=12-3.4-bookworm

Development environment ( not stable ) - but you can check the plan :

• https://hub.docker.com/r/imresamu/postgis
• code: https://github.com/ImreSamu/docker-postgis

PR: #356