git: 60c44ec8a907 - main - databases/postgresql??-*: Update to latest versions

Palle Girgensohn <[email protected]>
Newsgroups gmane.os.freebsd.devel.cvs.ports
Message-ID <[email protected]>
The branch main has been updated by girgen:

URL: https://cgit.FreeBSD.org/ports/commit/?id=60c44ec8a907bb79b51fc6efb48ea2b7ed4c5d1e

commit 60c44ec8a907bb79b51fc6efb48ea2b7ed4c5d1e
Author:     Palle Girgensohn <[email protected]>
AuthorDate: 2026-08-13 06:45:56 +0000
Commit:     Palle Girgensohn <[email protected]>
CommitDate: 2026-08-16 17:03:01 +0000

    databases/postgresql??-*: Update to latest versions
    
    Update to 18.6, 17.11, 16.15, 15.19 and 14.24.
    
    This release fixes 28 security vulnerabilities and over 110 bugs
    reported over the last several months.
    
    Welcome postgresql19 to the ports tree with 19-beta3.
    
    Note: PostgreSQL 18.5 was skipped due to a regression; the fix
    version is 18.6.
    
    PostgreSQL 14 will stop receiving fixes on 2026-11-12.
    
    Changes:        https://www.postgresql.org/about/news/postgresql-186-1711-1615-1519-1424-and-19-beta-3-released-3365/
    Security:       05d311bc-9991-11f1-bc50-6cc21735f730
---
 Mk/Uses/pgsql.mk                                   |    2 +-
 databases/postgresql14-pgtcl/Makefile              |    2 +-
 databases/postgresql14-server/Makefile             |    4 +-
 databases/postgresql14-server/distinfo             |    6 +-
 databases/postgresql15-pgtcl/Makefile              |    2 +-
 databases/postgresql15-server/Makefile             |    4 +-
 databases/postgresql15-server/distinfo             |    6 +-
 databases/postgresql16-pgtcl/Makefile              |    2 +-
 databases/postgresql16-server/Makefile             |    4 +-
 databases/postgresql16-server/distinfo             |    6 +-
 databases/postgresql17-pgtcl/Makefile              |    2 +-
 databases/postgresql17-server/Makefile             |    4 +-
 databases/postgresql17-server/distinfo             |    6 +-
 databases/postgresql17-server/pkg-plist-server     |   36 +-
 databases/postgresql18-pgtcl/Makefile              |    2 +-
 databases/postgresql18-server/Makefile             |  246 +--
 databases/postgresql18-server/distinfo             |    6 +-
 databases/postgresql18-server/pkg-plist-server     |   36 +-
 databases/postgresql19-client/Makefile             |   28 +
 databases/postgresql19-contrib/Makefile            |   41 +
 databases/postgresql19-contrib/pkg-descr           |   21 +
 databases/postgresql19-docs/Makefile               |   38 +
 databases/postgresql19-pgtcl/Makefile              |    9 +
 databases/postgresql19-plperl/Makefile             |   28 +
 databases/postgresql19-plpython/Makefile           |   29 +
 databases/postgresql19-plpython/pkg-descr          |    4 +
 databases/postgresql19-pltcl/Makefile              |   32 +
 databases/postgresql19-server/Makefile             |  260 +++
 databases/postgresql19-server/distinfo             |    3 +
 databases/postgresql19-server/files/502.pgsql.in   |  114 ++
 databases/postgresql19-server/files/dot.cshrc.in   |   11 +
 databases/postgresql19-server/files/dot.profile.in |   22 +
 .../files/patch-src-Makefile.shlib                 |   11 +
 .../files/patch-src-backend-Makefile               |   11 +
 ...h-src_backend_utils_misc_postgresql.conf.sample |   10 +
 .../files/pkg-message-client.in                    |   38 +
 .../files/pkg-message-contrib.in                   |    9 +
 .../files/pkg-message-plperl.in                    |    9 +
 .../files/pkg-message-plpython.in                  |    9 +
 .../postgresql19-server/files/pkg-message-pltcl.in |    9 +
 .../files/pkg-message-server.in                    |   70 +
 .../postgresql19-server/files/pkgIndex.tcl.in      |    4 +
 databases/postgresql19-server/files/postgresql.in  |  126 ++
 databases/postgresql19-server/pkg-descr            |   21 +
 databases/postgresql19-server/pkg-install-server   |   23 +
 databases/postgresql19-server/pkg-plist-client     | 1444 ++++++++++++++++
 databases/postgresql19-server/pkg-plist-contrib    |  290 ++++
 databases/postgresql19-server/pkg-plist-plperl     |   24 +
 databases/postgresql19-server/pkg-plist-plpython   |   32 +
 databases/postgresql19-server/pkg-plist-pltcl      |    6 +
 databases/postgresql19-server/pkg-plist-server     | 1767 ++++++++++++++++++++
 51 files changed, 4623 insertions(+), 306 deletions(-)

diff --git a/Mk/Uses/pgsql.mk b/Mk/Uses/pgsql.mk
index f24ea6353e85..3895e55b07cc 100644
--- a/Mk/Uses/pgsql.mk
+++ b/Mk/Uses/pgsql.mk
@@ -39,7 +39,7 @@ _INCLUDE_USES_PGSQL_MK=	yes
 
 # When adding a version, please keep the comment in
 # Mk/bsd.default-versions.mk in sync.
-VALID_PGSQL_VER=	14 15 16 17 18
+VALID_PGSQL_VER=	14 15 16 17 18 19
 
 # Override non-default LIBVERS like this:
 #PGSQL99_LIBVER=6
diff --git a/databases/postgresql14-pgtcl/Makefile b/databases/postgresql14-pgtcl/Makefile
index 3aac14571fad..01d94ddca0a7 100644
--- a/databases/postgresql14-pgtcl/Makefile
+++ b/databases/postgresql14-pgtcl/Makefile
@@ -1,7 +1,7 @@
 PORTREVISION=	0
 PKGNAMESUFFIX=	-postgresql14
 
-CONFLICTS=	pgtcl pgtcl-postgresql9[0123456] pgtcl-postgresql1[0123-56789]
+CONFLICTS=	pgtcl pgtcl-postgresql1[0-35-9]
 
 PGTCL_SLAVE=	14
 MASTERDIR=	${.CURDIR}/../pgtcl
diff --git a/databases/postgresql14-server/Makefile b/databases/postgresql14-server/Makefile
index 74cc2816dfa0..ad1bc71ead89 100644
--- a/databases/postgresql14-server/Makefile
+++ b/databases/postgresql14-server/Makefile
@@ -1,4 +1,4 @@
-DISTVERSION?=	14.23
+DISTVERSION?=	14.24
 # 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
@@ -21,4 +21,4 @@ PG_USER?=	postgres
 PG_GROUP?=	postgres
 PG_UID?=	770
 
-.include "${.CURDIR}/../postgresql18-server/Makefile"
+.include "${.CURDIR}/../postgresql19-server/Makefile"
diff --git a/databases/postgresql14-server/distinfo b/databases/postgresql14-server/distinfo
index 9b92b181e7b6..816a42805c1d 100644
--- a/databases/postgresql14-server/distinfo
+++ b/databases/postgresql14-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1778599531
-SHA256 (postgresql/postgresql-14.23.tar.bz2) = cc7216822b546330e29c2f91e123c8734a4c41795082145bb962aa712e8c94a5
-SIZE (postgresql/postgresql-14.23.tar.bz2) = 22586931
+TIMESTAMP = 1786458461
+SHA256 (postgresql/postgresql-14.24.tar.bz2) = a7fa7ed3d558172355f51406097a7bd4f6b473be80f311ef7cda96bf383d8897
+SIZE (postgresql/postgresql-14.24.tar.bz2) = 22648062
diff --git a/databases/postgresql15-pgtcl/Makefile b/databases/postgresql15-pgtcl/Makefile
index 52031c0226d7..aeeef545002a 100644
--- a/databases/postgresql15-pgtcl/Makefile
+++ b/databases/postgresql15-pgtcl/Makefile
@@ -1,7 +1,7 @@
 PORTREVISION=	0
 PKGNAMESUFFIX=	-postgresql15
 
-CONFLICTS=	pgtcl pgtcl-postgresql9[0123456] pgtcl-postgresql1[0123-56789]
+CONFLICTS=	pgtcl pgtcl-postgresql1[0-46-9]
 
 PGTCL_SLAVE=	15
 MASTERDIR=	${.CURDIR}/../pgtcl
diff --git a/databases/postgresql15-server/Makefile b/databases/postgresql15-server/Makefile
index 752466f36e2a..ac17e8a0e459 100644
--- a/databases/postgresql15-server/Makefile
+++ b/databases/postgresql15-server/Makefile
@@ -1,4 +1,4 @@
-DISTVERSION?=	15.18
+DISTVERSION?=	15.19
 # 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
@@ -21,4 +21,4 @@ PG_USER?=	postgres
 PG_GROUP?=	postgres
 PG_UID?=	770
 
-.include "${.CURDIR}/../postgresql18-server/Makefile"
+.include "${.CURDIR}/../postgresql19-server/Makefile"
diff --git a/databases/postgresql15-server/distinfo b/databases/postgresql15-server/distinfo
index b45ca3bda4d9..9847d46d5e64 100644
--- a/databases/postgresql15-server/distinfo
+++ b/databases/postgresql15-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1778599532
-SHA256 (postgresql/postgresql-15.18.tar.bz2) = 11df0df97fe3ea4ba9a791faaf39cee1d2fe571e78885b5b55d8517d27c323b4
-SIZE (postgresql/postgresql-15.18.tar.bz2) = 23405115
+TIMESTAMP = 1786458462
+SHA256 (postgresql/postgresql-15.19.tar.bz2) = e1a64a87a46b825b88c082e4518161a47aab53c45694964f8ba1df28f7859f89
+SIZE (postgresql/postgresql-15.19.tar.bz2) = 23452545
diff --git a/databases/postgresql16-pgtcl/Makefile b/databases/postgresql16-pgtcl/Makefile
index d00c1675f6a7..741254637a80 100644
--- a/databases/postgresql16-pgtcl/Makefile
+++ b/databases/postgresql16-pgtcl/Makefile
@@ -1,7 +1,7 @@
 PORTREVISION=	0
 PKGNAMESUFFIX=	-postgresql16
 
-CONFLICTS=	pgtcl pgtcl-postgresql9[0123456] pgtcl-postgresql1[012345-789]
+CONFLICTS=	pgtcl pgtcl-postgresql1[0-57-9]
 
 PGTCL_SLAVE=	16
 MASTERDIR=	${.CURDIR}/../pgtcl
diff --git a/databases/postgresql16-server/Makefile b/databases/postgresql16-server/Makefile
index d14641b84f62..96357c9e18a5 100644
--- a/databases/postgresql16-server/Makefile
+++ b/databases/postgresql16-server/Makefile
@@ -1,4 +1,4 @@
-DISTVERSION?=	16.14
+DISTVERSION?=	16.15
 # 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
@@ -21,4 +21,4 @@ PG_USER?=	postgres
 PG_GROUP?=	postgres
 PG_UID?=	770
 
-.include "${.CURDIR}/../postgresql18-server/Makefile"
+.include "${.CURDIR}/../postgresql19-server/Makefile"
diff --git a/databases/postgresql16-server/distinfo b/databases/postgresql16-server/distinfo
index c1ae65fffc2c..560410a61159 100644
--- a/databases/postgresql16-server/distinfo
+++ b/databases/postgresql16-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1778599533
-SHA256 (postgresql/postgresql-16.14.tar.bz2) = f6d077142737920858ce958ccdb75c6ee137a63b5b0853c70693d401ac7e3471
-SIZE (postgresql/postgresql-16.14.tar.bz2) = 25106859
+TIMESTAMP = 1786458463
+SHA256 (postgresql/postgresql-16.15.tar.bz2) = c1575341fa7bd40f5274ea465b34390f4dc64cdd0770af327005caaeb9f6b7ed
+SIZE (postgresql/postgresql-16.15.tar.bz2) = 25181309
diff --git a/databases/postgresql17-pgtcl/Makefile b/databases/postgresql17-pgtcl/Makefile
index 82c21695e2a7..cfd5ceb07060 100644
--- a/databases/postgresql17-pgtcl/Makefile
+++ b/databases/postgresql17-pgtcl/Makefile
@@ -1,7 +1,7 @@
 PORTREVISION=	0
 PKGNAMESUFFIX=	-postgresql17
 
-CONFLICTS=	pgtcl pgtcl-postgresql1[012345689]
+CONFLICTS=	pgtcl pgtcl-postgresql1[0-68-9]
 
 PGTCL_SLAVE=	17
 MASTERDIR=	${.CURDIR}/../pgtcl
diff --git a/databases/postgresql17-server/Makefile b/databases/postgresql17-server/Makefile
index 2585c7b2055d..abbc74b5b5d3 100644
--- a/databases/postgresql17-server/Makefile
+++ b/databases/postgresql17-server/Makefile
@@ -1,4 +1,4 @@
-DISTVERSION?=	17.10
+DISTVERSION?=	17.11
 # 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
@@ -21,4 +21,4 @@ PG_USER?=	postgres
 PG_GROUP?=	postgres
 PG_UID?=	770
 
-.include "${.CURDIR}/../postgresql18-server/Makefile"
+.include "${.CURDIR}/../postgresql19-server/Makefile"
diff --git a/databases/postgresql17-server/distinfo b/databases/postgresql17-server/distinfo
index 5f3d36a771cb..64173a6befe1 100644
--- a/databases/postgresql17-server/distinfo
+++ b/databases/postgresql17-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1778599534
-SHA256 (postgresql/postgresql-17.10.tar.bz2) = 078a03516dcdbdb705fecaf415ea3d13a956c589e46f09fed68a06fb00598c90
-SIZE (postgresql/postgresql-17.10.tar.bz2) = 21664720
+TIMESTAMP = 1786458464
+SHA256 (postgresql/postgresql-17.11.tar.bz2) = dd27f2b3c59e73ed14aa3324901242bf69a032a6347805f274e6260322d42979
+SIZE (postgresql/postgresql-17.11.tar.bz2) = 21787224
diff --git a/databases/postgresql17-server/pkg-plist-server b/databases/postgresql17-server/pkg-plist-server
index 5752ed752f4d..5096540c6359 100644
--- a/databases/postgresql17-server/pkg-plist-server
+++ b/databases/postgresql17-server/pkg-plist-server
@@ -832,7 +832,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/de/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/de/LC_MESSAGES/pg_combinebackup-17.mo
+%%NLS%%share/locale/de/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -841,7 +841,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/de/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/de/LC_MESSAGES/pg_walsummary-17.mo
+%%NLS%%share/locale/de/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/el/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
@@ -860,7 +860,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/es/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/es/LC_MESSAGES/pg_combinebackup-17.mo
+%%NLS%%share/locale/es/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -869,14 +869,14 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/es/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/es/LC_MESSAGES/pg_walsummary-17.mo
+%%NLS%%share/locale/es/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/fr/LC_MESSAGES/pg_combinebackup-17.mo
+%%NLS%%share/locale/fr/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -885,7 +885,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/fr/LC_MESSAGES/pg_walsummary-17.mo
+%%NLS%%share/locale/fr/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/he/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
@@ -909,7 +909,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ja/LC_MESSAGES/pg_combinebackup-17.mo
+%%NLS%%share/locale/ja/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -918,14 +918,14 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ja/LC_MESSAGES/pg_walsummary-17.mo
+%%NLS%%share/locale/ja/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ka/LC_MESSAGES/pg_combinebackup-17.mo
+%%NLS%%share/locale/ka/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -934,14 +934,14 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ka/LC_MESSAGES/pg_walsummary-17.mo
+%%NLS%%share/locale/ka/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ko/LC_MESSAGES/pg_combinebackup-17.mo
+%%NLS%%share/locale/ko/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -950,7 +950,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ko/LC_MESSAGES/pg_walsummary-17.mo
+%%NLS%%share/locale/ko/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/pl/LC_MESSAGES/%%PG_USER%%-%%PG_VERSION%%.mo
@@ -981,7 +981,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ru/LC_MESSAGES/pg_combinebackup-17.mo
+%%NLS%%share/locale/ru/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -990,14 +990,14 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ru/LC_MESSAGES/pg_walsummary-17.mo
+%%NLS%%share/locale/ru/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/sv/LC_MESSAGES/pg_combinebackup-17.mo
+%%NLS%%share/locale/sv/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -1006,7 +1006,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/sv/LC_MESSAGES/pg_walsummary-17.mo
+%%NLS%%share/locale/sv/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/tr/LC_MESSAGES/%%PG_USER%%-%%PG_VERSION%%.mo
@@ -1027,7 +1027,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/uk/LC_MESSAGES/pg_combinebackup-17.mo
+%%NLS%%share/locale/uk/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -1036,7 +1036,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/uk/LC_MESSAGES/pg_walsummary-17.mo
+%%NLS%%share/locale/uk/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/vi/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
diff --git a/databases/postgresql18-pgtcl/Makefile b/databases/postgresql18-pgtcl/Makefile
index aebc4a84e0b0..6591acc1e610 100644
--- a/databases/postgresql18-pgtcl/Makefile
+++ b/databases/postgresql18-pgtcl/Makefile
@@ -1,7 +1,7 @@
 PORTREVISION=	0
 PKGNAMESUFFIX=	-postgresql18
 
-CONFLICTS=	pgtcl pgtcl-postgresql1[012345689]
+CONFLICTS=	pgtcl pgtcl-postgresql1[0-79]
 
 PGTCL_SLAVE=	18
 MASTERDIR=	${.CURDIR}/../pgtcl
diff --git a/databases/postgresql18-server/Makefile b/databases/postgresql18-server/Makefile
index 8956cebf0fcb..856afdc4af04 100644
--- a/databases/postgresql18-server/Makefile
+++ b/databases/postgresql18-server/Makefile
@@ -1,54 +1,9 @@
-PORTNAME?=	postgresql
-DISTVERSION?=	18.4
+DISTVERSION?=	18.6
 # 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
-CATEGORIES?=	databases
-MASTER_SITES=	PGSQL/source/v${DISTVERSION}
-PKGNAMESUFFIX?= ${PORTVERSION:R}${COMPONENT}
 
 MAINTAINER?=	[email protected]
-COMMENT?=	PostgreSQL is the most advanced open-source database available anywhere
-WWW=		https://www.postgresql.org/
-
-LICENSE=	PostgreSQL
-
-CONFLICTS+=	${PORTNAME}1[^${PORTVERSION:R:C/.*([0-9]$)/\\1/}]*
-
-WRKSRC=		${WRKDIR}/postgresql-${DISTVERSION}
-DIST_SUBDIR=	postgresql
-
-OPTIONS_SUB=	yes
-
-PKGINSTALL?=	${PKGDIR}/pkg-install${COMPONENT}
-USES+=		tar:bzip2 cpe
-.if ${DISTVERSION:C/([0-9][0-9]).*/\1/g} >= 17
-USES+=		bison perl5
-USE_PERL5+=	build
-.endif
-
-.if !defined(NO_BUILD)
-USES+=		gmake
-GNU_CONFIGURE=	yes
-GNU_CONFIGURE_MANPREFIX=${PREFIX}/share
-.endif
-
-PG_USER?=	postgres
-PG_GROUP?=	postgres
-PG_UID?=	770
-
-LDFLAGS+=	-L${LOCALBASE}/lib
-INCLUDES+=	-I${LOCALBASE}/include
-CONFIGURE_ARGS+=--with-libraries=${PREFIX}/lib \
-		--with-includes=${PREFIX}/include \
-		--enable-thread-safety
-CONFIGURE_ENV+=	INCLUDES="${INCLUDES}" \
-		PTHREAD_LIBS="-lpthread" \
-		LDFLAGS_SL="${LDFLAGS_SL}"
-LDFLAGS+=	-lpthread
-MAKE_ENV=	MAKELEVEL=0
-
-PLIST=		${PKGDIR}/pkg-plist${COMPONENT}
 
 INSTALL_DIRS?=	src/common src/timezone src/backend \
 		src/backend/utils/mb/conversion_procs \
@@ -62,199 +17,8 @@ INSTALL_DIRS?=	src/common src/timezone src/backend \
 		src/bin/pg_test_fsync src/bin/pg_test_timing \
 		src/bin/pg_waldump src/bin/pg_walsummary src/bin/pg_upgrade
 
-BUILD_DIRS?=	src/port ${INSTALL_DIRS}
-INSTALL_TARGET?=install-strip
-
-.if !defined(CLIENT_ONLY) && !defined(SLAVE_ONLY)
-SERVER_ONLY=	yes
-COMPONENT=	-server
-USE_RC_SUBR=	postgresql
-USES+=		pgsql:${DISTVERSION:C/([0-9]\.?[0-9]).*/\1/g}
-USERS=		${PG_USER}
-GROUPS=		${PG_GROUP}
-SUB_FILES+=	502.pgsql
-.endif
-
-MAKE_ENV+=	PATH=${PREFIX}/bin:${PATH}
-CONFIGURE_ENV+=	PATH=${PREFIX}/bin:${PATH}
-
-.if defined(SERVER_ONLY)
-OPTIONS_DEFINE=	DTRACE LDAP TZDATA XML DOCS
-OPTIONS_DEFAULT+=XML
-LDAP_DESC=	Build with LDAP authentication support
-TZDATA_DESC=	Use internal timezone database
-XML_DESC=	Build with XML data type
-
-DTRACE_CONFIGURE_ENABLE=dtrace
-DTRACE_LDFLAGS=		-lelf
-DTRACE_INSTALL_TARGET=	install
-
-.  if ${DISTVERSION:C/([0-9][0-9]).*/\1/g} >= 14
-OPTIONS_DEFINE+=	LZ4
-OPTIONS_DEFAULT+=	LZ4
-LZ4_DESC=		Build with LZ4 compression support
-LZ4_CONFIGURE_WITH=	lz4
-LZ4_LIB_DEPENDS+=	liblz4.so:archivers/liblz4
-.  endif
-
-OPTIONS_DEFINE+=	LLVM
-OPTIONS_DEFAULT+=	LLVM
-LLVM_DESC=		Build with support for JIT-compiling expressions
-LLVM_CONFIGURE_WITH=	llvm
-LLVM_CONFIGURE_ENV=	LLVM_CONFIG=${LLVM_CONFIG} \
-			CLANG=${LOCALBASE}/bin/clang${LLVM_VERSION}
-LLVM_USES=		llvm:lib
-
-CONFIGURE_ARGS+=	--with-icu
-LIB_DEPENDS+=		libicudata.so:devel/icu
-USES+=			pkgconfig
-.else
-CONFIGURE_ARGS+=	--without-icu
-.endif
-
-
-.if !defined(SLAVE_ONLY)
-OPTIONS_DEFINE+=	NLS PAM GSSAPI OPTIMIZED_CFLAGS DEBUG DOCS SSL
-NLS_DESC=		Use internationalized messages
-PAM_DESC=		Build with PAM Support
-GSSAPI_DESC=		Build with GSSAPI from base (security/krb5)
-OPTIMIZED_CFLAGS_DESC=	Builds with compiler optimizations (-O3)
-SSL_DESC=		Build with OpenSSL support
-
-OPTIONS_DEFAULT+=	SSL
-
-GSSAPI_USES=		gssapi:mit
-GSSAPI_CONFIGURE_WITH=	gssapi
-
-PATCH_DIST_STRIP=-p1
-.endif # !SLAVE_ONLY
-
-.if defined(SERVER_ONLY) || defined(CLIENT_ONLY) || ${COMPONENT} == "-contrib"
-.  if ${DISTVERSION:C/([0-9][0-9]).*/\1/g} >= 15
-OPTIONS_DEFINE+=	ZSTD
-OPTIONS_DEFAULT+=	ZSTD
-ZSTD_DESC=		Build with ZSTD compression support
-ZSTD_CONFIGURE_WITH=	zstd
-ZSTD_LIB_DEPENDS=	libzstd.so:archivers/zstd
-USES+=			pkgconfig
-.  endif
-.endif
-
-SSL_USES=		ssl
-SSL_CONFIGURE_WITH=	openssl
-
-PAM_CONFIGURE_WITH=	pam
-
-XML_CONFIGURE_WITH=	libxml
-XML_LIB_DEPENDS=	libxml2.so:textproc/libxml2
-
-TZDATA_CONFIGURE_OFF=	--with-system-tzdata=/usr/share/zoneinfo
-
-NLS_CONFIGURE_ENABLE=	nls
-NLS_USES=		gettext
-
-LDAP_CONFIGURE_WITH=	ldap
-LDAP_USES=		ldap
-
-OPTIMIZED_CFLAGS_CFLAGS=-O3 -funroll-loops
-
-DEBUG_CONFIGURE_ENABLE=	debug
-
-PLIST_SUB+=		PG_VERSION=${PORTVERSION:R} \
-			PG_USER=${PG_USER} \
-			PG_USER_regex=[[:<:]]${PG_USER}[[:>:]] \
-			PG_GROUP=${PG_GROUP} \
-			PG_GROUP_regex=[[:<:]]${PG_GROUP}[[:>:]]
-SUB_LIST+=		PG_VERSION=${PORTVERSION:R} \
-			PG_GROUP=${PG_GROUP} \
-			PG_USER=${PG_USER} \
-			PG_UID=${PG_UID}
-
-.include <bsd.port.options.mk>
-
-# i386 older than Pentium lacks SSE2 so the binary will not run if we build with clang -msse2
-# For such ancient CPUs, gcc must be used to build PostgreSQL.
-# https://www.postgresql.org/message-id/20190307140421.GA8362%40gate.oper.dinoex.org
-.if ${ARCH} == "i386"
-CFLAGS+=	-msse2
-.endif
-
-# For testing files in FILESDIR
-.include <bsd.port.pre.mk>
-
-.if ${PORT_OPTIONS:MLLVM}
-INSTALL_DIRS+=		src/backend/jit/llvm
-.endif
-
-.if defined(SERVER_ONLY)
-pre-build:
-	@${SH} ${PKGINSTALL} ${PORTNAME} PRE-INSTALL
-.endif
-
-.if !defined(NO_BUILD) && !target(do-build)
-
-do-build:
-	@ cd ${WRKSRC}/src/backend && ${SETENVI} ${WRK_ENV} ${MAKE_ENV} ${MAKE_CMD} generated-headers
-	@ for dir in ${BUILD_DIRS}; do \
-		cd ${WRKSRC}/$${dir} && ${SETENVI} ${WRK_ENV} ${MAKE_ENV} ${MAKE_CMD} ; \
-	done
-.  if defined(CLIENT_ONLY)
-.    if ${DISTVERSION:C/([0-9][0-9]).*/\1/g} >= 17
-	@ cd ${WRKSRC}/doc && ${SETENVI} ${WRK_ENV} ${MAKE_ENV} ${MAKE_CMD} man
-.    endif
-.  endif
-.  if exists(${FILESDIR}/pkg-message${COMPONENT}.in)
-SUB_FILES+=	pkg-message${COMPONENT}
-PKGMESSAGE=	${WRKSRC}/pkg-message${COMPONENT}
-.  endif
-.  if exists(${FILESDIR}/pkg-install${COMPONENT}.in)
-SUB_FILES+=	pkg-install${COMPONENT}
-.  endif
-
-post-patch:
-.  if defined(CLIENT_ONLY) && !defined(OPENSSL_PORT)
-	@${REINPLACE_CMD} \
-		-e '/^PKG_CONFIG_REQUIRES_PRIVATE = libssl libcrypto/d' \
-		${WRKSRC}/src/interfaces/libpq/Makefile
-.  endif
-
-do-install:
-	for dir in ${INSTALL_DIRS}; do \
-	    cd ${WRKSRC}/$${dir} && \
-		${SETENVI} ${WRK_ENV} ${MAKE_ENV} ${MAKE_CMD} ${MAKE_ARGS} ${INSTALL_TARGET}; \
-	done
-.  if defined(SERVER_ONLY)
-	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/*.so
-	${MKDIR} ${STAGEDIR}${PREFIX}/share/postgresql
-	${MKDIR} ${STAGEDIR}${PREFIX}/etc/periodic/daily
-	${INSTALL_SCRIPT} ${WRKDIR}/502.pgsql \
-			${STAGEDIR}${PREFIX}/etc/periodic/daily
-.  endif # SERVER_ONLY
-.  if defined(CLIENT_ONLY)
-	${STRIP_CMD} ${STAGEDIR}${PREFIX}/bin/* ${STAGEDIR}${PREFIX}/lib/lib*.so
-	cd ${WRKSRC}/src && ${SETENVI} ${WRK_ENV} ${MAKE_ENV} ${MAKE_CMD} ${MAKE_ARGS} install-local
-.    if ${DISTVERSION:C/([0-9][0-9]).*/\1/g} >= 17
-	cd ${WRKSRC}/doc/src/sgml && ${COPYTREE_SHARE} "man1 man3 man7" ${STAGEDIR}${PREFIX}/share/man
-.    endif
-.  endif
-.  if defined(SLAVE_ONLY)
-	${STRIP_CMD} ${STAGEDIR}${PREFIX}/lib/postgresql/*.so
-.  endif
-	if [ -r ${PKGMESSAGE} ]; then \
-		${MKDIR} ${STAGEDIR}${DOCSDIR} ;\
-		${INSTALL_DATA} ${PKGMESSAGE} ${STAGEDIR}${DOCSDIR}/README${COMPONENT} ;\
-	fi
-.endif # !NO_BUILD
-
-.if defined(SERVER_ONLY)
-check:
-	@if [ `id -u` != 0 ] ; then \
-	  ${ECHO} "Running postgresql regressions tests" ;\
-	  cd ${WRKSRC}; ${MAKE_CMD} check ;\
-	 else \
-	  ${ECHO} "You cannot run regression tests when postgresql is built as user root." ; \
-	  ${ECHO} "Clean and rebuild the port as a regular user to run the tests." ;\
-	 fi
-.endif
+PG_USER?=	postgres
+PG_GROUP?=	postgres
+PG_UID?=	770
 
-.include <bsd.port.post.mk>
+.include "${.CURDIR}/../postgresql19-server/Makefile"
diff --git a/databases/postgresql18-server/distinfo b/databases/postgresql18-server/distinfo
index 815c39b55688..1135279b3830 100644
--- a/databases/postgresql18-server/distinfo
+++ b/databases/postgresql18-server/distinfo
@@ -1,3 +1,3 @@
-TIMESTAMP = 1778599535
-SHA256 (postgresql/postgresql-18.4.tar.bz2) = 81a81ec695fb0c7901407defaa1d2f7973617154cf27ba74e3a7ab8e64436094
-SIZE (postgresql/postgresql-18.4.tar.bz2) = 22567173
+TIMESTAMP = 1786479543
+SHA256 (postgresql/postgresql-18.6.tar.bz2) = 555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
+SIZE (postgresql/postgresql-18.6.tar.bz2) = 22632314
diff --git a/databases/postgresql18-server/pkg-plist-server b/databases/postgresql18-server/pkg-plist-server
index 258ce70bfd40..4cbb5f4b2bdd 100644
--- a/databases/postgresql18-server/pkg-plist-server
+++ b/databases/postgresql18-server/pkg-plist-server
@@ -859,7 +859,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/de/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/de/LC_MESSAGES/pg_combinebackup-18.mo
+%%NLS%%share/locale/de/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -868,7 +868,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/de/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/de/LC_MESSAGES/pg_walsummary-18.mo
+%%NLS%%share/locale/de/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/de/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/el/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
@@ -887,7 +887,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/es/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/es/LC_MESSAGES/pg_combinebackup-18.mo
+%%NLS%%share/locale/es/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -896,14 +896,14 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/es/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/es/LC_MESSAGES/pg_walsummary-18.mo
+%%NLS%%share/locale/es/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/es/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/fr/LC_MESSAGES/pg_combinebackup-18.mo
+%%NLS%%share/locale/fr/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -912,7 +912,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/fr/LC_MESSAGES/pg_walsummary-18.mo
+%%NLS%%share/locale/fr/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/fr/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/he/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
@@ -936,7 +936,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ja/LC_MESSAGES/pg_combinebackup-18.mo
+%%NLS%%share/locale/ja/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -945,14 +945,14 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ja/LC_MESSAGES/pg_walsummary-18.mo
+%%NLS%%share/locale/ja/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ja/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ka/LC_MESSAGES/pg_combinebackup-18.mo
+%%NLS%%share/locale/ka/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -961,14 +961,14 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ka/LC_MESSAGES/pg_walsummary-18.mo
+%%NLS%%share/locale/ka/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ka/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ko/LC_MESSAGES/pg_combinebackup-18.mo
+%%NLS%%share/locale/ko/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -977,7 +977,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ko/LC_MESSAGES/pg_walsummary-18.mo
+%%NLS%%share/locale/ko/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ko/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/pl/LC_MESSAGES/%%PG_USER%%-%%PG_VERSION%%.mo
@@ -1008,7 +1008,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ru/LC_MESSAGES/pg_combinebackup-18.mo
+%%NLS%%share/locale/ru/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -1017,14 +1017,14 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/ru/LC_MESSAGES/pg_walsummary-18.mo
+%%NLS%%share/locale/ru/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/ru/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/sv/LC_MESSAGES/pg_combinebackup-18.mo
+%%NLS%%share/locale/sv/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -1033,7 +1033,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/sv/LC_MESSAGES/pg_walsummary-18.mo
+%%NLS%%share/locale/sv/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/sv/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/tr/LC_MESSAGES/%%PG_USER%%-%%PG_VERSION%%.mo
@@ -1054,7 +1054,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_archivecleanup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_basebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_checksums-%%PG_VERSION%%.mo
-%%NLS%%share/locale/uk/LC_MESSAGES/pg_combinebackup-18.mo
+%%NLS%%share/locale/uk/LC_MESSAGES/pg_combinebackup-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_controldata-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_ctl-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_resetwal-%%PG_VERSION%%.mo
@@ -1063,7 +1063,7 @@ lib/postgresql/utf8_and_win.so
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_test_timing-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_upgrade-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/pg_waldump-%%PG_VERSION%%.mo
-%%NLS%%share/locale/uk/LC_MESSAGES/pg_walsummary-18.mo
+%%NLS%%share/locale/uk/LC_MESSAGES/pg_walsummary-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/plpgsql-%%PG_VERSION%%.mo
 %%NLS%%share/locale/uk/LC_MESSAGES/postgres-%%PG_VERSION%%.mo
 %%NLS%%share/locale/vi/LC_MESSAGES/initdb-%%PG_VERSION%%.mo
diff --git a/databases/postgresql19-client/Makefile b/databases/postgresql19-client/Makefile
new file mode 100644
index 000000000000..b2e56d028b14
--- /dev/null
+++ b/databases/postgresql19-client/Makefile
@@ -0,0 +1,28 @@
+PORTNAME=	postgresql
+PORTREVISION=	0
+
+COMMENT=	PostgreSQL database (client)
+
+MASTERDIR=	${.CURDIR}/../postgresql19-server
+
+BUILD_DIRS=	config src/include src/interfaces src/port src/fe_utils src/bin/pg_amcheck \
+		src/bin/pg_dump src/bin/psql src/bin/scripts src/bin/pg_config \
+		src/bin/pgbench src/makefiles src/test/regress
+INSTALL_DIRS=	${BUILD_DIRS}
+
+CLIENT_ONLY=	yes
+COMPONENT=	-client
+USE_LDCONFIG=	yes
+USES=		pkgconfig
+
+OPTIONS_DEFINE+=LIBEDIT DOCS
+LIBEDIT_DESC=	Use non-GPL libedit instead of readline
+LIBEDIT_CONFIGURE_ON+=--with-libedit-preferred
+LIBEDIT_USES=	libedit
+LIBEDIT_USES_OFF=readline
+BUILD_DEPENDS+=	docbook-xml>0:textproc/docbook-xml \
+		docbook-xsl>=0:textproc/docbook-xsl \
+		xmllint:textproc/libxml2 \
+		xsltproc:textproc/libxslt
+
+.include "${MASTERDIR}/Makefile"
diff --git a/databases/postgresql19-contrib/Makefile b/databases/postgresql19-contrib/Makefile
new file mode 100644
index 000000000000..aeff55325262
--- /dev/null
+++ b/databases/postgresql19-contrib/Makefile
@@ -0,0 +1,41 @@
+PORTNAME=	postgresql
+PORTREVISION=	0
+CATEGORIES=	databases
+
+MAINTAINER=	[email protected]
+COMMENT=	The contrib utilities from the PostgreSQL distribution
+
+MASTERDIR=	${.CURDIR}/../postgresql19-server
+
+USES=		bison pgsql:${PORTVERSION:R}
+
+BUILD_DIRS=	src/port src/include src/common contrib
+INSTALL_DIRS=	contrib
+
+# this port fails to build in parallel
+MAKE_JOBS_UNSAFE=	yes
+
+SLAVE_ONLY=	yes
+COMPONENT=	-contrib
+CONFIGURE_ARGS=	--disable-nls --with-uuid=bsd
+LDFLAGS+=	-lpthread -L${PREFIX}/lib
+
+OPTIONS_DEFINE=	DOCS OPENSSL XML
+OPTIONS_DEFAULT=OPENSSL XML
+OPTIONS_SUB=	yes
+
+OPENSSL_DESC=		Build with OpenSSL support
+OPENSSL_USES=		ssl
+OPENSSL_CONFIGURE_WITH=	openssl
+
+XML_CONFIGURE_WITH=	libxslt libxml
+XML_LIB_DEPENDS=libxslt.so:textproc/libxslt \
+		libxml2.so:textproc/libxml2
+
+post-configure:
+	@cd ${WRKSRC}/src/backend && ${SETENVI} ${WRK_ENV} ${MAKE_ENV} ${MAKE_CMD} generated-headers
+
+post-install:
+	@- ${INSTALL_DATA} ${WRKSRC}/contrib/README ${STAGEDIR}${DOCSDIR}/extension/README
+
+.include "${MASTERDIR}/Makefile"
diff --git a/databases/postgresql19-contrib/pkg-descr b/databases/postgresql19-contrib/pkg-descr
new file mode 100644
index 000000000000..a384c76fdbde
--- /dev/null
+++ b/databases/postgresql19-contrib/pkg-descr
@@ -0,0 +1,21 @@
+This is the port for all stuff that comes in the contrib subtree of
+the postgresql distribution. This subtree contains porting tools,
+analysis utilities, and plug-in features that are not part of the core
+PostgreSQL system, mainly because they address a limited audience or
+are too experimental to be part of the main source tree.  This does
+not preclude their usefulness.
+
+Each subdirectory contains a README file with information about the
+module. Some directories supply new user-defined functions, operators,
+or types.  After you have installed the files you need to register the
+new entities in the database system by running the commands in the
+supplied .sql file.  For example,
+
+        $ psql -d dbname -f module.sql
+
+The .sql files are installed into /usr/local/share/postgresql/contrib
+
+For more information, please see
+/usr/local/share/doc/postgresql/contrib/README*
+
+This software is part of the standard PostgreSQL distribution.
diff --git a/databases/postgresql19-docs/Makefile b/databases/postgresql19-docs/Makefile
new file mode 100644
index 000000000000..ed0e571adf3d
--- /dev/null
+++ b/databases/postgresql19-docs/Makefile
@@ -0,0 +1,38 @@
+PORTNAME=	postgresql
+PORTREVISION=	0
+PKGNAMESUFFIX?=	${WANT_PGSQL_VER:S,.,,}-docs
+
+MAINTAINER=	[email protected]
+COMMENT=	The PostgreSQL documentation set
+
+MASTERDIR=	${.CURDIR}/../../databases/postgresql${WANT_PGSQL_VER}-server
*** 4629 LINES SKIPPED ***
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.