NetBSD Problem Report #60316

From www@netbsd.org  Tue Jun  9 00:40:15 2026
Return-Path: <www@netbsd.org>
Received: from mail.netbsd.org (mail.netbsd.org [199.233.217.200])
	(using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)
	 key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256
	 client-signature RSA-PSS (2048 bits) client-digest SHA256)
	(Client CN "mail.netbsd.org", Issuer "R13" (not verified))
	by mollari.NetBSD.org (Postfix) with ESMTPS id 2B0311A923A
	for <gnats-bugs@gnats.NetBSD.org>; Tue,  9 Jun 2026 00:40:15 +0000 (UTC)
Message-Id: <20260609004014.02D811A923B@mollari.NetBSD.org>
Date: Tue,  9 Jun 2026 00:40:13 +0000 (UTC)
From: jspath55@gmail.com
Reply-To: jspath55@gmail.com
To: gnats-bugs@NetBSD.org
Subject: Package databases/postgresql-postgis2 can work wit postgresql18
X-Send-Pr-Version: www-1.0
X-From4GNATS: "jspath55@gmail.com via gnats" <gnats-admin@NetBSD.org>

>Number:         60316
>Category:       pkg
>Synopsis:       Package databases/postgresql-postgis2 can work wit postgresql18
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    gdt
>State:          closed
>Class:          change-request
>Submitter-Id:   net
>Arrival-Date:   Tue Jun 09 00:45:00 +0000 2026
>Closed-Date:    Wed Jun 10 14:01:31 +0000 2026
>Last-Modified:  Wed Jun 10 14:01:31 +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:/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


>Release-Note:

>Audit-Trail:

State-Changed-From-To: open->feedback
State-Changed-By: gdt@NetBSD.org
State-Changed-When: Tue, 09 Jun 2026 09:12:26 +0000
State-Changed-Why:
pkgsrc updated to add 18; please confirm if the fix is
right
Thanks for pointing this out and especially for testing
in the key environment of qgis.


From: "Greg Troxel" <gdt@netbsd.org>
To: gnats-bugs@gnats.NetBSD.org
Cc: 
Subject: PR/60316 CVS commit: pkgsrc/databases/postgresql-postgis2
Date: Tue, 9 Jun 2026 09:10:48 +0000

 Module Name:	pkgsrc
 Committed By:	gdt
 Date:		Tue Jun  9 09:10:48 UTC 2026

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

 Log Message:
 databases/postgresql-postgis2: Accept pgsql 18

 PostgreSQL 18 is ok, per upstream's README.postgis ("and above") (and
 if it didn't work I'd be hearing about it on postgis-devel@).

 In PR pkg/60316, Jim Spath reports that adding 18 and testing with
 qgis was successful (and also that pgsql 14 is still ok, not related
 to this commit but good to know).


 To generate a diff of this commit:
 cvs rdiff -u -r1.194 -r1.195 pkgsrc/databases/postgresql-postgis2/Makefile

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

Responsible-Changed-From-To: pkg-manager->gdt
Responsible-Changed-By: gdt@NetBSD.org
Responsible-Changed-When: Tue, 09 Jun 2026 09:26:11 +0000
Responsible-Changed-Why:
Taking this because I am $MAINTAINER.


State-Changed-From-To: feedback->closed
State-Changed-By: gdt@NetBSD.org
State-Changed-When: Wed, 10 Jun 2026 14:01:31 +0000
State-Changed-Why:
submitter agrees to closure


>Unformatted:

NetBSD Home
NetBSD PR Database Search

(Contact us) $NetBSD: query-full-pr,v 1.51 2026/08/10 02:28:17 riastradh Exp $
$NetBSD: gnats_config.sh,v 1.10 2026/05/13 22:00:09 riastradh Exp $
Copyright © 1994-2026 The NetBSD Foundation, Inc. ALL RIGHTS RESERVED.