diff --git a/databases/postgresql13-server/Makefile b/databases/postgresql13-server/Makefile index 07b2113be886..a0805de6034c 100644 --- a/databases/postgresql13-server/Makefile +++ b/databases/postgresql13-server/Makefile @@ -1,24 +1,27 @@ -DISTVERSION?= 13.22 +DISTVERSION?= 13.23 # 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 MAINTAINER?= pgsql@FreeBSD.org INSTALL_DIRS?= src/common src/timezone src/backend \ src/backend/utils/mb/conversion_procs \ src/backend/snowball src/backend/replication/libpqwalreceiver \ src/backend/replication/pgoutput \ src/bin/initdb src/bin/pg_ctl \ src/bin/pg_archivecleanup src/bin/pg_basebackup \ src/bin/pg_checksums \ src/bin/pg_controldata src/bin/pg_resetwal src/pl \ src/bin/pg_rewind \ src/bin/pg_test_fsync src/bin/pg_test_timing \ src/bin/pg_waldump src/bin/pg_upgrade PG_USER?= postgres PG_GROUP?= postgres PG_UID?= 770 +DEPRECATED= This is the final release of PostgreSQL 13. PostgreSQL 13 is now end-of-life and will no longer receive security and bug fixes. +EXPIRATION_DATE=2026-02-12 + .include "${.CURDIR}/../postgresql18-server/Makefile" diff --git a/databases/postgresql13-server/distinfo b/databases/postgresql13-server/distinfo index 2920b5bae795..654998280785 100644 --- a/databases/postgresql13-server/distinfo +++ b/databases/postgresql13-server/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1755094737 -SHA256 (postgresql/postgresql-13.22.tar.bz2) = d36d83dc89e625502cf6fb1d0529642ba1266bd614b4e4a41cefd1dddcf09080 -SIZE (postgresql/postgresql-13.22.tar.bz2) = 21783034 +TIMESTAMP = 1762876340 +SHA256 (postgresql/postgresql-13.23.tar.bz2) = 6ec3c82726af92b7dec873fa1cdf881eca92a4219787dfad05acb6b10e041fd6 +SIZE (postgresql/postgresql-13.23.tar.bz2) = 21767253 diff --git a/databases/postgresql14-server/Makefile b/databases/postgresql14-server/Makefile index 0b7b0fbea429..0e2bbc354a02 100644 --- a/databases/postgresql14-server/Makefile +++ b/databases/postgresql14-server/Makefile @@ -1,24 +1,24 @@ -DISTVERSION?= 14.19 +DISTVERSION?= 14.20 # 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 MAINTAINER?= pgsql@FreeBSD.org INSTALL_DIRS?= src/common src/timezone src/backend \ src/backend/utils/mb/conversion_procs \ src/backend/snowball src/backend/replication/libpqwalreceiver \ src/backend/replication/pgoutput \ src/bin/initdb src/bin/pg_ctl \ src/bin/pg_archivecleanup src/bin/pg_basebackup \ src/bin/pg_checksums \ src/bin/pg_controldata src/bin/pg_resetwal src/pl \ src/bin/pg_rewind \ src/bin/pg_test_fsync src/bin/pg_test_timing \ src/bin/pg_waldump src/bin/pg_upgrade PG_USER?= postgres PG_GROUP?= postgres PG_UID?= 770 .include "${.CURDIR}/../postgresql18-server/Makefile" diff --git a/databases/postgresql14-server/distinfo b/databases/postgresql14-server/distinfo index 539f677b0dc7..90c8b25e0b51 100644 --- a/databases/postgresql14-server/distinfo +++ b/databases/postgresql14-server/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1755094738 -SHA256 (postgresql/postgresql-14.19.tar.bz2) = 727e9e334bc1a31940df808259f69fe47a59f6d42174b22ae62d67fe7a01ad80 -SIZE (postgresql/postgresql-14.19.tar.bz2) = 22517457 +TIMESTAMP = 1762876341 +SHA256 (postgresql/postgresql-14.20.tar.bz2) = 7527f10f1640761bc280ad97d105d286d0cf72e54d36d78cf68e5e5f752b646b +SIZE (postgresql/postgresql-14.20.tar.bz2) = 22525029 diff --git a/databases/postgresql15-server/Makefile b/databases/postgresql15-server/Makefile index e950d4e41615..95626156d1a8 100644 --- a/databases/postgresql15-server/Makefile +++ b/databases/postgresql15-server/Makefile @@ -1,24 +1,24 @@ -DISTVERSION?= 15.14 +DISTVERSION?= 15.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 MAINTAINER?= pgsql@FreeBSD.org INSTALL_DIRS?= src/common src/timezone src/backend \ src/backend/utils/mb/conversion_procs \ src/backend/snowball src/backend/replication/libpqwalreceiver \ src/backend/replication/pgoutput \ src/bin/initdb src/bin/pg_ctl \ src/bin/pg_archivecleanup src/bin/pg_basebackup \ src/bin/pg_checksums \ src/bin/pg_controldata src/bin/pg_resetwal src/pl \ src/bin/pg_rewind \ src/bin/pg_test_fsync src/bin/pg_test_timing \ src/bin/pg_waldump src/bin/pg_upgrade PG_USER?= postgres PG_GROUP?= postgres PG_UID?= 770 .include "${.CURDIR}/../postgresql18-server/Makefile" diff --git a/databases/postgresql15-server/distinfo b/databases/postgresql15-server/distinfo index 4e815a7c0626..c3992a37fcd7 100644 --- a/databases/postgresql15-server/distinfo +++ b/databases/postgresql15-server/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1755094739 -SHA256 (postgresql/postgresql-15.14.tar.bz2) = 06dd75d305cd3870ee62b3932e661c624543eaf9ae2ba37cdec0a4f8edd051d2 -SIZE (postgresql/postgresql-15.14.tar.bz2) = 23229854 +TIMESTAMP = 1762876342 +SHA256 (postgresql/postgresql-15.15.tar.bz2) = 5753aaeb8b09cbf61016f78aa69bf5cbdf01b43263f010cbf168c82896213aaa +SIZE (postgresql/postgresql-15.15.tar.bz2) = 23246368 diff --git a/databases/postgresql16-server/Makefile b/databases/postgresql16-server/Makefile index d4c26262a6b7..8943a137b190 100644 --- a/databases/postgresql16-server/Makefile +++ b/databases/postgresql16-server/Makefile @@ -1,24 +1,24 @@ -DISTVERSION?= 16.10 +DISTVERSION?= 16.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 MAINTAINER?= pgsql@FreeBSD.org INSTALL_DIRS?= src/common src/timezone src/backend \ src/backend/utils/mb/conversion_procs \ src/backend/snowball src/backend/replication/libpqwalreceiver \ src/backend/replication/pgoutput \ src/bin/initdb src/bin/pg_ctl \ src/bin/pg_archivecleanup src/bin/pg_basebackup \ src/bin/pg_checksums \ src/bin/pg_controldata src/bin/pg_resetwal src/pl \ src/bin/pg_rewind \ src/bin/pg_test_fsync src/bin/pg_test_timing \ src/bin/pg_waldump src/bin/pg_upgrade PG_USER?= postgres PG_GROUP?= postgres PG_UID?= 770 .include "${.CURDIR}/../postgresql18-server/Makefile" diff --git a/databases/postgresql16-server/distinfo b/databases/postgresql16-server/distinfo index 6ecd7bbec6aa..947bab638767 100644 --- a/databases/postgresql16-server/distinfo +++ b/databases/postgresql16-server/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1755094740 -SHA256 (postgresql/postgresql-16.10.tar.bz2) = de8485f4ce9c32e3ddfeef0b7c261eed1cecb54c9bcd170e437ff454cb292b42 -SIZE (postgresql/postgresql-16.10.tar.bz2) = 24977722 +TIMESTAMP = 1762876343 +SHA256 (postgresql/postgresql-16.11.tar.bz2) = 6deb08c23d03d77d8f8bd1c14049eeef64aef8968fd8891df2dfc0b42f178eac +SIZE (postgresql/postgresql-16.11.tar.bz2) = 25005349 diff --git a/databases/postgresql17-server/Makefile b/databases/postgresql17-server/Makefile index 6bd13e163497..be8bd64716ce 100644 --- a/databases/postgresql17-server/Makefile +++ b/databases/postgresql17-server/Makefile @@ -1,24 +1,24 @@ -DISTVERSION?= 17.6 +DISTVERSION?= 17.7 # 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 MAINTAINER?= pgsql@FreeBSD.org INSTALL_DIRS?= src/common src/timezone src/backend \ src/backend/utils/mb/conversion_procs \ src/backend/snowball src/backend/replication/libpqwalreceiver \ src/backend/replication/pgoutput \ src/bin/initdb src/bin/pg_ctl \ src/bin/pg_archivecleanup src/bin/pg_basebackup \ src/bin/pg_checksums src/bin/pg_combinebackup \ src/bin/pg_controldata src/bin/pg_resetwal src/pl \ src/bin/pg_rewind \ src/bin/pg_test_fsync src/bin/pg_test_timing \ src/bin/pg_waldump src/bin/pg_walsummary src/bin/pg_upgrade PG_USER?= postgres PG_GROUP?= postgres PG_UID?= 770 .include "${.CURDIR}/../postgresql18-server/Makefile" diff --git a/databases/postgresql17-server/distinfo b/databases/postgresql17-server/distinfo index 2fabee2e9842..ef4871784fe5 100644 --- a/databases/postgresql17-server/distinfo +++ b/databases/postgresql17-server/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1755094741 -SHA256 (postgresql/postgresql-17.6.tar.bz2) = e0630a3600aea27511715563259ec2111cd5f4353a4b040e0be827f94cd7a8b0 -SIZE (postgresql/postgresql-17.6.tar.bz2) = 21623975 +TIMESTAMP = 1762876344 +SHA256 (postgresql/postgresql-17.7.tar.bz2) = ef9e343302eccd33112f1b2f0247be493cb5768313adeb558b02de8797a2e9b5 +SIZE (postgresql/postgresql-17.7.tar.bz2) = 21646334 diff --git a/databases/postgresql18-server/Makefile b/databases/postgresql18-server/Makefile index 8d3202ae3cdb..4ca76d33a1d6 100644 --- a/databases/postgresql18-server/Makefile +++ b/databases/postgresql18-server/Makefile @@ -1,255 +1,255 @@ PORTNAME?= postgresql -DISTVERSION?= 18.0 +DISTVERSION?= 18.1 # 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?= pgsql@FreeBSD.org 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 \ src/backend/snowball src/backend/replication/libpqwalreceiver \ src/backend/replication/pgoutput \ src/bin/initdb src/bin/pg_ctl \ src/bin/pg_archivecleanup src/bin/pg_basebackup \ src/bin/pg_checksums src/bin/pg_combinebackup \ src/bin/pg_controldata src/bin/pg_resetwal src/pl \ src/bin/pg_rewind \ 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:min=11,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 # 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 .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) @ ${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) @ 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 [ -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 .include diff --git a/databases/postgresql18-server/distinfo b/databases/postgresql18-server/distinfo index 93ee9750257f..eb9888fe8e16 100644 --- a/databases/postgresql18-server/distinfo +++ b/databases/postgresql18-server/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1758615221 -SHA256 (postgresql/postgresql-18.0.tar.bz2) = 0d5b903b1e5fe361bca7aa9507519933773eb34266b1357c4e7780fdee6d6078 -SIZE (postgresql/postgresql-18.0.tar.bz2) = 22412570 +TIMESTAMP = 1762876345 +SHA256 (postgresql/postgresql-18.1.tar.bz2) = ff86675c336c46e98ac991ebb306d1b67621ece1d06787beaade312c2c915d54 +SIZE (postgresql/postgresql-18.1.tar.bz2) = 22423920