diff options
Diffstat (limited to 'databases/postgresql15-server')
13 files changed, 366 insertions, 680 deletions
diff --git a/databases/postgresql15-server/Makefile b/databases/postgresql15-server/Makefile index a44c1093df4b..e950d4e41615 100644 --- a/databases/postgresql15-server/Makefile +++ b/databases/postgresql15-server/Makefile @@ -1,48 +1,9 @@ -PORTNAME?= postgresql -DISTVERSION?= 15.3 +DISTVERSION?= 15.14 # 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 !defined(NO_BUILD) -USES+= gmake -GNU_CONFIGURE= yes -.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 \ @@ -56,282 +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_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 - -OPTIONS_SUB= yes - -.if defined(CLIENT_ONLY) -OPTIONS_DEFINE+=LIBEDIT DOCS -LIBEDIT_DESC= Use non-GPL libedit instead of readline -.else -MAKE_ENV+= PATH=${PREFIX}/bin:${PATH} -CONFIGURE_ENV+= PATH=${PREFIX}/bin:${PATH} -.endif - -.if defined(SERVER_ONLY) -OPTIONS_DEFINE= DTRACE LDAP INTDATE TZDATA XML DOCS -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 - -.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 -.endif - -.if ${DISTVERSION:C/([0-9][0-9]).*/\1/g} >= 11 -OPTIONS_DEFINE+= LLVM -OPTIONS_DEFAULT+= LLVM -LLVM_DESC= Build with support for JIT-compiling expressions -OPTIONS_EXCLUDE+= ${OPTIONS_EXCLUDE_${ARCH}_${OSREL:R}} -OPTIONS_EXCLUDE_powerpc64_12= LLVM -.endif - -CONFIGURE_ARGS+=--with-icu -LIB_DEPENDS+= libicudata.so:devel/icu -USES+= pkgconfig - -# See http://www.freebsd.org/cgi/query-pr.cgi?pr=ports/76999 for more info -# (requires dump/restore if modified.) -OPTIONS_DEFINE+= INTDATE -INTDATE_DESC= Builds with 64-bit date/time type -OPTIONS_DEFAULT+= INTDATE -.endif - -.if !defined(SLAVE_ONLY) -OPTIONS_DEFINE+= NLS PAM GSSAPI OPTIMIZED_CFLAGS DEBUG DOCS -KRB5_DESC= Build with kerberos provider support -NLS_DESC= Use internationalized messages -PAM_DESC= Build with PAM Support -MIT_KRB5_DESC= Build with MIT kerberos support -HEIMDAL_KRB5_DESC= Builds with Heimdal kerberos -GSSAPI_DESC= Build with GSSAPI support -OPTIMIZED_CFLAGS_DESC= Builds with compiler optimizations (-O3) - -OPTIONS_DEFINE+= SSL -SSL_DESC= Build with OpenSSL support - -OPTIONS_DEFAULT+= SSL - -GSSAPI_CONFIGURE_WITH= gssapi -.endif # !SLAVE_ONLY - -.if defined(CLIENT_ONLY) -LIBEDIT_CONFIGURE_ON+=--with-libedit-preferred -LIBEDIT_USES= libedit -LIBEDIT_USES_OFF= readline -.endif # CLIENT_ONLY - -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 - -INTDATE_CONFIGURE_OFF= --disable-integer-datetimes - -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> - -.if ${ARCH} == "i386" -USES+= compiler:gcc-c++11-lib -.else -USES+= compiler -.endif - -.if !defined(SLAVE_ONLY) - -PATCH_DIST_STRIP=-p1 - -.if ${PORT_OPTIONS:MGSSAPI} -.if empty(PORT_OPTIONS:MMIT_KRB5) && empty(PORT_OPTIONS:MHEIMDAL_KRB5) -# Kerberos libraries will pull the proper GSSAPI library -# via linker dependencies, but otherwise we must specify -# it explicitely: ld --as-needed is used for compilation, -# so configure's -lgssapi_krb5 won't go. -LDFLAGS+= -lgssapi -LDFLAGS_SL+= -lgssapi -.endif -.endif - -. if ${PORT_OPTIONS:MMIT_KRB5} -. if defined(IGNORE_WITH_SRC_KRB5) && (exists(/usr/lib/libkrb5.so) || exists(/usr/bin/krb5-config)) -IGNORE= requires that you remove heimdal\'s /usr/bin/krb5-config and /usr/lib/libkrb5.so*, and set NO_KERBEROS=true in /etc/src.conf to build successfully with MIT-KRB -. else -CONFIGURE_ARGS+=--with-krb5 -# Allow defining a home built MIT Kerberos by setting KRB5_HOME -. if defined(KRB5_HOME) && exists(${KRB5_HOME}/lib/libgssapi_krb5.a) && exists(${KRB5_HOME}/bin/krb5-config) -LIB_DEPENDS+= libkrb5.so.3:security/krb5 -. endif -. endif -. endif - -. if ${PORT_OPTIONS:MHEIMDAL_KRB5} -CONFIGURE_ARGS+=--with-krb5 -. endif - -.endif # !SLAVE_ONLY - -# For testing files in FILESDIR -.include <bsd.port.pre.mk> - -.if ${PORT_OPTIONS:MLLVM} -CONFIGURE_ARGS+= --with-llvm -BUILD_DEPENDS+= llvm${PG_LLVM_VERSION}>0:devel/llvm${PG_LLVM_VERSION} -BUILD_DEPENDS+= llvm-config${PG_LLVM_VERSION}:devel/llvm${PG_LLVM_VERSION} -RUN_DEPENDS+= llvm-config${PG_LLVM_VERSION}:devel/llvm${PG_LLVM_VERSION} -CONFIGURE_ENV+= LLVM_CONFIG=${LOCALBASE}/bin/llvm-config${PG_LLVM_VERSION} -.endif - -# Convert LLVM_DEFAULT to COMPILER_VERSION format to make it -# suitable for version comparison. -.if ${LLVM_DEFAULT} >= 70 && ${LLVM_DEFAULT} <= 90 -LLVM_DEFAULT_VERSION= ${LLVM_DEFAULT} -.else -LLVM_DEFAULT_VERSION= ${LLVM_DEFAULT}0 -.endif - -# Convert COMPILER_VERSION to LLVM_DEFAULT format to make it -# suitable for LLVM port name. -# All supported FreeBSD versions have Clang 10.0.1 or later. -LLVM_PORT_SUFFIX= ${COMPILER_VERSION:C/.$//} - -# sync LLVM to the preferred compiler if possible -# or else use a lower version compiler that is compatible -.if ${COMPILER_VERSION} > ${LLVM_DEFAULT_VERSION} -# LLVM versions in ports are, in order, 70, 80 90, 10, 11, 12... where 10 > 90. [sic] -. if ${LLVM_PORT_SUFFIX} < 70 -PG_LLVM_VERSION=${LLVM_PORT_SUFFIX} -PG_COMPILER_VERSION=${LLVM_PORT_SUFFIX} -. else -PG_LLVM_VERSION=11 -PG_COMPILER_VERSION=11 -. endif -.else -PG_LLVM_VERSION=${LLVM_DEFAULT} -PG_COMPILER_VERSION=${LLVM_PORT_SUFFIX} -.endif - -.if ${DISTVERSION:C/([0-9]*).*/\1/} >= 11 -. if defined(SERVER_ONLY) && ${PORT_OPTIONS:MLLVM} -INSTALL_DIRS+= src/backend/jit/llvm -. if ${LLVM_PORT_SUFFIX} != ${PG_COMPILER_VERSION} -LLVM_CONFIGURE_ARGS?= CC=${LOCALBASE}/bin/clang${PG_COMPILER_VERSION} -. endif -. endif -.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 && ${SETENV} ${MAKE_ENV} ${MAKE_CMD} symlinks - @ for dir in ${BUILD_DIRS}; do \ - cd ${WRKSRC}/$${dir} && ${SETENV} ${MAKE_ENV} ${MAKE_CMD} ; \ - done - -. 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(SERVER_ONLY) && ${PORT_OPTIONS:MICU} - @${REINPLACE_CMD} \ - -e '/m4_PACKAGE_VERSION/s/\[2\.6[0-9]\]/m4_defn([m4_PACKAGE_VERSION])/' \ - -e '/icu/s/_57//' \ - ${WRKSRC}/configure.in -. elif 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} && \ - ${SETENV} ${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 && ${SETENV} ${MAKE_ENV} ${MAKE_CMD} ${MAKE_ARGS} install-local -. 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}/../postgresql18-server/Makefile" diff --git a/databases/postgresql15-server/distinfo b/databases/postgresql15-server/distinfo index 96b03c9c614f..4e815a7c0626 100644 --- a/databases/postgresql15-server/distinfo +++ b/databases/postgresql15-server/distinfo @@ -1,3 +1,3 @@ -TIMESTAMP = 1683631078 -SHA256 (postgresql/postgresql-15.3.tar.bz2) = ffc7d4891f00ffbf5c3f4eab7fbbced8460b8c0ee63c5a5167133b9e6599d932 -SIZE (postgresql/postgresql-15.3.tar.bz2) = 22819107 +TIMESTAMP = 1755094739 +SHA256 (postgresql/postgresql-15.14.tar.bz2) = 06dd75d305cd3870ee62b3932e661c624543eaf9ae2ba37cdec0a4f8edd051d2 +SIZE (postgresql/postgresql-15.14.tar.bz2) = 23229854 diff --git a/databases/postgresql15-server/files/patch-disable-llvm-jit-inlining-with-tls b/databases/postgresql15-server/files/patch-disable-llvm-jit-inlining-with-tls deleted file mode 100644 index 02686061ce99..000000000000 --- a/databases/postgresql15-server/files/patch-disable-llvm-jit-inlining-with-tls +++ /dev/null @@ -1,24 +0,0 @@ -Do not inline functions which access TLS in LLVM JIT, as -this leads to crashes with unsupported relocation error - -diff --git src/backend/jit/llvm/llvmjit_inline.cpp src/backend/jit/llvm/llvmjit_inline.cpp -index 2617a46..a063edb 100644 ---- src/backend/jit/llvm/llvmjit_inline.cpp -+++ src/backend/jit/llvm/llvmjit_inline.cpp -@@ -608,6 +608,16 @@ function_inlinable(llvm::Function &F, - if (rv->materialize()) - elog(FATAL, "failed to materialize metadata"); - -+ /* -+ * Don't inline functions with thread-local variables until -+ * related crashes are investigated (see BUG #16696) -+ */ -+ if (rv->isThreadLocal()) { -+ ilog(DEBUG1, "cannot inline %s due to thread-local variable %s", -+ F.getName().data(), rv->getName().data()); -+ return false; -+ } -+ - /* - * Never want to inline externally visible vars, cheap enough to - * reference. diff --git a/databases/postgresql15-server/files/patch-src_backend_utils_misc_postgresql.conf.sample b/databases/postgresql15-server/files/patch-src_backend_utils_misc_postgresql.conf.sample index a82826b3b5f1..9469421174a0 100644 --- a/databases/postgresql15-server/files/patch-src_backend_utils_misc_postgresql.conf.sample +++ b/databases/postgresql15-server/files/patch-src_backend_utils_misc_postgresql.conf.sample @@ -8,14 +8,3 @@ #log_destination = 'stderr' # Valid values are combinations of # stderr, csvlog, syslog, and eventlog, # depending on platform. csvlog -@@ -464,7 +465,9 @@ - - #cluster_name = '' # added to process titles if nonempty - # (change requires restart) --#update_process_title = on -+ -+# On FreeBSD, this is a performance hog, so keep it off if you need speed -+update_process_title = off - - - #------------------------------------------------------------------------------ diff --git a/databases/postgresql15-server/files/pkg-message-client.in b/databases/postgresql15-server/files/pkg-message-client.in index 8cc91d484fcb..bb0ecefef696 100644 --- a/databases/postgresql15-server/files/pkg-message-client.in +++ b/databases/postgresql15-server/files/pkg-message-client.in @@ -20,7 +20,7 @@ postgresql-odbc method. Not needed to access unix PostgreSQL servers from Win32 using ODBC. See below. -ruby-postgres, py-psycopg2 +ruby-postgres, py-psycopg For client access to PostgreSQL databases using the ruby & python languages. diff --git a/databases/postgresql15-server/files/pkg-message-contrib.in b/databases/postgresql15-server/files/pkg-message-contrib.in index 2d9f3d86e71c..006f700a3ae1 100644 --- a/databases/postgresql15-server/files/pkg-message-contrib.in +++ b/databases/postgresql15-server/files/pkg-message-contrib.in @@ -2,7 +2,7 @@ { type: install message: <<EOM The PostgreSQL contrib utilities have been installed. Please see -%%PREFIX%%/share/doc/postgresql/contrib/README +%%DOCSDIR%%/README-contrib for more information. EOM } diff --git a/databases/postgresql15-server/files/pkg-message-server.in b/databases/postgresql15-server/files/pkg-message-server.in index 9bfbcc7b4a83..2836b9d5f9b5 100644 --- a/databases/postgresql15-server/files/pkg-message-server.in +++ b/databases/postgresql15-server/files/pkg-message-server.in @@ -14,7 +14,7 @@ is a periodic script, %%PREFIX%%/etc/periodic/daily/502.pgsql, that you may find useful. You can use it to backup and perform vacuum on all databases nightly. Per default, it performs `vacuum analyze'. See the script for instructions. For autovacuum settings, please review -~postgres/data/postgresql.conf. +~%%PG_USER%%/data/postgresql.conf. If you plan to access your PostgreSQL server using ODBC, please consider running the SQL script %%PREFIX%%/share/postgresql/odbc.sql @@ -30,40 +30,54 @@ To set limits, environment stuff like locale and collation and other things, you can set up a class in /etc/login.conf before initializing the database. Add something similar to this to /etc/login.conf: --- -postgres:\ +%%PG_USER%%:\ :lang=en_US.UTF-8:\ :setenv=LC_COLLATE=C:\ :tc=default: --- and run `cap_mkdb /etc/login.conf'. -Then add 'postgresql_class="postgres"' to /etc/rc.conf. +Then add 'postgresql_login_class="%%PG_USER%%"' to /etc/rc.conf, or +set it as the %%PG_USER%% user's login class in /etc/passwd. ====================================================================== +To use PostgreSQL, enable it in rc.conf using + + sysrc postgresql_enable=yes + To initialize the database, run - %%PREFIX%%/etc/rc.d/postgresql initdb + service postgresql initdb You can then start PostgreSQL by running: - %%PREFIX%%/etc/rc.d/postgresql start + service postgresql start -For postmaster settings, see ~postgres/data/postgresql.conf +For postmaster settings, see ~%%PG_USER%%/data/postgresql.conf NB. FreeBSD's PostgreSQL port logs to syslog by default - See ~postgres/data/postgresql.conf for more info + See ~%%PG_USER%%/data/postgresql.conf for more info NB. If you're not using a checksumming filesystem like ZFS, you might wish to enable data checksumming. It can be enabled during the initdb phase, by adding the "--data-checksums" flag to the postgresql_initdb_flags rcvar. Otherwise you can enable it later by - pg_checksums. Check the initdb(1) manpage for more info + using pg_checksums. Check the initdb(1) manpage for more info and make sure you understand the performance implications. ====================================================================== -To run PostgreSQL at startup, add -'postgresql_enable="YES"' to /etc/rc.conf +SECURITY ADVICE + +If upgrading from a version 15.x < 15.7: +A security vulnerability was found in the system views pg_stats_ext +and pg_stats_ext_exprs, potentially allowing authenticated database +users to see data they shouldn't. If this is of concern in your +installation, run the SQL script %%DATADIR%%/fix-CVE-2024-4317.sql +for each of your databases. For details, see +https://www.postgresql.org/support/security/CVE-2024-4317/ + + EOM } ] diff --git a/databases/postgresql15-server/files/postgresql.in b/databases/postgresql15-server/files/postgresql.in index 48fbadb35d39..3227deee0b5d 100644 --- a/databases/postgresql15-server/files/postgresql.in +++ b/databases/postgresql15-server/files/postgresql.in @@ -11,7 +11,8 @@ # postgresql_data="/var/db/%%PG_USER%%/data%%PG_VERSION%%" # postgresql_flags="-w -s -m fast" # postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C" -# postgresql_login_class="default" +# # leave empty to use the login class set in in /etc/passwd: +# postgresql_login_class="my_custom_login_class" # postgresql_profiles="" # # See %%PREFIX%%/share/doc/postgresql/README-server for more info @@ -29,16 +30,18 @@ command=%%PREFIX%%/bin/pg_ctl load_rc_config postgresql # set defaults -postgresql_enable=${postgresql_enable:-"NO"} -postgresql_flags=${postgresql_flags:-"-w -s -m fast"} -postgresql_user=${postgresql_user:-"%%PG_USER%%"} -eval postgresql_data=${postgresql_data:-"~${postgresql_user}/data%%PG_VERSION%%"} -postgresql_login_class=${postgresql_login_class:-"default"} -postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc-collate=C"} +: ${postgresql_enable:="NO"} +: ${postgresql_flags:="-w -s -m fast"} +: ${postgresql_user:="%%PG_USER%%"} +eval _pgdir="~${postgresql_user}/data%%PG_VERSION%%" +: ${postgresql_data:="${_pgdir}"} +: ${postgresql_login_class:=""} +: ${postgresql_initdb_flags:="--encoding=utf-8 --lc-collate=C"} +: ${postgresql_svcj_options:="net_basic"} name=postgresql rcvar=postgresql_enable -extra_commands="reload initdb" +extra_commands="reload initdb promote logrotate" start_cmd="postgresql_command start" stop_cmd="postgresql_command stop" @@ -46,6 +49,7 @@ restart_cmd="postgresql_command restart" reload_cmd="postgresql_command reload" status_cmd="postgresql_command status" promote_cmd="postgresql_command promote" +logrotate_cmd="postgresql_command logrotate" initdb_cmd="postgresql_initdb" @@ -62,6 +66,7 @@ if [ -n "$2" ]; then eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}" eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}" eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}" + eval postgresql_login_class="\${postgresql_${profile}_login_class:-${postgresql_login_class}}" eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}" fi else @@ -100,16 +105,22 @@ else fi fi -command_args="-D ${postgresql_data} ${postgresql_flags}" +command_args="-l /dev/null -D ${postgresql_data} ${postgresql_flags}" postgresql_command() { - ${su_cmd} -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}" + echo "${rc_arg} ${name}" + ${su_cmd} ${postgresql_login_class:+-c ${postgresql_login_class}} \ + -l ${postgresql_user} \ + -c "exec ${command} ${command_args} ${rc_arg}" } postgresql_initdb() { - ${su_cmd} -l -c ${postgresql_login_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}" + echo "${rc_arg} ${name}" + ${su_cmd} ${postgresql_login_class:+-c ${postgresql_login_class}} \ + -l ${postgresql_user} \ + -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}" } run_rc_command "$1" diff --git a/databases/postgresql15-server/pkg-plist-client b/databases/postgresql15-server/pkg-plist-client index d4ff8a8d1d21..cdc6fcb8b8ab 100644 --- a/databases/postgresql15-server/pkg-plist-client +++ b/databases/postgresql15-server/pkg-plist-client @@ -433,8 +433,10 @@ include/postgresql/server/foreign/foreign.h include/postgresql/server/funcapi.h include/postgresql/server/getaddrinfo.h include/postgresql/server/getopt_long.h +include/postgresql/server/jit/SectionMemoryManager.h include/postgresql/server/jit/jit.h include/postgresql/server/jit/llvmjit.h +include/postgresql/server/jit/llvmjit_backport.h include/postgresql/server/jit/llvmjit_emit.h include/postgresql/server/lib/binaryheap.h include/postgresql/server/lib/bipartite_match.h @@ -454,6 +456,7 @@ include/postgresql/server/libpq/auth.h include/postgresql/server/libpq/be-fsstubs.h include/postgresql/server/libpq/be-gssapi-common.h include/postgresql/server/libpq/crypt.h +include/postgresql/server/libpq/libpq-be-fe-helpers.h include/postgresql/server/libpq/hba.h include/postgresql/server/libpq/ifaddr.h include/postgresql/server/libpq/libpq-be.h @@ -876,6 +879,7 @@ lib/libecpg.so.6 lib/libecpg_compat.a lib/libecpg_compat.so lib/libecpg_compat.so.3 +lib/libpgfeutils.a lib/libpgport.a lib/libpgport_shlib.a lib/libpgtypes.a @@ -896,301 +900,301 @@ libdata/pkgconfig/libecpg.pc libdata/pkgconfig/libecpg_compat.pc libdata/pkgconfig/libpgtypes.pc libdata/pkgconfig/libpq.pc -man/man1/clusterdb.1.gz -man/man1/createdb.1.gz -man/man1/createuser.1.gz -man/man1/dropdb.1.gz -man/man1/dropuser.1.gz -man/man1/ecpg.1.gz -man/man1/initdb.1.gz -man/man1/oid2name.1.gz -man/man1/pg_amcheck.1.gz -man/man1/pg_archivecleanup.1.gz -man/man1/pg_basebackup.1.gz -man/man1/pg_checksums.1.gz -man/man1/pg_config.1.gz -man/man1/pg_controldata.1.gz -man/man1/pg_ctl.1.gz -man/man1/pg_dump.1.gz -man/man1/pg_dumpall.1.gz -man/man1/pg_isready.1.gz -man/man1/pg_receivewal.1.gz -man/man1/pg_recvlogical.1.gz -man/man1/pg_resetwal.1.gz -man/man1/pg_restore.1.gz -man/man1/pg_rewind.1.gz -man/man1/pg_test_fsync.1.gz -man/man1/pg_test_timing.1.gz -man/man1/pg_upgrade.1.gz -man/man1/pg_verifybackup.1.gz -man/man1/pg_waldump.1.gz -man/man1/pgbench.1.gz -man/man1/postgres.1.gz -man/man1/postmaster.1.gz -man/man1/psql.1.gz -man/man1/reindexdb.1.gz -man/man1/vacuumdb.1.gz -man/man1/vacuumlo.1.gz -man/man3/SPI_commit.3.gz -man/man3/SPI_commit_and_chain.3.gz -man/man3/SPI_connect.3.gz -man/man3/SPI_connect_ext.3.gz -man/man3/SPI_copytuple.3.gz -man/man3/SPI_cursor_close.3.gz -man/man3/SPI_cursor_fetch.3.gz -man/man3/SPI_cursor_find.3.gz -man/man3/SPI_cursor_move.3.gz -man/man3/SPI_cursor_open.3.gz -man/man3/SPI_cursor_open_with_args.3.gz -man/man3/SPI_cursor_open_with_paramlist.3.gz -man/man3/SPI_cursor_parse_open.3.gz -man/man3/SPI_exec.3.gz -man/man3/SPI_execp.3.gz -man/man3/SPI_execute.3.gz -man/man3/SPI_execute_extended.3.gz -man/man3/SPI_execute_plan.3.gz -man/man3/SPI_execute_plan_extended.3.gz -man/man3/SPI_execute_plan_with_paramlist.3.gz -man/man3/SPI_execute_with_args.3.gz -man/man3/SPI_finish.3.gz -man/man3/SPI_fname.3.gz -man/man3/SPI_fnumber.3.gz -man/man3/SPI_freeplan.3.gz -man/man3/SPI_freetuple.3.gz -man/man3/SPI_freetuptable.3.gz -man/man3/SPI_getargcount.3.gz -man/man3/SPI_getargtypeid.3.gz -man/man3/SPI_getbinval.3.gz -man/man3/SPI_getnspname.3.gz -man/man3/SPI_getrelname.3.gz -man/man3/SPI_gettype.3.gz -man/man3/SPI_gettypeid.3.gz -man/man3/SPI_getvalue.3.gz -man/man3/SPI_is_cursor_plan.3.gz -man/man3/SPI_keepplan.3.gz -man/man3/SPI_modifytuple.3.gz -man/man3/SPI_palloc.3.gz -man/man3/SPI_pfree.3.gz -man/man3/SPI_prepare.3.gz -man/man3/SPI_prepare_cursor.3.gz -man/man3/SPI_prepare_extended.3.gz -man/man3/SPI_prepare_params.3.gz -man/man3/SPI_register_relation.3.gz -man/man3/SPI_register_trigger_data.3.gz -man/man3/SPI_repalloc.3.gz -man/man3/SPI_result_code_string.3.gz -man/man3/SPI_returntuple.3.gz -man/man3/SPI_rollback.3.gz -man/man3/SPI_rollback_and_chain.3.gz -man/man3/SPI_saveplan.3.gz -man/man3/SPI_scroll_cursor_fetch.3.gz -man/man3/SPI_scroll_cursor_move.3.gz -man/man3/SPI_start_transaction.3.gz -man/man3/SPI_unregister_relation.3.gz -man/man3/dblink.3.gz -man/man3/dblink_build_sql_delete.3.gz -man/man3/dblink_build_sql_insert.3.gz -man/man3/dblink_build_sql_update.3.gz -man/man3/dblink_cancel_query.3.gz -man/man3/dblink_close.3.gz -man/man3/dblink_connect.3.gz -man/man3/dblink_connect_u.3.gz -man/man3/dblink_disconnect.3.gz -man/man3/dblink_error_message.3.gz -man/man3/dblink_exec.3.gz -man/man3/dblink_fetch.3.gz -man/man3/dblink_get_connections.3.gz -man/man3/dblink_get_notify.3.gz -man/man3/dblink_get_pkey.3.gz -man/man3/dblink_get_result.3.gz -man/man3/dblink_is_busy.3.gz -man/man3/dblink_open.3.gz -man/man3/dblink_send_query.3.gz -man/man7/ABORT.7.gz -man/man7/ALTER_AGGREGATE.7.gz -man/man7/ALTER_COLLATION.7.gz -man/man7/ALTER_CONVERSION.7.gz -man/man7/ALTER_DATABASE.7.gz -man/man7/ALTER_DEFAULT_PRIVILEGES.7.gz -man/man7/ALTER_DOMAIN.7.gz -man/man7/ALTER_EVENT_TRIGGER.7.gz -man/man7/ALTER_EXTENSION.7.gz -man/man7/ALTER_FOREIGN_DATA_WRAPPER.7.gz -man/man7/ALTER_FOREIGN_TABLE.7.gz -man/man7/ALTER_FUNCTION.7.gz -man/man7/ALTER_GROUP.7.gz -man/man7/ALTER_INDEX.7.gz -man/man7/ALTER_LANGUAGE.7.gz -man/man7/ALTER_LARGE_OBJECT.7.gz -man/man7/ALTER_MATERIALIZED_VIEW.7.gz -man/man7/ALTER_OPERATOR.7.gz -man/man7/ALTER_OPERATOR_CLASS.7.gz -man/man7/ALTER_OPERATOR_FAMILY.7.gz -man/man7/ALTER_POLICY.7.gz -man/man7/ALTER_PROCEDURE.7.gz -man/man7/ALTER_PUBLICATION.7.gz -man/man7/ALTER_ROLE.7.gz -man/man7/ALTER_ROUTINE.7.gz -man/man7/ALTER_RULE.7.gz -man/man7/ALTER_SCHEMA.7.gz -man/man7/ALTER_SEQUENCE.7.gz -man/man7/ALTER_SERVER.7.gz -man/man7/ALTER_STATISTICS.7.gz -man/man7/ALTER_SUBSCRIPTION.7.gz -man/man7/ALTER_SYSTEM.7.gz -man/man7/ALTER_TABLE.7.gz -man/man7/ALTER_TABLESPACE.7.gz -man/man7/ALTER_TEXT_SEARCH_CONFIGURATION.7.gz -man/man7/ALTER_TEXT_SEARCH_DICTIONARY.7.gz -man/man7/ALTER_TEXT_SEARCH_PARSER.7.gz -man/man7/ALTER_TEXT_SEARCH_TEMPLATE.7.gz -man/man7/ALTER_TRIGGER.7.gz -man/man7/ALTER_TYPE.7.gz -man/man7/ALTER_USER.7.gz -man/man7/ALTER_USER_MAPPING.7.gz -man/man7/ALTER_VIEW.7.gz -man/man7/ANALYZE.7.gz -man/man7/BEGIN.7.gz -man/man7/CALL.7.gz -man/man7/CHECKPOINT.7.gz -man/man7/CLOSE.7.gz -man/man7/CLUSTER.7.gz -man/man7/COMMENT.7.gz -man/man7/COMMIT.7.gz -man/man7/COMMIT_PREPARED.7.gz -man/man7/COPY.7.gz -man/man7/CREATE_ACCESS_METHOD.7.gz -man/man7/CREATE_AGGREGATE.7.gz -man/man7/CREATE_CAST.7.gz -man/man7/CREATE_COLLATION.7.gz -man/man7/CREATE_CONVERSION.7.gz -man/man7/CREATE_DATABASE.7.gz -man/man7/CREATE_DOMAIN.7.gz -man/man7/CREATE_EVENT_TRIGGER.7.gz -man/man7/CREATE_EXTENSION.7.gz -man/man7/CREATE_FOREIGN_DATA_WRAPPER.7.gz -man/man7/CREATE_FOREIGN_TABLE.7.gz -man/man7/CREATE_FUNCTION.7.gz -man/man7/CREATE_GROUP.7.gz -man/man7/CREATE_INDEX.7.gz -man/man7/CREATE_LANGUAGE.7.gz -man/man7/CREATE_MATERIALIZED_VIEW.7.gz -man/man7/CREATE_OPERATOR.7.gz -man/man7/CREATE_OPERATOR_CLASS.7.gz -man/man7/CREATE_OPERATOR_FAMILY.7.gz -man/man7/CREATE_POLICY.7.gz -man/man7/CREATE_PROCEDURE.7.gz -man/man7/CREATE_PUBLICATION.7.gz -man/man7/CREATE_ROLE.7.gz -man/man7/CREATE_RULE.7.gz -man/man7/CREATE_SCHEMA.7.gz -man/man7/CREATE_SEQUENCE.7.gz -man/man7/CREATE_SERVER.7.gz -man/man7/CREATE_STATISTICS.7.gz -man/man7/CREATE_SUBSCRIPTION.7.gz -man/man7/CREATE_TABLE.7.gz -man/man7/CREATE_TABLESPACE.7.gz -man/man7/CREATE_TABLE_AS.7.gz -man/man7/CREATE_TEXT_SEARCH_CONFIGURATION.7.gz -man/man7/CREATE_TEXT_SEARCH_DICTIONARY.7.gz -man/man7/CREATE_TEXT_SEARCH_PARSER.7.gz -man/man7/CREATE_TEXT_SEARCH_TEMPLATE.7.gz -man/man7/CREATE_TRANSFORM.7.gz -man/man7/CREATE_TRIGGER.7.gz -man/man7/CREATE_TYPE.7.gz -man/man7/CREATE_USER.7.gz -man/man7/CREATE_USER_MAPPING.7.gz -man/man7/CREATE_VIEW.7.gz -man/man7/DEALLOCATE.7.gz -man/man7/DECLARE.7.gz -man/man7/DELETE.7.gz -man/man7/DISCARD.7.gz -man/man7/DO.7.gz -man/man7/DROP_ACCESS_METHOD.7.gz -man/man7/DROP_AGGREGATE.7.gz -man/man7/DROP_CAST.7.gz -man/man7/DROP_COLLATION.7.gz -man/man7/DROP_CONVERSION.7.gz -man/man7/DROP_DATABASE.7.gz -man/man7/DROP_DOMAIN.7.gz -man/man7/DROP_EVENT_TRIGGER.7.gz -man/man7/DROP_EXTENSION.7.gz -man/man7/DROP_FOREIGN_DATA_WRAPPER.7.gz -man/man7/DROP_FOREIGN_TABLE.7.gz -man/man7/DROP_FUNCTION.7.gz -man/man7/DROP_GROUP.7.gz -man/man7/DROP_INDEX.7.gz -man/man7/DROP_LANGUAGE.7.gz -man/man7/DROP_MATERIALIZED_VIEW.7.gz -man/man7/DROP_OPERATOR.7.gz -man/man7/DROP_OPERATOR_CLASS.7.gz -man/man7/DROP_OPERATOR_FAMILY.7.gz -man/man7/DROP_OWNED.7.gz -man/man7/DROP_POLICY.7.gz -man/man7/DROP_PROCEDURE.7.gz -man/man7/DROP_PUBLICATION.7.gz -man/man7/DROP_ROLE.7.gz -man/man7/DROP_ROUTINE.7.gz -man/man7/DROP_RULE.7.gz -man/man7/DROP_SCHEMA.7.gz -man/man7/DROP_SEQUENCE.7.gz -man/man7/DROP_SERVER.7.gz -man/man7/DROP_STATISTICS.7.gz -man/man7/DROP_SUBSCRIPTION.7.gz -man/man7/DROP_TABLE.7.gz -man/man7/DROP_TABLESPACE.7.gz -man/man7/DROP_TEXT_SEARCH_CONFIGURATION.7.gz -man/man7/DROP_TEXT_SEARCH_DICTIONARY.7.gz -man/man7/DROP_TEXT_SEARCH_PARSER.7.gz -man/man7/DROP_TEXT_SEARCH_TEMPLATE.7.gz -man/man7/DROP_TRANSFORM.7.gz -man/man7/DROP_TRIGGER.7.gz -man/man7/DROP_TYPE.7.gz -man/man7/DROP_USER.7.gz -man/man7/DROP_USER_MAPPING.7.gz -man/man7/DROP_VIEW.7.gz -man/man7/END.7.gz -man/man7/EXECUTE.7.gz -man/man7/EXPLAIN.7.gz -man/man7/FETCH.7.gz -man/man7/GRANT.7.gz -man/man7/IMPORT_FOREIGN_SCHEMA.7.gz -man/man7/INSERT.7.gz -man/man7/LISTEN.7.gz -man/man7/LOAD.7.gz -man/man7/LOCK.7.gz -man/man7/MERGE.7.gz -man/man7/MOVE.7.gz -man/man7/NOTIFY.7.gz -man/man7/PREPARE.7.gz -man/man7/PREPARE_TRANSACTION.7.gz -man/man7/REASSIGN_OWNED.7.gz -man/man7/REFRESH_MATERIALIZED_VIEW.7.gz -man/man7/REINDEX.7.gz -man/man7/RELEASE_SAVEPOINT.7.gz -man/man7/RESET.7.gz -man/man7/REVOKE.7.gz -man/man7/ROLLBACK.7.gz -man/man7/ROLLBACK_PREPARED.7.gz -man/man7/ROLLBACK_TO_SAVEPOINT.7.gz -man/man7/SAVEPOINT.7.gz -man/man7/SECURITY_LABEL.7.gz -man/man7/SELECT.7.gz -man/man7/SELECT_INTO.7.gz -man/man7/SET.7.gz -man/man7/SET_CONSTRAINTS.7.gz -man/man7/SET_ROLE.7.gz -man/man7/SET_SESSION_AUTHORIZATION.7.gz -man/man7/SET_TRANSACTION.7.gz -man/man7/SHOW.7.gz -man/man7/START_TRANSACTION.7.gz -man/man7/TABLE.7.gz -man/man7/TRUNCATE.7.gz -man/man7/UNLISTEN.7.gz -man/man7/UPDATE.7.gz -man/man7/VACUUM.7.gz -man/man7/VALUES.7.gz -man/man7/WITH.7.gz +share/man/man1/clusterdb.1.gz +share/man/man1/createdb.1.gz +share/man/man1/createuser.1.gz +share/man/man1/dropdb.1.gz +share/man/man1/dropuser.1.gz +share/man/man1/ecpg.1.gz +share/man/man1/initdb.1.gz +share/man/man1/oid2name.1.gz +share/man/man1/pg_amcheck.1.gz +share/man/man1/pg_archivecleanup.1.gz +share/man/man1/pg_basebackup.1.gz +share/man/man1/pg_checksums.1.gz +share/man/man1/pg_config.1.gz +share/man/man1/pg_controldata.1.gz +share/man/man1/pg_ctl.1.gz +share/man/man1/pg_dump.1.gz +share/man/man1/pg_dumpall.1.gz +share/man/man1/pg_isready.1.gz +share/man/man1/pg_receivewal.1.gz +share/man/man1/pg_recvlogical.1.gz +share/man/man1/pg_resetwal.1.gz +share/man/man1/pg_restore.1.gz +share/man/man1/pg_rewind.1.gz +share/man/man1/pg_test_fsync.1.gz +share/man/man1/pg_test_timing.1.gz +share/man/man1/pg_upgrade.1.gz +share/man/man1/pg_verifybackup.1.gz +share/man/man1/pg_waldump.1.gz +share/man/man1/pgbench.1.gz +share/man/man1/postgres.1.gz +share/man/man1/postmaster.1.gz +share/man/man1/psql.1.gz +share/man/man1/reindexdb.1.gz +share/man/man1/vacuumdb.1.gz +share/man/man1/vacuumlo.1.gz +share/man/man3/SPI_commit.3.gz +share/man/man3/SPI_commit_and_chain.3.gz +share/man/man3/SPI_connect.3.gz +share/man/man3/SPI_connect_ext.3.gz +share/man/man3/SPI_copytuple.3.gz +share/man/man3/SPI_cursor_close.3.gz +share/man/man3/SPI_cursor_fetch.3.gz +share/man/man3/SPI_cursor_find.3.gz +share/man/man3/SPI_cursor_move.3.gz +share/man/man3/SPI_cursor_open.3.gz +share/man/man3/SPI_cursor_open_with_args.3.gz +share/man/man3/SPI_cursor_open_with_paramlist.3.gz +share/man/man3/SPI_cursor_parse_open.3.gz +share/man/man3/SPI_exec.3.gz +share/man/man3/SPI_execp.3.gz +share/man/man3/SPI_execute.3.gz +share/man/man3/SPI_execute_extended.3.gz +share/man/man3/SPI_execute_plan.3.gz +share/man/man3/SPI_execute_plan_extended.3.gz +share/man/man3/SPI_execute_plan_with_paramlist.3.gz +share/man/man3/SPI_execute_with_args.3.gz +share/man/man3/SPI_finish.3.gz +share/man/man3/SPI_fname.3.gz +share/man/man3/SPI_fnumber.3.gz +share/man/man3/SPI_freeplan.3.gz +share/man/man3/SPI_freetuple.3.gz +share/man/man3/SPI_freetuptable.3.gz +share/man/man3/SPI_getargcount.3.gz +share/man/man3/SPI_getargtypeid.3.gz +share/man/man3/SPI_getbinval.3.gz +share/man/man3/SPI_getnspname.3.gz +share/man/man3/SPI_getrelname.3.gz +share/man/man3/SPI_gettype.3.gz +share/man/man3/SPI_gettypeid.3.gz +share/man/man3/SPI_getvalue.3.gz +share/man/man3/SPI_is_cursor_plan.3.gz +share/man/man3/SPI_keepplan.3.gz +share/man/man3/SPI_modifytuple.3.gz +share/man/man3/SPI_palloc.3.gz +share/man/man3/SPI_pfree.3.gz +share/man/man3/SPI_prepare.3.gz +share/man/man3/SPI_prepare_cursor.3.gz +share/man/man3/SPI_prepare_extended.3.gz +share/man/man3/SPI_prepare_params.3.gz +share/man/man3/SPI_register_relation.3.gz +share/man/man3/SPI_register_trigger_data.3.gz +share/man/man3/SPI_repalloc.3.gz +share/man/man3/SPI_result_code_string.3.gz +share/man/man3/SPI_returntuple.3.gz +share/man/man3/SPI_rollback.3.gz +share/man/man3/SPI_rollback_and_chain.3.gz +share/man/man3/SPI_saveplan.3.gz +share/man/man3/SPI_scroll_cursor_fetch.3.gz +share/man/man3/SPI_scroll_cursor_move.3.gz +share/man/man3/SPI_start_transaction.3.gz +share/man/man3/SPI_unregister_relation.3.gz +share/man/man3/dblink.3.gz +share/man/man3/dblink_build_sql_delete.3.gz +share/man/man3/dblink_build_sql_insert.3.gz +share/man/man3/dblink_build_sql_update.3.gz +share/man/man3/dblink_cancel_query.3.gz +share/man/man3/dblink_close.3.gz +share/man/man3/dblink_connect.3.gz +share/man/man3/dblink_connect_u.3.gz +share/man/man3/dblink_disconnect.3.gz +share/man/man3/dblink_error_message.3.gz +share/man/man3/dblink_exec.3.gz +share/man/man3/dblink_fetch.3.gz +share/man/man3/dblink_get_connections.3.gz +share/man/man3/dblink_get_notify.3.gz +share/man/man3/dblink_get_pkey.3.gz +share/man/man3/dblink_get_result.3.gz +share/man/man3/dblink_is_busy.3.gz +share/man/man3/dblink_open.3.gz +share/man/man3/dblink_send_query.3.gz +share/man/man7/ABORT.7.gz +share/man/man7/ALTER_AGGREGATE.7.gz +share/man/man7/ALTER_COLLATION.7.gz +share/man/man7/ALTER_CONVERSION.7.gz +share/man/man7/ALTER_DATABASE.7.gz +share/man/man7/ALTER_DEFAULT_PRIVILEGES.7.gz +share/man/man7/ALTER_DOMAIN.7.gz +share/man/man7/ALTER_EVENT_TRIGGER.7.gz +share/man/man7/ALTER_EXTENSION.7.gz +share/man/man7/ALTER_FOREIGN_DATA_WRAPPER.7.gz +share/man/man7/ALTER_FOREIGN_TABLE.7.gz +share/man/man7/ALTER_FUNCTION.7.gz +share/man/man7/ALTER_GROUP.7.gz +share/man/man7/ALTER_INDEX.7.gz +share/man/man7/ALTER_LANGUAGE.7.gz +share/man/man7/ALTER_LARGE_OBJECT.7.gz +share/man/man7/ALTER_MATERIALIZED_VIEW.7.gz +share/man/man7/ALTER_OPERATOR.7.gz +share/man/man7/ALTER_OPERATOR_CLASS.7.gz +share/man/man7/ALTER_OPERATOR_FAMILY.7.gz +share/man/man7/ALTER_POLICY.7.gz +share/man/man7/ALTER_PROCEDURE.7.gz +share/man/man7/ALTER_PUBLICATION.7.gz +share/man/man7/ALTER_ROLE.7.gz +share/man/man7/ALTER_ROUTINE.7.gz +share/man/man7/ALTER_RULE.7.gz +share/man/man7/ALTER_SCHEMA.7.gz +share/man/man7/ALTER_SEQUENCE.7.gz +share/man/man7/ALTER_SERVER.7.gz +share/man/man7/ALTER_STATISTICS.7.gz +share/man/man7/ALTER_SUBSCRIPTION.7.gz +share/man/man7/ALTER_SYSTEM.7.gz +share/man/man7/ALTER_TABLE.7.gz +share/man/man7/ALTER_TABLESPACE.7.gz +share/man/man7/ALTER_TEXT_SEARCH_CONFIGURATION.7.gz +share/man/man7/ALTER_TEXT_SEARCH_DICTIONARY.7.gz +share/man/man7/ALTER_TEXT_SEARCH_PARSER.7.gz +share/man/man7/ALTER_TEXT_SEARCH_TEMPLATE.7.gz +share/man/man7/ALTER_TRIGGER.7.gz +share/man/man7/ALTER_TYPE.7.gz +share/man/man7/ALTER_USER.7.gz +share/man/man7/ALTER_USER_MAPPING.7.gz +share/man/man7/ALTER_VIEW.7.gz +share/man/man7/ANALYZE.7.gz +share/man/man7/BEGIN.7.gz +share/man/man7/CALL.7.gz +share/man/man7/CHECKPOINT.7.gz +share/man/man7/CLOSE.7.gz +share/man/man7/CLUSTER.7.gz +share/man/man7/COMMENT.7.gz +share/man/man7/COMMIT.7.gz +share/man/man7/COMMIT_PREPARED.7.gz +share/man/man7/COPY.7.gz +share/man/man7/CREATE_ACCESS_METHOD.7.gz +share/man/man7/CREATE_AGGREGATE.7.gz +share/man/man7/CREATE_CAST.7.gz +share/man/man7/CREATE_COLLATION.7.gz +share/man/man7/CREATE_CONVERSION.7.gz +share/man/man7/CREATE_DATABASE.7.gz +share/man/man7/CREATE_DOMAIN.7.gz +share/man/man7/CREATE_EVENT_TRIGGER.7.gz +share/man/man7/CREATE_EXTENSION.7.gz +share/man/man7/CREATE_FOREIGN_DATA_WRAPPER.7.gz +share/man/man7/CREATE_FOREIGN_TABLE.7.gz +share/man/man7/CREATE_FUNCTION.7.gz +share/man/man7/CREATE_GROUP.7.gz +share/man/man7/CREATE_INDEX.7.gz +share/man/man7/CREATE_LANGUAGE.7.gz +share/man/man7/CREATE_MATERIALIZED_VIEW.7.gz +share/man/man7/CREATE_OPERATOR.7.gz +share/man/man7/CREATE_OPERATOR_CLASS.7.gz +share/man/man7/CREATE_OPERATOR_FAMILY.7.gz +share/man/man7/CREATE_POLICY.7.gz +share/man/man7/CREATE_PROCEDURE.7.gz +share/man/man7/CREATE_PUBLICATION.7.gz +share/man/man7/CREATE_ROLE.7.gz +share/man/man7/CREATE_RULE.7.gz +share/man/man7/CREATE_SCHEMA.7.gz +share/man/man7/CREATE_SEQUENCE.7.gz +share/man/man7/CREATE_SERVER.7.gz +share/man/man7/CREATE_STATISTICS.7.gz +share/man/man7/CREATE_SUBSCRIPTION.7.gz +share/man/man7/CREATE_TABLE.7.gz +share/man/man7/CREATE_TABLESPACE.7.gz +share/man/man7/CREATE_TABLE_AS.7.gz +share/man/man7/CREATE_TEXT_SEARCH_CONFIGURATION.7.gz +share/man/man7/CREATE_TEXT_SEARCH_DICTIONARY.7.gz +share/man/man7/CREATE_TEXT_SEARCH_PARSER.7.gz +share/man/man7/CREATE_TEXT_SEARCH_TEMPLATE.7.gz +share/man/man7/CREATE_TRANSFORM.7.gz +share/man/man7/CREATE_TRIGGER.7.gz +share/man/man7/CREATE_TYPE.7.gz +share/man/man7/CREATE_USER.7.gz +share/man/man7/CREATE_USER_MAPPING.7.gz +share/man/man7/CREATE_VIEW.7.gz +share/man/man7/DEALLOCATE.7.gz +share/man/man7/DECLARE.7.gz +share/man/man7/DELETE.7.gz +share/man/man7/DISCARD.7.gz +share/man/man7/DO.7.gz +share/man/man7/DROP_ACCESS_METHOD.7.gz +share/man/man7/DROP_AGGREGATE.7.gz +share/man/man7/DROP_CAST.7.gz +share/man/man7/DROP_COLLATION.7.gz +share/man/man7/DROP_CONVERSION.7.gz +share/man/man7/DROP_DATABASE.7.gz +share/man/man7/DROP_DOMAIN.7.gz +share/man/man7/DROP_EVENT_TRIGGER.7.gz +share/man/man7/DROP_EXTENSION.7.gz +share/man/man7/DROP_FOREIGN_DATA_WRAPPER.7.gz +share/man/man7/DROP_FOREIGN_TABLE.7.gz +share/man/man7/DROP_FUNCTION.7.gz +share/man/man7/DROP_GROUP.7.gz +share/man/man7/DROP_INDEX.7.gz +share/man/man7/DROP_LANGUAGE.7.gz +share/man/man7/DROP_MATERIALIZED_VIEW.7.gz +share/man/man7/DROP_OPERATOR.7.gz +share/man/man7/DROP_OPERATOR_CLASS.7.gz +share/man/man7/DROP_OPERATOR_FAMILY.7.gz +share/man/man7/DROP_OWNED.7.gz +share/man/man7/DROP_POLICY.7.gz +share/man/man7/DROP_PROCEDURE.7.gz +share/man/man7/DROP_PUBLICATION.7.gz +share/man/man7/DROP_ROLE.7.gz +share/man/man7/DROP_ROUTINE.7.gz +share/man/man7/DROP_RULE.7.gz +share/man/man7/DROP_SCHEMA.7.gz +share/man/man7/DROP_SEQUENCE.7.gz +share/man/man7/DROP_SERVER.7.gz +share/man/man7/DROP_STATISTICS.7.gz +share/man/man7/DROP_SUBSCRIPTION.7.gz +share/man/man7/DROP_TABLE.7.gz +share/man/man7/DROP_TABLESPACE.7.gz +share/man/man7/DROP_TEXT_SEARCH_CONFIGURATION.7.gz +share/man/man7/DROP_TEXT_SEARCH_DICTIONARY.7.gz +share/man/man7/DROP_TEXT_SEARCH_PARSER.7.gz +share/man/man7/DROP_TEXT_SEARCH_TEMPLATE.7.gz +share/man/man7/DROP_TRANSFORM.7.gz +share/man/man7/DROP_TRIGGER.7.gz +share/man/man7/DROP_TYPE.7.gz +share/man/man7/DROP_USER.7.gz +share/man/man7/DROP_USER_MAPPING.7.gz +share/man/man7/DROP_VIEW.7.gz +share/man/man7/END.7.gz +share/man/man7/EXECUTE.7.gz +share/man/man7/EXPLAIN.7.gz +share/man/man7/FETCH.7.gz +share/man/man7/GRANT.7.gz +share/man/man7/IMPORT_FOREIGN_SCHEMA.7.gz +share/man/man7/INSERT.7.gz +share/man/man7/LISTEN.7.gz +share/man/man7/LOAD.7.gz +share/man/man7/LOCK.7.gz +share/man/man7/MERGE.7.gz +share/man/man7/MOVE.7.gz +share/man/man7/NOTIFY.7.gz +share/man/man7/PREPARE.7.gz +share/man/man7/PREPARE_TRANSACTION.7.gz +share/man/man7/REASSIGN_OWNED.7.gz +share/man/man7/REFRESH_MATERIALIZED_VIEW.7.gz +share/man/man7/REINDEX.7.gz +share/man/man7/RELEASE_SAVEPOINT.7.gz +share/man/man7/RESET.7.gz +share/man/man7/REVOKE.7.gz +share/man/man7/ROLLBACK.7.gz +share/man/man7/ROLLBACK_PREPARED.7.gz +share/man/man7/ROLLBACK_TO_SAVEPOINT.7.gz +share/man/man7/SAVEPOINT.7.gz +share/man/man7/SECURITY_LABEL.7.gz +share/man/man7/SELECT.7.gz +share/man/man7/SELECT_INTO.7.gz +share/man/man7/SET.7.gz +share/man/man7/SET_CONSTRAINTS.7.gz +share/man/man7/SET_ROLE.7.gz +share/man/man7/SET_SESSION_AUTHORIZATION.7.gz +share/man/man7/SET_TRANSACTION.7.gz +share/man/man7/SHOW.7.gz +share/man/man7/START_TRANSACTION.7.gz +share/man/man7/TABLE.7.gz +share/man/man7/TRUNCATE.7.gz +share/man/man7/UNLISTEN.7.gz +share/man/man7/UPDATE.7.gz +share/man/man7/VACUUM.7.gz +share/man/man7/VALUES.7.gz +share/man/man7/WITH.7.gz %%PORTDOCS%%%%DOCSDIR%%/README-client %%NLS%%share/locale/cs/LC_MESSAGES/ecpg-%%PG_VERSION%%.mo %%NLS%%share/locale/cs/LC_MESSAGES/ecpglib6-%%PG_VERSION%%.mo diff --git a/databases/postgresql15-server/pkg-plist-contrib b/databases/postgresql15-server/pkg-plist-contrib index a957bae789cf..8b2a0b0dcb99 100644 --- a/databases/postgresql15-server/pkg-plist-contrib +++ b/databases/postgresql15-server/pkg-plist-contrib @@ -41,7 +41,7 @@ lib/postgresql/pg_surgery.so lib/postgresql/pg_trgm.so lib/postgresql/pg_visibility.so lib/postgresql/pg_walinspect.so -lib/postgresql/pgcrypto.so +%%OPENSSL%%lib/postgresql/pgcrypto.so lib/postgresql/pgrowlocks.so lib/postgresql/pgstattuple.so %%XML%%lib/postgresql/pgxml.so @@ -211,11 +211,11 @@ lib/postgresql/uuid-ossp.so %%DATADIR%%/extension/pg_visibility.control %%DATADIR%%/extension/pg_walinspect--1.0.sql %%DATADIR%%/extension/pg_walinspect.control -%%DATADIR%%/extension/pgcrypto--1.0--1.1.sql -%%DATADIR%%/extension/pgcrypto--1.1--1.2.sql -%%DATADIR%%/extension/pgcrypto--1.2--1.3.sql -%%DATADIR%%/extension/pgcrypto--1.3.sql -%%DATADIR%%/extension/pgcrypto.control +%%OPENSSL%%%%DATADIR%%/extension/pgcrypto--1.0--1.1.sql +%%OPENSSL%%%%DATADIR%%/extension/pgcrypto--1.1--1.2.sql +%%OPENSSL%%%%DATADIR%%/extension/pgcrypto--1.2--1.3.sql +%%OPENSSL%%%%DATADIR%%/extension/pgcrypto--1.3.sql +%%OPENSSL%%%%DATADIR%%/extension/pgcrypto.control %%DATADIR%%/extension/pgrowlocks--1.0--1.1.sql %%DATADIR%%/extension/pgrowlocks--1.1--1.2.sql %%DATADIR%%/extension/pgrowlocks--1.2.sql diff --git a/databases/postgresql15-server/pkg-plist-plperl b/databases/postgresql15-server/pkg-plist-plperl index 865e061d1efc..d2b1c7fd3143 100644 --- a/databases/postgresql15-server/pkg-plist-plperl +++ b/databases/postgresql15-server/pkg-plist-plperl @@ -1,5 +1,6 @@ include/postgresql/server/plperl.h include/postgresql/server/plperl_helpers.h +include/postgresql/server/plperl_system.h include/postgresql/server/ppport.h %%DATADIR%%/extension/plperlu--1.0.sql %%DATADIR%%/extension/plperl.control diff --git a/databases/postgresql15-server/pkg-plist-plpython b/databases/postgresql15-server/pkg-plist-plpython index 127072f6e5cd..23631de669b7 100644 --- a/databases/postgresql15-server/pkg-plist-plpython +++ b/databases/postgresql15-server/pkg-plist-plpython @@ -11,6 +11,7 @@ include/postgresql/server/plpy_subxactobject.h include/postgresql/server/plpy_typeio.h include/postgresql/server/plpy_util.h include/postgresql/server/plpython.h +include/postgresql/server/plpython_system.h %%DOCSDIR%%/README-plpython %%PYTHON2%%lib/postgresql/plpython2.so %%PYTHON3%%lib/postgresql/plpython3.so diff --git a/databases/postgresql15-server/pkg-plist-server b/databases/postgresql15-server/pkg-plist-server index 57297e9e3dd4..4ada93678b40 100644 --- a/databases/postgresql15-server/pkg-plist-server +++ b/databases/postgresql15-server/pkg-plist-server @@ -786,6 +786,7 @@ lib/postgresql/utf8_and_win.so %%DATADIR%%/errcodes.txt %%DATADIR%%/extension/plpgsql--1.0.sql %%DATADIR%%/extension/plpgsql.control +%%DATADIR%%/fix-CVE-2024-4317.sql %%DATADIR%%/information_schema.sql %%DATADIR%%/pg_hba.conf.sample %%DATADIR%%/pg_ident.conf.sample @@ -897,6 +898,7 @@ lib/postgresql/utf8_and_win.so %%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/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 @@ -1077,6 +1079,7 @@ lib/postgresql/utf8_and_win.so %%TZDATA%%%%DATADIR%%/timezone/America/Coral_Harbour %%TZDATA%%%%DATADIR%%/timezone/America/Cordoba %%TZDATA%%%%DATADIR%%/timezone/America/Costa_Rica +%%TZDATA%%%%DATADIR%%/timezone/America/Coyhaique %%TZDATA%%%%DATADIR%%/timezone/America/Creston %%TZDATA%%%%DATADIR%%/timezone/America/Cuiaba %%TZDATA%%%%DATADIR%%/timezone/America/Curacao |