Include postgis_raster in postgis 3+ images

[submarcos]

As raster is separated in another extension since postgis 3+,
Is-it possible to add it as default in docker image ?

I use docker image for many project like https://github.com/GeotrekCE/Geotrek-admin but we are locked on 2.5 images

There is topology but no raster... I understand for other extension we should create a custom image with custom initdb db script, but for raster I think this is a problem

I can do the PR if you want. Thanks

[ImreSamu]

IMHO: no easy answer.

There is a completely opposite request to yours.

• Do not install extra extensions by default #187

And there is a "workaround":

• Raster broken #191 (comment) ( "simple example"; "hacker example:" )

[submarcos]

Thank you for your answer.

I see the thread and the workaround.

• The first line of your README says : "The postgis/postgis image provides tags for running Postgres with PostGIS extensions installed." This is not true anymore since 3.0+
• I don't understand why this is not already fixed, this is a big breaking change between postgis 2.5 and 3.0
• It is not normal to write a workaround to use a native postgis functionality in official postgis image, I understand for other extensions, but not for postgis extensions.
• topology and tiger are still enabled by default. why raster not ?

In the past I forked mdillon/postgis to fix postgis version. I was very happy to discover his work and the fix was merged in an official image, I just want to continue to use it.
I have lot of projects and opensource libraries to update to 3.0+

I will be happy to join your team to work on a best final solution to specify which extension enable or not, but for the moment I still think there is a big unfixed problem that block usage of your image for all raster projects.

[ImreSamu]

In the past I forked mdillon/postgis to fix postgis version.
...
topology and tiger are still enabled by default. why raster not ?

I am just a long time user and contributor;

As I know:

There was a relatively longer repository migration period ( mdillon/postgis -> docker-postgis/postgis ) when the survival of the project was at stake,

• Discussion: Move to docker-postgis/postgis on Docker Hub, new maintainers needed #143

And this period, unfortunately, coincided with the Postgis 3.0 breaking changes. ( ~ 2y ago )

• https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.0.0/NEWS ( 2019/10/20 )

And in Postgis 3.1 there was another breaking change(s)

• "Separated postgis_sfcgal from PostGIS into its own lib file and extension"
  • https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.1.0/NEWS ( 2020/12/18 ) ( ~ 1y ago )

There are other breaking changes: PostGIS CLI ;

• https://github.com/postgis/docker-postgis/tree/master/examples/image-with-postgis-clis

And there are a lot of user requests and hard to find the global optimum.

• Include ogr_fdw extension #209
• see other issues ...

I will be happy to join your team to work on a best final solution to specify which extension enable or not,

Please,
post your suggestions to the https://github.com/postgis/docker-postgis/discussions

I still think there is a big unfixed problem that block usage of your image for all raster projects.

I am neutral in this requests; I just wanted to help with the workarounds.
The final decision is in @phillipross hands.

I use docker image for many project like https://github.com/GeotrekCE/Geotrek-admin but we are locked on 2.5 images

we are extending the official Docker Postgres images ... so all tricks should work

• https://hub.docker.com/_/postgres see "Initialization scripts"

So just add an extra .sql "Initialization scripts"

CREATE EXTENSION IF NOT EXISTS pgcrypto;
CREATE EXTENSION IF NOT EXISTS postgis_raster;