Log message:
databases/postgresql-postgis2: Update to 3.3.0

packaging changes:
  - require pgsql >= 11, per upstream
  - enable address standardizer module

PostGIS 3.3.0
2022/08/26

This version requires PostgreSQL 11 or higher, GEOS 3.6 or higher, and Proj 5.2+.
Additional features are enabled if you are running GEOS 3.9+
ST_MakeValid enhancements with 3.10+, ST_ConcaveHull and several other \ 
enhancements with GEOS 3.11+.
Requires SFCGAL 1.4.1+ for ST_AlphaShape and ST_OptimalAlphaShape.

The new --enable-lto flag improves math computations.  This new feature is \ 
disabled by default
because on some platforms, causes compilation errors (BSD and MingW64 issues \ 
have been raised)

Use below to enable it.

 ./configure --enable-lto flag

 * New features *
  - #5116, Topology export/import scripts (Sandro Santilli)
  - ST_Letters creates geometries that look like letters (Paul Ramsey)
  - #5037, postgis_sfcgal: ST_3DConvexHull (Loïc Bartoletti)
  - postgis_sfcgal: sfcgal_full_version - reports BOOST and CGAL version
    (Loïc Bartoletti)
  - GH659, MARC21/XML, ST_GeomFromMARC21, ST_AsMARC21 (Jim Jones)
  - #5132, GH683, sfcgal: ST_3DUnion aggregate function (Sergei Shoulbakov)
  - #5143, SFCGAL ST_AlphaShape and ST_OptimalAlphaShape
           Requires SFCGAL 1.4.1+ (Loïc Bartoletti)
  - #5162, ST_TriangulatePolygon with GEOS 3.11+ (Paul Ramsey, Martin Davis)
  - #5162, ST_SimplifyPolygonHull with GEOS 3.11+ (Paul Ramsey, Martin Davis)
  - #5183, topology.RemoveUnusedPrimitives (Sandro Santilli)

 * Breaking changes *
  - Drop support for PostgreSQL 9.6 and 10 (Regina Obe)
  - Change output for WKT MULTIPOINT. All points now
    wrapped in parens. (Even Roualt)
  - GH674, geometry validation and fixing is disabled
    for ST_DumpAsPolygons and ST_Polygon so it works faster
    but might produce invalid polygons. (Aliaksandr Kalenik)

 * Enhancements *
  - #2861, Add index on topology.node(containing_face) speeding up
    splitting and merging of faces (Sandro Santilli)
  - #2083, Speed up ST_RemEdge topology functions adding index on
    relation(element_id) and edge_data(abs_next*) (Sandro Santilli)
  - #5118, Allow dropping topologies with missing topogeometry sequences
    (Sandro Santilli)
  - #5111, faster topology face MBR computation (Sandro Santilli)
  - postgis_extensions_upgrade() support for upgrades from any PostGIS
    version, including yet to be released ones (Sandro Santilli)
  - #5040, add postgis_sfcgal_full_version (Loïc Bartoletti)
  - GH655, GiST: balance the tree splits better in recursive calls (Darafei \ 
Praliaskouski)
  - GH657, GiST: do not call no-op decompress function (Aliaksandr Kalenik)
  - #4939, #5161, ST_LineMerge now has option to keep the directions of input \ 
linestrings,
    useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
  - ST_ConcaveHull GEOS 3.11+ native implementation (Paul Ramsey, Martin Davis)
  - ST_ConcaveHull GEOS 3.11+ polygon-respecting native implementation (Paul \ 
Ramsey, Martin Davis)
  - #4574, GH678, #5121 Enable Link-Time Optimizations using --enable-lto \ 
(Sergei Shoulbakov)
  - GH676, faster ST_Clip (Aliaksandr Kalenik)
  - #5135, Fast GiST index build is enabled by default for PostgreSQL 15+ \ 
(Sergei Shoulbakov)
  - #4939, #5161, ST_LineMerge now has option to keep the directions of input \ 
linestrings,
    useful when processing road graphs. Requires GEOS 3.11. (Sergei Shoulbakov)
  - #5158, pgtopo_import / pgtopo_export manpages (Sandro Santilli)
  - #5170, add a optional max_rows_per_copy to -Y option to raster2pgsql to
    control number of rows per copy statement.
    Default to 50 when not specified (Regina Obe)
  - GH698, support parallel aggregate for ST_Union (Sergei Shoulbakov)
  - #5024, Update spatial_ref_sys as part of ALTER EXTENSION update postgis \ 
(Paul Ramsey)

 * Bug Fixe *

Log message:
*: recursive bump for perl 5.36

Log message:
revbump for gdal-lib update

Log message:
*: remove some references to postgresql 9.6

Log message:
revbump for textproc/icu update

Log message:
revbump for devel/protobuf

Log message:
databases/postgresql-postgis2: Update to 3.2.1

upstream changes: bugfixes

Log message:
*: revbump for gdal-lib update

Log message:
postgresql-postgis2: Add 14 as acceptable pgsql version

pkgsrc changes:
---------------
  * Add 14 to PGSQL_VERSION_ACCEPTABLE to fix a dependency failure of
    geography/mapserver with PostgreSQL 14.
  * Fix BUILDLINK_ABI_DEPENDS that contained a hardcoded dependency.
  * Bump revision.

Log message:
postgresql-postgis2: Update to 3.2.0

See NEWS in sources for details.  A summary of upstream NEWS:

* Enhancements and bugfixes

PostGIS 3.2.0 (Olivier Courtin Edition)
2021/12/17
This version requires PostgreSQL 9.6 or higher, GEOS 3.6 or higher
, and Proj 4.9+.
Additional features are enabled if you are running GEOS 3.9+
(and ST_MakeValid enhancements with 3.10+),
Proj 6.1+, and PostgreSQL 14+.
Due to some query performance degradation
with the new fast index build that requires PG14,
we have decided to disable the feature by default
until we get more user testing
as to the true impact of real-world queries.
If you are running PG14+, you can reenable it by doing

ALTER OPERATOR FAMILY gist_geometry_ops_2d USING gist
     ADD FUNCTION 11 (geometry)
     geometry_gist_sortsupport_2d (internal);
and then reindex your gist indexes.

To revert back to the old index behavior:
   ALTER OPERATOR FAMILY gist_geometry_ops_2d using gist
     DROP FUNCTION 11 (geometry);

and then reindex your gist indexes.

 * Breaking changes *
  - #5008, Empty geometries are not reported as being within Infinite
           distance by ST_DWithin (Sandro Santilli)
  - #4824, Removed `--without-wagyu` build option. Using Wagyu is now mandatory \ 
to build with MVT support.
  - #4933, topology.GetFaceByPoint will not work with topologies having invalid \ 
edge linking.
  - #4981, ST_StartPoint support any geometry. No longer returns null for \ 
non-linestrings.
  - #4149, ST_AsMVTGeom now preserves more of original geometry's details at \ 
scale close to target extent.
           If you need previous simplifying behaviour, you can ST_Simplify the \ 
geometry in advance.
           (Darafei Praliaskouski)
  - Proj 4.9 or higher is required
  - #5000, Turn off Window support in ST_AsMVT aggregate
        as no real use-case for it and it crashes with random input
        (Paul Ramsey)

 * New features*
  - #4923, topology.ValidateTopologyRelation (Sandro Santilli)
  - #4933, topology.GetFaceContainingPoint (Sandro Santilli)
  - #2175, ST_Scroll (Sandro Santilli)
  - #4841, FindTopology to quickly get a topology record (Sandro Santilli)
  - #4869, FindLayer to quickly get a layer record (Sandro Santilli)
  - #4851, TopoGeom_addTopoGeom function (Sandro Santilli)
  - ST_MakeValid(geometry, options) allows alternative validity building
    algorithms with GEOS 3.10 (Paul Ramsey)
  - ST_InterpolateRaster() fills in raster cells between sample points
    using one of a number of algorithms (inverse weighted distance, average, etc)
    using algorithms from GDAL
    (Paul Ramsey)
  - ST_Contour() generates contour lines from raster values
    using algorithms from GDAL (Paul Ramsey)
  - ST_SetZ()/ST_SetM() fills in z/m coordinates of a geometry using data read
    from a raster (Paul Ramsey)
  - New postgis.gdal_vsi_options GUC allows out-db rasters on VSI network
    services to be accessed with authentication keys, etc. (Paul Ramsey)
  - ST_DumpSegments returns a set of segments of input geometry (Aliaksandr Kalenik)
  - #4859, ST_Point, ST_PointZ, ST_PointM, ST_PointZM, constructors
    with SRID parameter (Paul Ramsey)
  - #4808, ST_ClusterKMeans now supports max_radius argument. Use it when you're \ 
not sure what is
    the number of clusters but you know what the size of clusters should be. \ 
(Darafei Praliaskouski)