Migrate to a custom PostGIS docker

[nyurik]

It seems it would not be in our best interest to use the pre-built postgis docker because we need to control which sub-libraries are actually used by the postgis itself.

@ImreSamu suggested a generic build with parameters docker image, something like this:

docker build --pull \
  \
  --build-arg BASE_PG_IMAGE=postgres:9.6 \
  \
  --build-arg SFCGAL_VERSION=v1.3.9 \
  --build-arg SFCGAL_GIT_HASH=823db7a318b8841f8296e80036ef993ddf19ebf5 \
  --build-arg PROJ_VERSION=8.0.0 \
  --build-arg PROJ_GIT_HASH=12e7a4395784d2dfb45cc0b719d37cd7e534fe91 \
  --build-arg GEOS_VERSION=3.9.1 \
  --build-arg GEOS_GIT_HASH=1b2f4bd3e19001c37846687c765595aa8c28b90f \
  --build-arg GDAL_VERSION=v3.2.2 \
  --build-arg GDAL_GIT_HASH=a33784291d19015217ea2604988e53d448e14a07 \
  --build-arg POSTGIS_VERSION=3.1.1 \
  --build-arg POSTGIS_GIT_HASH=aaf4c79a4906f11727fe6b9bccb12051a52acfe3 \
  \
  -t postgis:pg9.6-pgis3.1.1-geos3.9.1-proj8.0.0-gdal3.2.2  .

This has NOT been implemented yet, but I think we should work with @ImreSamu and other docker-postgis developers, and just use it as part of our docker image process.

There is also a discussion on the related topic - we should probably resume it there.

[nickpeihl]

I wonder if could also consider using the CrunchyData PostGIS Docker image as a FROM build image since they may be more current than the postgis docker? But the CrunchyData base image is CentOS instead of Debian, so we'd need to use yum instead of apt to install the build dependencies. 🤷

From registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:centos8-13.3-3.1-4.6.3:

postgres=# SELECT postgis_full_version();
-[ RECORD 1 ]--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
postgis_full_version | POSTGIS="3.1.1 2e59a7c41" [EXTENSION] PGSQL="130" GEOS="3.9.1dev-CAPI-1.14.1" PROJ="7.2.1" LIBXML="2.9.7" LIBJSON="0.13.1" LIBPROTOBUF="1.3.0" WAGYU="0.5.0 (Internal)" TOPOLOGY