Databases & Storage

PostGIS returns to Amazon Linux 2023 with SFCGAL support

Key Takeaway

The PostgreSQL RPM repository has restored the PostGIS GIS stack for Amazon Linux 2023, now including SFCGAL support.

Summary

PostGIS is once again available for Amazon Linux 2023 via the PostgreSQL RPM repository. The update includes the SFCGAL library and supports PostgreSQL versions 14 through 18 on both x86_64 and aarch64 architectures. While some GDAL drivers are missing due to distribution limitations, core functionality remains intact.

Technical details of the PostGIS restoration

  • Supports PostgreSQL 14 to 18 on x86_64 and aarch64.
  • Includes SFCGAL 2.3.0, which requires new build-time packages CGAL 6.1.2 and nlohmann_json 3.12.0 for Amazon Linux 2023.
  • Uses rpath to link against specific versions (e.g., GDAL 3.13.3, GEOS 3.15.0, PROJ 9.8.1) without replacing the OS-provided libraries.
  • GDAL is built without certain drivers not provided by the distribution, such as netCDF, HDF5, xerces-c, and Arrow/Parquet.
  • Core drivers like GeoTIFF, GeoPackage, and SpatiaLite are fully supported.

Why it matters

This restores critical geospatial capabilities to users running PostgreSQL on Amazon Linux 2023, specifically adding advanced computational geometry support via SFCGAL.

Original reference: postgr.es →