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 *

3 files changed, 235 insertions, 14 deletions

diff --git a/databases/postgresql-postgis2/Makefile b/databases/postgresql-postgis2/Makefile
index 3ca9026f4f4..7ee41ea489d 100644
--- a/databases/postgresql-postgis2/Makefile
+++ b/databases/postgresql-postgis2/Makefile
@@ -1,13 +1,12 @@
-# $NetBSD: Makefile,v 1.115 2022/06/28 11:31:32 wiz Exp $
+# $NetBSD: Makefile,v 1.116 2022/09/04 00:31:01 gdt Exp $
 
 # Note that the directory is still postgis2, for historical reasons.
 # It remains, due to inertia and the pain of renaming outweighing the
 # benefit.  So far it looks more likely than not that postgis will not
 # need to be versioned again soon.
-MAJOR=		3.2
-DISTNAME=	postgis-${MAJOR}.1
+MAJOR=		3.3
+DISTNAME=	postgis-${MAJOR}.0
 PKGNAME=	postgresql${PGSQL_VERSION}-${DISTNAME}
-PKGREVISION=	4
 CATEGORIES=	databases geography
 MASTER_SITES=	https://download.osgeo.org/postgis/source/
 
@@ -41,12 +40,14 @@ USE_TOOLS+=		gmake lex pax perl pkg-config
 GNU_CONFIGURE=		yes
 CONFIGURE_ARGS+=	--enable-rpath
 CONFIGURE_ARGS+=	--datadir=${PREFIX}/share/postgresql/contrib
+# Documented requirement is pgsql >= 11
+PGSQL_VERSIONS_ACCEPTED=	14 13 12 11
 
-# The address standardizer needs more modules; see
-# share/doc/postgresql/extension/README.address_standardizer
-# for details.  Until they are required, disable it to ensure
-# repeatable builds.
-CONFIGURE_ARGS+=	--without-address-standardizer
+# This isn't an option, but could be.
+CONFIGURE_ARGS+=	--with-address-standardizer
+
+# \todo Add sfcgal >=1.3.2 https://gitlab.com/Oslandia/SFCGAL
+# and CGAL >=4.1.
 
 BUILD_TARGET=		all docs
 INSTALL_TARGET=		install docs-install
@@ -57,6 +58,7 @@ PLIST_SUBST+=		MAJOR=${MAJOR}
 PRINT_PLIST_AWK+=	{ gsub(/postgis-${MAJOR:S|/|\\/|g}/, "postgis-$${MAJOR}") }
 PRINT_PLIST_AWK+=	{ gsub(/topology-${MAJOR:S|/|\\/|g}/, "topology-$${MAJOR}") }
 
+# \todo Remove or file bugs upstream
 INSTALLATION_DIRS=	${DOCDIR} ${DOCDIR}/images ${PKGMANDIR}/man1
 
 REPLACE_PERL+=		utils/postgis_restore.pl.in
@@ -80,9 +82,19 @@ CONFIGURE_ARGS+=	-with-xsldir=${PREFIX}/share/xsl/docbook
 MAKE_ENV+=		"XSLTPROCFLAGS=--timing"
 
 # These are really all BUILD_DEPENDS.
+# \todo Report upstream; they are not mentioned in README.postgis.
 .include "../../graphics/ImageMagick/buildlink3.mk"
 .include "../../textproc/libxslt/buildlink3.mk"
 
+# address standardizer (separate for possible future option)
+.include "../../devel/pcre2/buildlink3.mk"
+
+# MISSING DEPEENDS
+# "GNU gettext 0.14" for the loader
+
+# OMITTED DEPENDS
+# gtk 2.2.0, for GUI version of shp2pgsql
+
 # NORMAL DEPENDS
 .include "../../devel/protobuf-c/buildlink3.mk"
 .include "../../geography/gdal-lib/buildlink3.mk"
diff --git a/databases/postgresql-postgis2/PLIST b/databases/postgresql-postgis2/PLIST
index 1882ac2152c..74a8821b160 100644
--- a/databases/postgresql-postgis2/PLIST
+++ b/databases/postgresql-postgis2/PLIST
@@ -1,10 +1,14 @@
-@comment $NetBSD: PLIST,v 1.29 2022/02/15 15:17:59 gdt Exp $
+@comment $NetBSD: PLIST,v 1.30 2022/09/04 00:31:01 gdt Exp $
 bin/pgsql2shp
+bin/pgtopo_export
+bin/pgtopo_import
 bin/raster2pgsql
 bin/shp2pgsql
+lib/postgresql/address_standardizer-3.so
 lib/postgresql/postgis-3.so
 lib/postgresql/postgis_raster-3.so
 lib/postgresql/postgis_topology-3.so
+share/doc/postgresql/extension/README.address_standardizer
 share/postgresql/contrib/postgis-${MAJOR}/legacy.sql
 share/postgresql/contrib/postgis-${MAJOR}/legacy_gist.sql
 share/postgresql/contrib/postgis-${MAJOR}/legacy_minimal.sql
@@ -25,6 +29,175 @@ share/postgresql/contrib/postgis-${MAJOR}/uninstall_legacy.sql
 share/postgresql/contrib/postgis-${MAJOR}/uninstall_postgis.sql
 share/postgresql/contrib/postgis-${MAJOR}/uninstall_rtpostgis.sql
 share/postgresql/contrib/postgis-${MAJOR}/uninstall_topology.sql
+share/postgresql/extension/address_standardizer--1.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.0.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.0.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.0.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.0.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.0.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.0.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.0.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.0.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.1.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.1.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.1.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.1.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.1.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.1.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.1.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.1.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.1.8--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.1.9--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.2.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.2.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.2.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.2.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.2.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.2.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.2.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.2.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.2.8--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.10--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.11--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.8--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.3.9--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.4.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.4.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.4.10--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.4.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.4.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.4.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.4.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.4.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.4.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.4.8--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.4.9--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.5.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.5.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.5.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.5.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.5.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.5.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.5.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.5.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--2.5.8--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.0.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.0.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.0.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.0.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.0.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.0.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.0.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.0.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.1.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.1.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.1.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.1.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.1.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.1.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.1.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.1.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.2.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.2.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.2.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--3.2.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--${PKGVERSION}--${PKGVERSION}next.sql
+share/postgresql/extension/address_standardizer--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--${PKGVERSION}next--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--ANY--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer.control
+share/postgresql/extension/address_standardizer_data_us--2.0.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.0.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.0.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.0.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.0.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.0.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.0.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.0.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.1.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.1.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.1.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.1.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.1.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.1.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.1.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.1.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.1.8--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.1.9--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.2.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.2.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.2.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.2.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.2.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.2.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.2.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.2.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.2.8--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.10--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.11--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.8--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.3.9--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.4.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.4.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.4.10--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.4.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.4.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.4.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.4.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.4.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.4.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.4.8--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.4.9--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.5.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.5.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.5.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.5.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.5.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.5.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.5.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.5.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--2.5.8--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.0.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.0.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.0.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.0.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.0.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.0.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.0.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.0.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.1.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.1.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.1.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.1.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.1.4--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.1.5--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.1.6--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.1.7--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.2.0--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.2.1--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.2.2--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--3.2.3--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--${PKGVERSION}--${PKGVERSION}next.sql
+share/postgresql/extension/address_standardizer_data_us--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--${PKGVERSION}next--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--ANY--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us.control
 share/postgresql/extension/postgis--2.0.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis--2.0.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis--2.0.2--${PKGVERSION}.sql
@@ -82,19 +255,28 @@ share/postgresql/extension/postgis--2.5.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis--2.5.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis--2.5.5--${PKGVERSION}.sql
 share/postgresql/extension/postgis--2.5.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis--2.5.7--${PKGVERSION}.sql
+share/postgresql/extension/postgis--2.5.8--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.0.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.0.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.0.2--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.0.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.0.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.0.5--${PKGVERSION}.sql
+share/postgresql/extension/postgis--3.0.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis--3.0.7--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.1.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.1.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.1.2--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.1.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.1.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.1.5--${PKGVERSION}.sql
+share/postgresql/extension/postgis--3.1.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis--3.1.7--${PKGVERSION}.sql
 share/postgresql/extension/postgis--3.2.0--${PKGVERSION}.sql
+share/postgresql/extension/postgis--3.2.1--${PKGVERSION}.sql
+share/postgresql/extension/postgis--3.2.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis--3.2.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis--${PKGVERSION}--${PKGVERSION}next.sql
 share/postgresql/extension/postgis--${PKGVERSION}.sql
 share/postgresql/extension/postgis--${PKGVERSION}next--${PKGVERSION}.sql
@@ -159,19 +341,28 @@ share/postgresql/extension/postgis_raster--2.5.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--2.5.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--2.5.5--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--2.5.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--2.5.7--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--2.5.8--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.0.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.0.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.0.2--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.0.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.0.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.0.5--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--3.0.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--3.0.7--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.1.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.1.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.1.2--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.1.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.1.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.1.5--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--3.1.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--3.1.7--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--3.2.0--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--3.2.1--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--3.2.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--3.2.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--${PKGVERSION}--${PKGVERSION}next.sql
 share/postgresql/extension/postgis_raster--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--${PKGVERSION}next--${PKGVERSION}.sql
@@ -236,19 +427,28 @@ share/postgresql/extension/postgis_tiger_geocoder--2.5.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--2.5.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--2.5.5--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--2.5.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--2.5.7--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--2.5.8--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.2--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.5--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--3.0.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--3.0.7--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.1.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.1.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.1.2--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.1.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.1.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.1.5--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--3.1.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--3.1.7--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.2.0--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--3.2.1--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--3.2.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--3.2.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}--${PKGVERSION}next.sql
 share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}next--${PKGVERSION}.sql
@@ -312,19 +512,28 @@ share/postgresql/extension/postgis_topology--2.5.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--2.5.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--2.5.5--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--2.5.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--2.5.7--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--2.5.8--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.0.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.0.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.0.2--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.0.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.0.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.0.5--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--3.0.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--3.0.7--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.1.0--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.1.1--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.1.2--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.1.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.1.4--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.1.5--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--3.1.6--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--3.1.7--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--3.2.0--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--3.2.1--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--3.2.2--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--3.2.3--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--${PKGVERSION}--${PKGVERSION}next.sql
 share/postgresql/extension/postgis_topology--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--${PKGVERSION}next--${PKGVERSION}.sql
diff --git a/databases/postgresql-postgis2/distinfo b/databases/postgresql-postgis2/distinfo
index e5f380cb8a9..2d439e5d536 100644
--- a/databases/postgresql-postgis2/distinfo
+++ b/databases/postgresql-postgis2/distinfo
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.32 2022/02/15 15:17:59 gdt Exp $
+$NetBSD: distinfo,v 1.33 2022/09/04 00:31:01 gdt Exp $
 
-BLAKE2s (postgis-3.2.1.tar.gz) = 681f37b36984e9551430feb9fdf074f36ad987cd5fa9955d0a025298b2f0a027
-SHA512 (postgis-3.2.1.tar.gz) = e0ea3d2304e71c98dd045a8031946235d9c26a1310e1ffa556db10dfd18378957ee3d88608fba7ff482835d8c8b41d7f7bddaff1279ce0b50cd7634237465b31
-Size (postgis-3.2.1.tar.gz) = 16883824 bytes
+BLAKE2s (postgis-3.3.0.tar.gz) = 369d56aab1b5c32016d34fb6d4812509079e1b612849a4a5012d3d76b23fed09
+SHA512 (postgis-3.3.0.tar.gz) = 38da1c3a43eeeaf0eaa526db1036c0861c0cc3a5586b7d942d3d50296e85904aec80eb7f3689aa1ef854fbb979aafe8237cc4c0a71024b05f5cd7f5ea20722e3
+Size (postgis-3.3.0.tar.gz) = 17718971 bytes