postgis / docker-postgis

Docker image for PostGIS
https://hub.docker.com/r/postgis/postgis/
MIT License
1.4k stars 467 forks source link

update/refactor alpine3.18 postgis template #343

Closed ImreSamu closed 1 year ago

ImreSamu commented 1 year ago

update/refactor alpine3.18 template

Main changes:

Status:

ImreSamu commented 1 year ago

QA :

postgis/postgis:15-3.3-alpine build log

Alpine3.18 postgis configurations:

postgis/postgis:15-3.3-alpine config:

 PostGIS is now configured for x86_64-pc-linux-musl
-------------- Compiler Info ------------- 
 C compiler:           gcc -std=gnu99 -g -O2 -fno-math-errno -fno-signed-zeros -Wall -flto
 C++ compiler (Wagyu): gcc -std=c++11 -x c++ 
 C++ compiler (FlatGeobuf): gcc -std=c++11 -x c++ 
 CPPFLAGS:              -I/usr/include -I/usr/include/webp  -I/usr/include/libxml2 -I/usr/include -I/usr/include/json-c  -DNDEBUG 
 LDFLAGS:               -lm -flto
 SQL preprocessor:     /usr/bin/cpp -traditional-cpp -w -P
 Archiver:             gcc-ar rs
-------------- Additional Info ------------- 
 Interrupt Tests:   DISABLED use: --with-interrupt-tests to enable
-------------- Dependencies -------------- 
 GEOS config:          /usr/bin/geos-config
 GEOS version:         3.11.2
 GDAL config:          /usr/bin/gdal-config
 GDAL version:         3.6.4
 SFCGAL config:        /usr/bin/sfcgal-config
 SFCGAL version:       1.4.1
 PostgreSQL config:    /usr/local/bin/pg_config
 PostgreSQL version:   PostgreSQL 15.3
 PROJ4 version:        92
 Libxml2 config:       /usr/bin/xml2-config
 Libxml2 version:      2.11.3
 JSON-C support:       yes
 protobuf support:     yes
 protobuf-c version:   1004001
 PCRE support:         Version 2
 Perl:                 /usr/bin/perl
--------------- Extensions --------------- 
 PostGIS Raster:                     enabled
 PostGIS Topology:                   enabled
 SFCGAL support:                     enabled
 Address Standardizer support:       enabled
-------- Documentation Generation -------- 
 xsltproc:             /usr/bin/xsltproc
 xsl style sheets:     
 dblatex:              
 convert:              
 mathml2.dtd:          http://www.w3.org/Math/DTD/mathml2/mathml2.dtd

Postgres, Postgis version:

postgis/postgis:15-3.3-alpine

PostgreSQL 15.3 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit

POSTGIS="3.3.2 0" [EXTENSION] PGSQL="150" GEOS="3.11.2-CAPI-1.17.2" SFCGAL="SFCGAL 1.4.1, CGAL 5.5.2, 
   BOOST 1.82.0" PROJ="9.2.0" GDAL="GDAL 3.6.4, released 2023/04/17" 
   LIBXML="2.11.3" LIBJSON="0.16" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER2

Size changes

postgis/postgis:15-3.3-alpine 436MB -> 428MB :heavy_check_mark:

# version: 2023-05-13 ( this PR )
# alpine 3.18; PG 15.3; GEOS="3.11.2-CAPI-1.17.2", PROJ="9.2.0", GDAL="GDAL 3.6.4", SFCGAL="SFCGAL 1.4.1, CGAL 5.5.2; PCRE v2
# lto optimized
postgis/postgis   15-3.3-alpine   c0129c9bac1a  428MB  

# version: 2023-05-08 ( last monday )
# alpine 3.17; PG 15.2; GEOS="3.11.1-CAPI-1.17.1" PROJ="9.1.0" GDAL="GDAL 3.5.3", NO-SFCGAL; PCRE v1
postgis/postgis   15-3.3-alpine   e2fa330b9fd0  436MB
ImreSamu commented 1 year ago

Ready for review/merge