pkg/60316: Package databases/postgresql-postgis2 can work wit postgresql18

["jspath55%gmail.com@localhost via gnats" <gnats-admin%NetBSD.org@localhost>]

>Number:         60316
>Category:       pkg
>Synopsis:       Package databases/postgresql-postgis2 can work wit postgresql18
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    pkg-manager
>State:          open
>Class:          change-request
>Submitter-Id:   net
>Arrival-Date:   Tue Jun 09 00:45:00 +0000 2026
>Originator:     Jim Spath
>Release:        10.1
>Organization:
>Environment:
NetBSD amdhomebrew 10.1 NetBSD 10.1 (GENERIC) #0: Mon Dec 16 13:08:11 UTC 2024  mkrepro%mkrepro.NetBSD.org@localhost:/usr/src/sys/arch/amd64/compile/GENERIC amd64
>Description:
The Makefile for databases/postgresql-postgis2 includes PGSQL versions 14 through 17 but not 18. As there are postgresl18-server etc. packages it seemed likely to work with 18.

>How-To-Repeat:
Recent pkgsrc (2026Q4), install postgresl18-server and postgresl18-server, try to install postgresql-postgis2.

Error:
# make -f Makefile.df
=> Bootstrap dependency digest>=20211023: found digest-20220214
=> Checksum BLAKE2s OK for postgis-3.6.2.tar.gz
=> Checksum SHA512 OK for postgis-3.6.2.tar.gz
===> Installing dependencies for postgresql16-postgis-3.6.2


>Fix:
Alter the Makefile:
# diff Makefile*
44,45c44
< # PGSQL_VERSIONS_ACCEPTED=    17 16 15 14
< PGSQL_VERSIONS_ACCEPTED=      18 17 16 15 14
---
> PGSQL_VERSIONS_ACCEPTED=      17 16 15 14

Then the compile completes and installs a valid POSTGIS extension.

[...]
=> Creating binary package /usr/pkgsrc/databases/postgresql-postgis2/work/.packages/postgresql18-postgis-3.6.2.tgz
===> Building binary package for postgresql18-postgis-3.6.2
=> Creating binary package /usr/pkgsrc/packages/All/postgresql18-postgis-3.6.2.tgz
===> Installing binary package of postgresql18-postgis-3.6.2

Tested with QGIS data access, including attribute table edits.

Also reverted to Postgresql14 and verified the lowest listed version still works with the POSTGIS extension in a prior db.

# make
=> Bootstrap dependency digest>=20211023: found digest-20220214
=> Checksum BLAKE2s OK for postgis-3.6.2.tar.gz
=> Checksum SHA512 OK for postgis-3.6.2.tar.gz
===> Installing dependencies for postgresql14-postgis-3.6.2
==========================================================================
The following variables will affect the build process of this package,
postgresql14-postgis-3.6.2.  Their current value is shown below:
[...]


# psql -U zipcodes -d zipcodes -h localhost
psql (14.23)
Type "help" for help.

zipcodes=> \dx
                                List of installed extensions
  Name   | Version |   Schema   |                        Description
---------+---------+------------+------------------------------------------------------------
 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
 postgis | 3.4.3   | public     | PostGIS geometry and geography spatial types and functions
(2 rows)

zipcodes=> create extension postgis;
ERROR:  extension "postgis" already exists