git: 68d84485f85f - main - databases/postgresql18-*: Update to 18.0

From: Palle Girgensohn <girgen_at_FreeBSD.org>
Date: Mon, 29 Sep 2025 07:04:02 UTC
The branch main has been updated by girgen:

URL: https://cgit.FreeBSD.org/ports/commit/?id=68d84485f85fcb464ea27c9ee08345b97a78fc10

commit 68d84485f85fcb464ea27c9ee08345b97a78fc10
Author:     Palle Girgensohn <girgen@FreeBSD.org>
AuthorDate: 2025-09-29 07:02:38 +0000
Commit:     Palle Girgensohn <girgen@FreeBSD.org>
CommitDate: 2025-09-29 07:02:38 +0000

    databases/postgresql18-*: Update to 18.0
    
    PostgreSQL 18 improves performance for workloads of all sizes through a
    new I/O subsystem that has demonstrated up to 3× performance
    improvements when reading from storage, and also increases the number of
    queries that can use indexes. This release makes major-version upgrades
    less disruptive, accelerating upgrade times and reducing the time
    required to reach expected performance after an upgrade completes.
    Developers also benefit from PostgreSQL 18 features, including virtual
    generated columns that compute values at query time, and the
    database-friendly uuidv7() function that provides better indexing and
    read performance for UUIDs. PostgreSQL 18 makes it easier to integrate
    with single-sign on (SSO) systems with support for OAuth 2.0
    authentication.
    
    Release notes:  https://www.postgresql.org/about/news/postgresql-18-released-3142/
---
 databases/postgresql18-client/Makefile | 2 +-
 databases/postgresql18-server/Makefile | 5 +----
 databases/postgresql18-server/distinfo | 6 +++---
 3 files changed, 5 insertions(+), 8 deletions(-)

diff --git a/databases/postgresql18-client/Makefile b/databases/postgresql18-client/Makefile
index 5dabf9060252..a8997543b326 100644
--- a/databases/postgresql18-client/Makefile
+++ b/databases/postgresql18-client/Makefile
@@ -1,5 +1,5 @@
 PORTNAME=	postgresql
-PORTREVISION=	1
+PORTREVISION=	0
 
 COMMENT=	PostgreSQL database (client)
 
diff --git a/databases/postgresql18-server/Makefile b/databases/postgresql18-server/Makefile
index cc70310d1ab3..8d3202ae3cdb 100644
--- a/databases/postgresql18-server/Makefile
+++ b/databases/postgresql18-server/Makefile
@@ -1,5 +1,5 @@
 PORTNAME?=	postgresql
-DISTVERSION?=	18rc1
+DISTVERSION?=	18.0
 # PORTREVISION must be ?= otherwise, all slave ports get this PORTREVISION and
 # not their own.  Probably best to keep it at ?=0 when reset here too.
 PORTREVISION?=	0
@@ -137,9 +137,6 @@ ZSTD_DESC=		Build with ZSTD compression support
 ZSTD_CONFIGURE_WITH=	zstd
 ZSTD_LIB_DEPENDS=	libzstd.so:archivers/zstd
 USES+=			pkgconfig
-#ZSTD_CFLAGS=		-I${LOCALBASE}/include
-#ZSTD_LDFLAGS=		-L${LOCALBASE}/lib
-#ZSTD_LIBS=		-lzstd
 .  endif
 .endif
 
diff --git a/databases/postgresql18-server/distinfo b/databases/postgresql18-server/distinfo
index 7c9c1ac5c538..93ee9750257f 100644
--- a/databases/postgresql18-server/distinfo
+++ b/databases/postgresql18-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1756886504
-SHA256 (postgresql/postgresql-18rc1.tar.bz2) = b1a4cdc0ed6e97d117f044da67815829d560002c821290a9dee86e5e499b2f4c
-SIZE (postgresql/postgresql-18rc1.tar.bz2) = 22345319
+TIMESTAMP = 1758615221
+SHA256 (postgresql/postgresql-18.0.tar.bz2) = 0d5b903b1e5fe361bca7aa9507519933773eb34266b1357c4e7780fdee6d6078
+SIZE (postgresql/postgresql-18.0.tar.bz2) = 22412570