git: 68d84485f85f - main - databases/postgresql18-*: Update to 18.0
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
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