From: Jeremy Evans <jeremy@openbsd.org>
Subject: Update: PostgreSQL 17.6
To: OpenBSD ports <ports@openbsd.org>
Date: Thu, 14 Aug 2025 13:51:25 -0700

Updates to the latest version of PostgreSQL 17. Release notes available:
https://www.postgresql.org/about/news/postgresql-176-1610-1514-1419-1322-and-18-beta-3-released-3118/
Notably, fixes 3 CVEs.

Tested on amd64. I plan to commit in a couple days unless there are
objections.

Thanks,
Jeremy

Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
diff -u -p -u -p -r1.310 Makefile
--- Makefile	13 May 2025 01:19:35 -0000	1.310
+++ Makefile	14 Aug 2025 20:25:13 -0000
@@ -5,7 +5,7 @@ COMMENT-contrib=PostgreSQL RDBMS contrib
 COMMENT-plpython=Python procedural language for PostgreSQL
 COMMENT-pg_upgrade=Support for upgrading PostgreSQL data from previous version
 
-VERSION=	17.5
+VERSION=	17.6
 PREV_MAJOR=	16
 DISTNAME=	postgresql-${VERSION}
 PKGNAME-main=	postgresql-client-${VERSION}
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql/distinfo,v
diff -u -p -u -p -r1.105 distinfo
--- distinfo	13 May 2025 01:19:35 -0000	1.105
+++ distinfo	14 Aug 2025 20:25:27 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-17.5.tar.gz) = cwv+80sDglwFGuD8N1Qsi+JrVaRORyNpIhr9OXGW4wM=
-SIZE (postgresql-17.5.tar.gz) = 28082580
+SHA256 (postgresql-17.6.tar.gz) = KRC4UoNnTaLa5qwT/l67qvPEgkRjlsujLmco08xzbYY=
+SIZE (postgresql-17.6.tar.gz) = 28141372
Index: patches/patch-src_interfaces_libpq_Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/patches/patch-src_interfaces_libpq_Makefile,v
diff -u -p -u -p -r1.18 patch-src_interfaces_libpq_Makefile
--- patches/patch-src_interfaces_libpq_Makefile	29 Nov 2023 23:41:15 -0000	1.18
+++ patches/patch-src_interfaces_libpq_Makefile	14 Aug 2025 20:26:30 -0000
@@ -10,5 +10,5 @@ Index: src/interfaces/libpq/Makefile
 +SO_MAJOR_VERSION= ${LIBpq_MAJOR}
 +SO_MINOR_VERSION= ${LIBpq_MINOR}
  
- override CPPFLAGS :=  -I$(srcdir) $(CPPFLAGS) -I$(top_builddir)/src/port -I$(top_srcdir)/src/port
+ override CPPFLAGS := -I$(srcdir) -I$(top_builddir)/src/port -I$(top_srcdir)/src/port $(CPPFLAGS)
  ifneq ($(PORTNAME), win32)
Index: pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
diff -u -p -u -p -r1.118 PLIST-docs
--- pkg/PLIST-docs	13 May 2025 01:19:35 -0000	1.118
+++ pkg/PLIST-docs	14 Aug 2025 20:32:16 -0000
@@ -700,6 +700,7 @@ share/doc/postgresql/html/release-17-2.h
 share/doc/postgresql/html/release-17-3.html
 share/doc/postgresql/html/release-17-4.html
 share/doc/postgresql/html/release-17-5.html
+share/doc/postgresql/html/release-17-6.html
 share/doc/postgresql/html/release-17.html
 share/doc/postgresql/html/release-prior.html
 share/doc/postgresql/html/release.html