CVS commit: pkgsrc/databases/postgresql-postgis2

To: pkgsrc-changes%NetBSD.org@localhost
Subject: CVS commit: pkgsrc/databases/postgresql-postgis2
From: "Greg Troxel" <gdt%netbsd.org@localhost>
Date: Tue, 2 Sep 2025 18:13:41 +0000

Module Name:    pkgsrc
Committed By:   gdt
Date:           Tue Sep  2 18:13:41 UTC 2025

Modified Files:
        pkgsrc/databases/postgresql-postgis2: Makefile PLIST distinfo

Log Message:
postgresql-postgis2: Update to 3.6.0

Upstream NEWS:

PostGIS 3.6.0
2025/09/02

This version requires PostgreSQL 12-18beta3, GEOS 3.8 or higher, and Proj 6.1+.
To take advantage of all features, GEOS 3.14+ is needed.
To take advantage of all SFCGAL features, SFCGAL 2.2+ is needed.

Many thanks to our translation teams, in particular:

Teramoto Ikuhiro (Japanese Team)
Daniel Nylander (Swedish Team)
Dapeng Wang, Zuo Chenwei from HighGo (Chinese Team)

* Breaking Changes *

  - #5799, make ST_TileEnvelope clips envelopes to tile plane extent (Paul Ramsey)
  - #5829, remove constraint checking from geometry_columns view (Paul Ramsey)
  - #3373, GT-255, [topology] Support for upgrading domains (Ayo Adesugba, U.S. Census Bureau)
  - GT-252, ST_NumGeometries/ST_GeometryN treat TIN and PolyhedralSurface as unitary geometries,
    use ST_NumPatches/ST_PatchN for patch access (Loïc Bartoletti)
  - #3110, GT-242 [topology] Support for bigint (Ayo Adesugba, U.S. Census Bureau)
  - #5359, #5897, GT-260 [tiger_geocoder] Use @extschema:extension@ for PG >= 16
    to schema qualify dependent extensions, switch to use typmod for tiger tables
    (Regina Obe)

* Deprecated / Removed signatures *

 - #3110, GT-242, [topology] numerous topology functions that accepted integer
          replaced with bigint versions to support both integer and bigint inputs
          (Ayo Adesugba, U.S. Census Bureau)
 - #5498 Drop st_approxquantile(raster, double precision), wasn't usable as it triggered
    is not unique error when used (Regina Obe)

* New Features *

  - GH-803, [sfcgal] ADD CG_Simplify function (Loïc Bartoletti)
  - GH-805, [sfcgal] Add M support for SFCGAL >= 1.5.0 (Loïc Bartoletti)
  - GH-801, [sfcgal] ADD CG_3DAlphaWrapping function (Jean Felder)
  - #5894, [topology] TotalTopologySize (Sandro Santilli)
  - #5890, [topology] ValidateTopologyPrecision, MakeTopologyPrecise (Sandro Santilli)
  - #5861, [topology] Add --drop-topology switch to pgtopo_import (Sandro Santilli)
  - #1247, [raster] ST_AsRasterAgg (Sandro Santilli)
  - #5784, GT-223 Export circ_tree_distance_tree_internal for mobilitydb use
           (Maxime Schoemans)
  - GT-228, [sfcgal] Add new functions (Scale, Translate, Rotate, Buffer 3D and
           Straight Skeleton Partition) from SFCGAL 2 (Loïc Bartoletti)
  - [raster] New GUC postgis.gdal_cpl_debug, enables GDAL debugging messages
    and routes them into the PostgreSQL logging system. (Paul Ramsey)
  - #5841, Change interrupt handling to remove use of pqsignal to support PG 18 (Paul Ramsey)
  - Add ST_CoverageClean to edge match and gap remove polygonal
    coverages (Paul Ramsey) from GEOS 3.14 (Martin Davis)
  - #3110, GT-242 [topology] Support for bigint (Ayo Adesugba, U.S. Census Bureau)
  - [raster] Add ST_ReclassExact to quickly remap values in raster (Paul Ramsey)
  - #5963, [raster] add ST_IntersectionFractions - Requires GEOS 3.14 (Paul Ramsey)


To generate a diff of this commit:
cvs rdiff -u -r1.178 -r1.179 pkgsrc/databases/postgresql-postgis2/Makefile
cvs rdiff -u -r1.42 -r1.43 pkgsrc/databases/postgresql-postgis2/PLIST
cvs rdiff -u -r1.45 -r1.46 pkgsrc/databases/postgresql-postgis2/distinfo

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.

Modified files:

Index: pkgsrc/databases/postgresql-postgis2/Makefile
diff -u pkgsrc/databases/postgresql-postgis2/Makefile:1.178 pkgsrc/databases/postgresql-postgis2/Makefile:1.179
--- pkgsrc/databases/postgresql-postgis2/Makefile:1.178 Sat Aug 30 22:44:46 2025
+++ pkgsrc/databases/postgresql-postgis2/Makefile       Tue Sep  2 18:13:41 2025
@@ -1,11 +1,17 @@
-# $NetBSD: Makefile,v 1.178 2025/08/30 22:44:46 wiz Exp $
+# $NetBSD: Makefile,v 1.179 2025/09/02 18:13:41 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.5
-DISTNAME=      postgis-${MAJOR}.3
+# Note that the PKGPATH remains "postgresql-postgis2", added during
+# postgis 1->2 migration, due to inertia and the pain of renaming.  So
+# far it looks more likely than not that postgis will not need to be
+# versioned again soon.
+#
+# The version number is split because part of the version number ends
+# up in file names.  Alpha/beta/rc are cleanly flavors of minor and
+# thus do not need accomodating.
+MAJOR=         3.6
+MINOR=         0
+VERSION=       ${MAJOR}.${MINOR}
+DISTNAME=      postgis-${VERSION}
 PKGNAME=       postgresql${PGSQL_VERSION}-${DISTNAME}
 PKGREVISION=   4
 CATEGORIES=    databases geography
@@ -62,6 +68,10 @@ REPLACE_PERL+=               utils/create_spatial_ref
 INSTALL_ENV+=          mkinstalldirs=${INSTALL_DATA_DIR:Q}
 
 TEST_TARGET=           check
+# Assume the user running 'make test' can connect as pgsql, because
+# postgis tests require a superuser.
+TEST_ENV+=             PGUSER=pgsql
+
 # https://trac.osgeo.org/postgis/wiki/DevWikiGettingABackTrace#Usingwithregressiontests
 
 # TEST_DEPENDS

Index: pkgsrc/databases/postgresql-postgis2/PLIST
diff -u pkgsrc/databases/postgresql-postgis2/PLIST:1.42 pkgsrc/databases/postgresql-postgis2/PLIST:1.43
--- pkgsrc/databases/postgresql-postgis2/PLIST:1.42     Sun May 18 12:49:50 2025
+++ pkgsrc/databases/postgresql-postgis2/PLIST  Tue Sep  2 18:13:41 2025
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.42 2025/05/18 12:49:50 gdt Exp $
+@comment $NetBSD: PLIST,v 1.43 2025/09/02 18:13:41 gdt Exp $
 bin/pgsql2shp
 bin/pgtopo_export
 bin/pgtopo_import
@@ -101,7 +101,6 @@ share/postgresql/extension/address_stand
 share/postgresql/extension/address_standardizer--3.0.1--ANY.sql
 share/postgresql/extension/address_standardizer--3.0.10--ANY.sql
 share/postgresql/extension/address_standardizer--3.0.11--ANY.sql
-share/postgresql/extension/address_standardizer--3.0.12--ANY.sql
 share/postgresql/extension/address_standardizer--3.0.2--ANY.sql
 share/postgresql/extension/address_standardizer--3.0.3--ANY.sql
 share/postgresql/extension/address_standardizer--3.0.4--ANY.sql
@@ -149,8 +148,13 @@ share/postgresql/extension/address_stand
 share/postgresql/extension/address_standardizer--3.5.0--ANY.sql
 share/postgresql/extension/address_standardizer--3.5.1--ANY.sql
 share/postgresql/extension/address_standardizer--3.5.2--ANY.sql
+share/postgresql/extension/address_standardizer--3.5.3--ANY.sql
 share/postgresql/extension/address_standardizer--${PKGVERSION}--ANY.sql
 share/postgresql/extension/address_standardizer--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer--${PKGVERSION}alpha1--ANY.sql
+share/postgresql/extension/address_standardizer--${PKGVERSION}beta1--ANY.sql
+share/postgresql/extension/address_standardizer--${PKGVERSION}rc1--ANY.sql
+share/postgresql/extension/address_standardizer--${PKGVERSION}rc2--ANY.sql
 share/postgresql/extension/address_standardizer--ANY--${PKGVERSION}.sql
 share/postgresql/extension/address_standardizer--TEMPLATED--TO--ANY.sql
 share/postgresql/extension/address_standardizer.control
@@ -218,7 +222,6 @@ share/postgresql/extension/address_stand
 share/postgresql/extension/address_standardizer_data_us--3.0.1--ANY.sql
 share/postgresql/extension/address_standardizer_data_us--3.0.10--ANY.sql
 share/postgresql/extension/address_standardizer_data_us--3.0.11--ANY.sql
-share/postgresql/extension/address_standardizer_data_us--3.0.12--ANY.sql
 share/postgresql/extension/address_standardizer_data_us--3.0.2--ANY.sql
 share/postgresql/extension/address_standardizer_data_us--3.0.3--ANY.sql
 share/postgresql/extension/address_standardizer_data_us--3.0.4--ANY.sql
@@ -266,10 +269,15 @@ share/postgresql/extension/address_stand
 share/postgresql/extension/address_standardizer_data_us--3.5.0--ANY.sql
 share/postgresql/extension/address_standardizer_data_us--3.5.1--ANY.sql
 share/postgresql/extension/address_standardizer_data_us--3.5.2--ANY.sql
+share/postgresql/extension/address_standardizer_data_us--3.5.3--ANY.sql
 share/postgresql/extension/address_standardizer_data_us--${PKGVERSION}--${PKGVERSION}next.sql
 share/postgresql/extension/address_standardizer_data_us--${PKGVERSION}--ANY.sql
 share/postgresql/extension/address_standardizer_data_us--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--${PKGVERSION}alpha1--ANY.sql
+share/postgresql/extension/address_standardizer_data_us--${PKGVERSION}beta1--ANY.sql
 share/postgresql/extension/address_standardizer_data_us--${PKGVERSION}next--${PKGVERSION}.sql
+share/postgresql/extension/address_standardizer_data_us--${PKGVERSION}rc1--ANY.sql
+share/postgresql/extension/address_standardizer_data_us--${PKGVERSION}rc2--ANY.sql
 share/postgresql/extension/address_standardizer_data_us--ANY--${PKGVERSION}.sql
 share/postgresql/extension/address_standardizer_data_us--TEMPLATED--TO--ANY.sql
 share/postgresql/extension/address_standardizer_data_us.control
@@ -337,7 +345,6 @@ share/postgresql/extension/postgis--3.0.
 share/postgresql/extension/postgis--3.0.1--ANY.sql
 share/postgresql/extension/postgis--3.0.10--ANY.sql
 share/postgresql/extension/postgis--3.0.11--ANY.sql
-share/postgresql/extension/postgis--3.0.12--ANY.sql
 share/postgresql/extension/postgis--3.0.2--ANY.sql
 share/postgresql/extension/postgis--3.0.3--ANY.sql
 share/postgresql/extension/postgis--3.0.4--ANY.sql
@@ -385,8 +392,13 @@ share/postgresql/extension/postgis--3.4.
 share/postgresql/extension/postgis--3.5.0--ANY.sql
 share/postgresql/extension/postgis--3.5.1--ANY.sql
 share/postgresql/extension/postgis--3.5.2--ANY.sql
+share/postgresql/extension/postgis--3.5.3--ANY.sql
 share/postgresql/extension/postgis--${PKGVERSION}--ANY.sql
 share/postgresql/extension/postgis--${PKGVERSION}.sql
+share/postgresql/extension/postgis--${PKGVERSION}alpha1--ANY.sql
+share/postgresql/extension/postgis--${PKGVERSION}beta1--ANY.sql
+share/postgresql/extension/postgis--${PKGVERSION}rc1--ANY.sql
+share/postgresql/extension/postgis--${PKGVERSION}rc2--ANY.sql
 share/postgresql/extension/postgis--ANY--${PKGVERSION}.sql
 share/postgresql/extension/postgis--TEMPLATED--TO--ANY.sql
 share/postgresql/extension/postgis--unpackaged--${PKGVERSION}.sql
@@ -456,7 +468,6 @@ share/postgresql/extension/postgis_raste
 share/postgresql/extension/postgis_raster--3.0.1--ANY.sql
 share/postgresql/extension/postgis_raster--3.0.10--ANY.sql
 share/postgresql/extension/postgis_raster--3.0.11--ANY.sql
-share/postgresql/extension/postgis_raster--3.0.12--ANY.sql
 share/postgresql/extension/postgis_raster--3.0.2--ANY.sql
 share/postgresql/extension/postgis_raster--3.0.3--ANY.sql
 share/postgresql/extension/postgis_raster--3.0.4--ANY.sql
@@ -504,8 +515,13 @@ share/postgresql/extension/postgis_raste
 share/postgresql/extension/postgis_raster--3.5.0--ANY.sql
 share/postgresql/extension/postgis_raster--3.5.1--ANY.sql
 share/postgresql/extension/postgis_raster--3.5.2--ANY.sql
+share/postgresql/extension/postgis_raster--3.5.3--ANY.sql
 share/postgresql/extension/postgis_raster--${PKGVERSION}--ANY.sql
 share/postgresql/extension/postgis_raster--${PKGVERSION}.sql
+share/postgresql/extension/postgis_raster--${PKGVERSION}alpha1--ANY.sql
+share/postgresql/extension/postgis_raster--${PKGVERSION}beta1--ANY.sql
+share/postgresql/extension/postgis_raster--${PKGVERSION}rc1--ANY.sql
+share/postgresql/extension/postgis_raster--${PKGVERSION}rc2--ANY.sql
 share/postgresql/extension/postgis_raster--ANY--${PKGVERSION}.sql
 share/postgresql/extension/postgis_raster--TEMPLATED--TO--ANY.sql
 share/postgresql/extension/postgis_raster--unpackaged--${PKGVERSION}.sql
@@ -575,7 +591,6 @@ share/postgresql/extension/postgis_tiger
 share/postgresql/extension/postgis_tiger_geocoder--3.0.1--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.10--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.11--ANY.sql
-share/postgresql/extension/postgis_tiger_geocoder--3.0.12--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.2--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.3--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.0.4--ANY.sql
@@ -623,8 +638,13 @@ share/postgresql/extension/postgis_tiger
 share/postgresql/extension/postgis_tiger_geocoder--3.5.0--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.5.1--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--3.5.2--ANY.sql
+share/postgresql/extension/postgis_tiger_geocoder--3.5.3--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}.sql
+share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}alpha1--ANY.sql
+share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}beta1--ANY.sql
+share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}rc1--ANY.sql
+share/postgresql/extension/postgis_tiger_geocoder--${PKGVERSION}rc2--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--ANY--${PKGVERSION}.sql
 share/postgresql/extension/postgis_tiger_geocoder--TEMPLATED--TO--ANY.sql
 share/postgresql/extension/postgis_tiger_geocoder--unpackaged--${PKGVERSION}.sql
@@ -693,7 +713,6 @@ share/postgresql/extension/postgis_topol
 share/postgresql/extension/postgis_topology--3.0.1--ANY.sql
 share/postgresql/extension/postgis_topology--3.0.10--ANY.sql
 share/postgresql/extension/postgis_topology--3.0.11--ANY.sql
-share/postgresql/extension/postgis_topology--3.0.12--ANY.sql
 share/postgresql/extension/postgis_topology--3.0.2--ANY.sql
 share/postgresql/extension/postgis_topology--3.0.3--ANY.sql
 share/postgresql/extension/postgis_topology--3.0.4--ANY.sql
@@ -741,8 +760,13 @@ share/postgresql/extension/postgis_topol
 share/postgresql/extension/postgis_topology--3.5.0--ANY.sql
 share/postgresql/extension/postgis_topology--3.5.1--ANY.sql
 share/postgresql/extension/postgis_topology--3.5.2--ANY.sql
+share/postgresql/extension/postgis_topology--3.5.3--ANY.sql
 share/postgresql/extension/postgis_topology--${PKGVERSION}--ANY.sql
 share/postgresql/extension/postgis_topology--${PKGVERSION}.sql
+share/postgresql/extension/postgis_topology--${PKGVERSION}alpha1--ANY.sql
+share/postgresql/extension/postgis_topology--${PKGVERSION}beta1--ANY.sql
+share/postgresql/extension/postgis_topology--${PKGVERSION}rc1--ANY.sql
+share/postgresql/extension/postgis_topology--${PKGVERSION}rc2--ANY.sql
 share/postgresql/extension/postgis_topology--ANY--${PKGVERSION}.sql
 share/postgresql/extension/postgis_topology--TEMPLATED--TO--ANY.sql
 share/postgresql/extension/postgis_topology--unpackaged--${PKGVERSION}.sql

Index: pkgsrc/databases/postgresql-postgis2/distinfo
diff -u pkgsrc/databases/postgresql-postgis2/distinfo:1.45 pkgsrc/databases/postgresql-postgis2/distinfo:1.46
--- pkgsrc/databases/postgresql-postgis2/distinfo:1.45  Sun May 18 12:49:50 2025
+++ pkgsrc/databases/postgresql-postgis2/distinfo       Tue Sep  2 18:13:41 2025
@@ -1,5 +1,5 @@
-$NetBSD: distinfo,v 1.45 2025/05/18 12:49:50 gdt Exp $
+$NetBSD: distinfo,v 1.46 2025/09/02 18:13:41 gdt Exp $
 
-BLAKE2s (postgis-3.5.3.tar.gz) = 2c4a63884cd6d01fa2beb74b4b0465e955fa605519782e33471f98ec8f2f41dc
-SHA512 (postgis-3.5.3.tar.gz) = c27f57f0dbf3938648fe16dcaaff28530de6a51c13c481cb78163a51a292f3d77620485cd31e79cd01be675b5dca97129c50c562f68d6d864c822ea7359d754f
-Size (postgis-3.5.3.tar.gz) = 14899901 bytes
+BLAKE2s (postgis-3.6.0.tar.gz) = d2d119826f269696403f4447b44c97ad9825b6e72fd9852f8f0b59bdba55b712
+SHA512 (postgis-3.6.0.tar.gz) = 393faebb2f5f67b46888aab0a9fcfca891bb73fadbefd54406b4029c434ddff3da81eecbee7176898751e1c3d50c22a801526853332daf122073f7523918c6c7
+Size (postgis-3.6.0.tar.gz) = 16202671 bytes

Follow-Ups:
- Re: CVS commit: pkgsrc/databases/postgresql-postgis2
  - From: Adam

Prev by Date: CVS commit: pkgsrc/news/usenet_reborn
Next by Date: CVS commit: pkgsrc/doc
Previous by Thread: CVS commit: pkgsrc/news/usenet_reborn
Next by Thread: Re: CVS commit: pkgsrc/databases/postgresql-postgis2
Indexes:

Home | Main Index | Thread Index | Old Index