From nobody Sun Dec 31 00:09:09 2023 X-Original-To: dev-commits-ports-main@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4T2fc628L7z55c9K; Sun, 31 Dec 2023 00:09:10 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4T2fc56jFyz3DCp; Sun, 31 Dec 2023 00:09:09 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1703981350; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=ATgzcCgPNw13l0cecZ1MooK8VYGlLhwVoyreAfDdWOM=; b=LaXXpv+sp/b7d1qAMbb5mrVI2C320bTuB0E9jjTcqJfUTsuUjtEl7EybKPTyfSKihVu58Y j65DWPbpJlC5XxlWIRQUz9BL1IB9lgnk1BF3Y3FLJ8YbIIqpgVwVTSaRgPBVTSxfL9CTzL PFxR24xiA2u4K0v93Tr1BsrfFfKy+oNrBfIAQuXImFq/Ur4hYpj/VL9iftMZdHcDFiwPIg ZLTzg5pq0lO/l7OcZDDvPrf+3QIxgI4aRGLboITNvyqULhtFQklsizW7cMd2c8WO9x4a9o PwBwuYwmKO9yKTcGmz3xjEbSMWPg9EeGWt/4W8GTweUu93yo6hCOXhSWQDwkNw== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1703981350; a=rsa-sha256; cv=none; b=dN6dysB4VX5OirHUo4NsDswv5r42gXKNn/Bzfi3lyGVKF7JIol5+67QV3nA9kD+OlT6nEg /yPvUqBaKNc4c0WYp7dKjcZdWBFwN8x7e862iCUvAm0Bu6Ud0Qw19/ScB9/9FPLYDA/mXA AD/qj2WuTIEMHZ6XBwTsbVJrvnsuhozjQKroTcyaELiEKP9Yk9az0+CthHA7vFlfl4pNTw GWGc3a1kG2Sl3xKStK0iq8fwDgLUt0xaq2CbjwkxQaff0zySlxv03h/ONV/4QDFf7INyfq n+P+d0P6zqA/71vKB3RAdMeHoHPXXBlmoOQTLlvurwaQxJsofPwkMrCCDjn0uA== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1703981350; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=ATgzcCgPNw13l0cecZ1MooK8VYGlLhwVoyreAfDdWOM=; b=nFdlKQNygS19fpd1tSEArZlAs3/XnFgEzhRbK4rGiNogFH2iZ1Ymv6p6uhSrFfrcnJEQCc 5Ky6nig+pYfiunl2XaZXGYAQ8y0zbwBV6NDK4mrBMwIioQVr6GX+h5wzrI/6BGr57tw6YI JTp5b58lKtI/qx/WWfSVOLmdm00qJihYBpXtzEIHicyk4fYGLvzml93PFc0lwnCg1/O1Zo rvKXi7VccozbtySYbB2N0xTT7V7DSaOlp8II8tXkwccAqMgAABVi8DJQov6dRvl+XCrwVS /ZJ8YT+QietF2OHO27W1JaCFeDYoTqGeWe54vgyux0ugm+0ePUmzcmRwv4Rsqw== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4T2fc55mW8z19sQ; Sun, 31 Dec 2023 00:09:09 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.17.1/8.17.1) with ESMTP id 3BV099BL097803; Sun, 31 Dec 2023 00:09:09 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.17.1/8.17.1/Submit) id 3BV099J2097800; Sun, 31 Dec 2023 00:09:09 GMT (envelope-from git) Date: Sun, 31 Dec 2023 00:09:09 GMT Message-Id: <202312310009.3BV099J2097800@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Muhammad Moinur Rahman Subject: git: bbd8259de39f - main - databases/postgresql11: Sunset List-Id: Commits to the main branch of the FreeBSD ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-main List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-dev-commits-ports-main@freebsd.org X-BeenThere: dev-commits-ports-main@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: bofh X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: bbd8259de39f261bcd44716957c77536b3648bd6 Auto-Submitted: auto-generated The branch main has been updated by bofh: URL: https://cgit.FreeBSD.org/ports/commit/?id=bbd8259de39f261bcd44716957c77536b3648bd6 commit bbd8259de39f261bcd44716957c77536b3648bd6 Author: Muhammad Moinur Rahman AuthorDate: 2023-12-30 08:41:33 +0000 Commit: Muhammad Moinur Rahman CommitDate: 2023-12-31 00:06:40 +0000 databases/postgresql11: Sunset --- MOVED | 8 + Mk/Uses/pgsql.mk | 8 +- Mk/bsd.default-versions.mk | 2 +- databases/Makefile | 8 - databases/postgresql11-client/Makefile | 18 - databases/postgresql11-contrib/Makefile | 41 - databases/postgresql11-contrib/pkg-descr | 21 - databases/postgresql11-docs/Makefile | 3 - databases/postgresql11-pgtcl/Makefile | 12 - databases/postgresql11-plperl/Makefile | 6 - databases/postgresql11-plpython/Makefile | 6 - databases/postgresql11-pltcl/Makefile | 6 - databases/postgresql11-server/Makefile | 26 - databases/postgresql11-server/distinfo | 3 - databases/postgresql11-server/files/502.pgsql.in | 114 -- databases/postgresql11-server/files/dot.cshrc.in | 11 - databases/postgresql11-server/files/dot.profile.in | 22 - .../postgresql11-server/files/patch-doc-Makefile | 9 - .../files/patch-doc-src-sgml-Makefile | 41 - .../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 - .../postgresql11-server/files/pkg-message-pltcl.in | 9 - .../files/pkg-message-server.in | 69 - .../postgresql11-server/files/pkgIndex.tcl.in | 4 - databases/postgresql11-server/files/postgresql.in | 115 -- databases/postgresql11-server/pkg-descr | 21 - databases/postgresql11-server/pkg-install-server | 22 - databases/postgresql11-server/pkg-plist-client | 1203 ---------------- databases/postgresql11-server/pkg-plist-contrib | 266 ---- databases/postgresql11-server/pkg-plist-plperl | 21 - databases/postgresql11-server/pkg-plist-plpython | 47 - databases/postgresql11-server/pkg-plist-pltcl | 8 - databases/postgresql11-server/pkg-plist-server | 1517 -------------------- 38 files changed, 13 insertions(+), 3751 deletions(-) diff --git a/MOVED b/MOVED index 7848a4b24b53..0d1ef6abbe88 100644 --- a/MOVED +++ b/MOVED @@ -8356,3 +8356,11 @@ databases/php80-pdo_sqlite|databases/php81-pdo_sqlite|2023-12-31|Has expired: Se databases/php80-odbc|databases/php81-odbc|2023-12-31|Has expired: Security support ended on 2023-11-26 databases/php80-mysqli|databases/php81-mysqli|2023-12-31|Has expired: Security support ended on 2023-11-26 databases/php80-pdo_mysql|databases/php81-pdo_mysql|2023-12-31|Has expired: Security support ended on 2023-11-26 +databases/postgresql11-pltcl|databases/postgresql12-pltcl|2023-12-31|Has expired: Security support ended on 2023-11-09 +databases/postgresql11-docs|databases/postgresql12-docs|2023-12-31|Has expired: Security support ended on 2023-11-09 +databases/postgresql11-plperl|databases/postgresql12-plperl|2023-12-31|Has expired: Security support ended on 2023-11-09 +databases/postgresql11-server|databases/postgresql12-server|2023-12-31|Has expired: Security support ended on 2023-11-09 +databases/postgresql11-plpython|databases/postgresql12-plpython|2023-12-31|Has expired: Security support ended on 2023-11-09 +databases/postgresql11-contrib|databases/postgresql12-contrib|2023-12-31|Has expired: Security support ended on 2023-11-09 +databases/postgresql11-client|databases/postgresql12-client|2023-12-31|Has expired: Security support ended on 2023-11-09 +databases/postgresql11-pgtcl|databases/postgresql12-pgtcl|2023-12-31|Has expired: Security support ended on 2023-11-09 diff --git a/Mk/Uses/pgsql.mk b/Mk/Uses/pgsql.mk index 9a150f27fb08..e82d1ee5c58f 100644 --- a/Mk/Uses/pgsql.mk +++ b/Mk/Uses/pgsql.mk @@ -5,12 +5,12 @@ # # version Maintainer can set versions required. You can set this to # [min]-[max] or min+ or -max or as an explicit version -# (eg. 11-14 for [min]-[max], 11+ or 12- +# (eg. 12-14 for [min]-[max], 12+ or 12- # for min+ and max-, 13 for an explicit version). Example: # # USES=pgsql:13 # Only use PostgreSQL 13 -# USES=pgsql:11+ # Use PostgreSQL 11 or newer -# USES=pgsql:11-14 # Use PostgreSQL between 11 & 14 inclusive +# USES=pgsql:12+ # Use PostgreSQL 12 or newer +# USES=pgsql:12-14 # Use PostgreSQL between 12 & 14 inclusive # USES=pgsql:12- # Use any PostgreSQL up to 12 # USES=pgsql # Use the default PostgreSQL # @@ -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= 11 12 13 14 15 16 +VALID_PGSQL_VER= 12 13 14 15 16 # Override non-default LIBVERS like this: #PGSQL99_LIBVER=6 diff --git a/Mk/bsd.default-versions.mk b/Mk/bsd.default-versions.mk index fc36a542e75c..846d331eecab 100644 --- a/Mk/bsd.default-versions.mk +++ b/Mk/bsd.default-versions.mk @@ -124,7 +124,7 @@ _PERL5_FROM_BIN!= ${LOCALBASE}/bin/perl -e 'printf "%vd\n", $$^V;' _EXPORTED_VARS+= _PERL5_FROM_BIN PERL5_DEFAULT:= ${_PERL5_FROM_BIN:R} . endif -# Possible values: 11, 12, 13, 14, 15, 16 +# Possible values: 12, 13, 14, 15, 16 PGSQL_DEFAULT?= 15 # Possible values: 8.1, 8.2, 8.3 PHP_DEFAULT?= 8.2 diff --git a/databases/Makefile b/databases/Makefile index aa7e7b1cf7ac..fd36290f2847 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -645,14 +645,6 @@ SUBDIR += postgresql-tds_fdw SUBDIR += postgresql-wal2json SUBDIR += postgresql-zhparser - SUBDIR += postgresql11-client - SUBDIR += postgresql11-contrib - SUBDIR += postgresql11-docs - SUBDIR += postgresql11-pgtcl - SUBDIR += postgresql11-plperl - SUBDIR += postgresql11-plpython - SUBDIR += postgresql11-pltcl - SUBDIR += postgresql11-server SUBDIR += postgresql12-client SUBDIR += postgresql12-contrib SUBDIR += postgresql12-docs diff --git a/databases/postgresql11-client/Makefile b/databases/postgresql11-client/Makefile deleted file mode 100644 index e994cf8d13f6..000000000000 --- a/databases/postgresql11-client/Makefile +++ /dev/null @@ -1,18 +0,0 @@ -PORTNAME= postgresql -PORTREVISION= 0 - -COMMENT= PostgreSQL database (client) - -MASTERDIR= ${.CURDIR}/../postgresql11-server - -BUILD_DIRS= config src/include src/interfaces src/port \ - src/bin/pg_dump src/bin/psql src/bin/scripts src/bin/pg_config \ - src/bin/pgbench doc src/makefiles src/test/regress -INSTALL_DIRS= ${BUILD_DIRS} - -CLIENT_ONLY= yes -COMPONENT= -client -USE_LDCONFIG= yes -USES= pkgconfig - -.include "${MASTERDIR}/Makefile" diff --git a/databases/postgresql11-contrib/Makefile b/databases/postgresql11-contrib/Makefile deleted file mode 100644 index 6c562331adc8..000000000000 --- a/databases/postgresql11-contrib/Makefile +++ /dev/null @@ -1,41 +0,0 @@ -PORTNAME= postgresql -PORTREVISION= 0 -CATEGORIES= databases - -MAINTAINER= pgsql@FreeBSD.org -COMMENT= The contrib utilities from the PostgreSQL distribution - -MASTERDIR= ${.CURDIR}/../postgresql11-server - -USES= bison pgsql:${DISTVERSION:C/([0-9]\.?[0-9]).*/\1/g} - -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_LIB_DEPENDS=libxslt.so:textproc/libxslt \ - libxml2.so:textproc/libxml2 -XML_CONFIGURE_WITH= libxml libxslt - -post-configure: - @cd ${WRKSRC}/src/backend && ${SETENV} ${MAKE_ENV} ${MAKE_CMD} symlinks - -post-install: - @- ${INSTALL_DATA} ${WRKSRC}/contrib/README ${STAGEDIR}${DOCSDIR}/extension/README - -.include "${MASTERDIR}/Makefile" diff --git a/databases/postgresql11-contrib/pkg-descr b/databases/postgresql11-contrib/pkg-descr deleted file mode 100644 index a384c76fdbde..000000000000 --- a/databases/postgresql11-contrib/pkg-descr +++ /dev/null @@ -1,21 +0,0 @@ -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/postgresql11-docs/Makefile b/databases/postgresql11-docs/Makefile deleted file mode 100644 index 97c8c8b6fd41..000000000000 --- a/databases/postgresql11-docs/Makefile +++ /dev/null @@ -1,3 +0,0 @@ -WANT_PGSQL_VER=11 - -.include "${.CURDIR}/../postgresql16-docs/Makefile" diff --git a/databases/postgresql11-pgtcl/Makefile b/databases/postgresql11-pgtcl/Makefile deleted file mode 100644 index 38759ece692a..000000000000 --- a/databases/postgresql11-pgtcl/Makefile +++ /dev/null @@ -1,12 +0,0 @@ -PORTREVISION= 1 -PKGNAMESUFFIX= -postgresql11 - -DEPRECATED= PostgreSQL-11 will reach end-of-life on 2023-11-09 -EXPIRATION_DATE=2023-12-31 - -CONFLICTS= pgtcl pgtcl-postgresql1[012345] - -PGTCL_SLAVE= 11 -MASTERDIR= ${.CURDIR}/../pgtcl - -.include "${MASTERDIR}/Makefile" diff --git a/databases/postgresql11-plperl/Makefile b/databases/postgresql11-plperl/Makefile deleted file mode 100644 index ce2b6238a258..000000000000 --- a/databases/postgresql11-plperl/Makefile +++ /dev/null @@ -1,6 +0,0 @@ -WANT_PGSQL_VER= 11 - -# this port fails to build in parallel -MAKE_JOBS_UNSAFE= yes - -.include "${.CURDIR}/../postgresql16-plperl/Makefile" diff --git a/databases/postgresql11-plpython/Makefile b/databases/postgresql11-plpython/Makefile deleted file mode 100644 index 13afed4bee75..000000000000 --- a/databases/postgresql11-plpython/Makefile +++ /dev/null @@ -1,6 +0,0 @@ -WANT_PGSQL_VER= 11 - -# this port fails to build in parallel -MAKE_JOBS_UNSAFE= yes - -.include "${.CURDIR}/../postgresql16-plpython/Makefile" diff --git a/databases/postgresql11-pltcl/Makefile b/databases/postgresql11-pltcl/Makefile deleted file mode 100644 index d6a9a0fd30a0..000000000000 --- a/databases/postgresql11-pltcl/Makefile +++ /dev/null @@ -1,6 +0,0 @@ -WANT_PGSQL_VER= 11 - -# this port fails to build in parallel -MAKE_JOBS_UNSAFE= yes - -.include "${.CURDIR}/../postgresql16-pltcl/Makefile" diff --git a/databases/postgresql11-server/Makefile b/databases/postgresql11-server/Makefile deleted file mode 100644 index a33281f772f5..000000000000 --- a/databases/postgresql11-server/Makefile +++ /dev/null @@ -1,26 +0,0 @@ -DISTVERSION?= 11.22 -# 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?= 2 - -MAINTAINER?= pgsql@FreeBSD.org - -DEPRECATED= PostgreSQL-11 will reach end-of-life on 2023-11-09 -EXPIRATION_DATE=2023-12-31 - -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_controldata src/bin/pg_resetwal src/pl \ - src/bin/pg_basebackup src/bin/pg_archivecleanup \ - 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}/../postgresql16-server/Makefile" diff --git a/databases/postgresql11-server/distinfo b/databases/postgresql11-server/distinfo deleted file mode 100644 index 9561e9907bb9..000000000000 --- a/databases/postgresql11-server/distinfo +++ /dev/null @@ -1,3 +0,0 @@ -TIMESTAMP = 1699348854 -SHA256 (postgresql/postgresql-11.22.tar.bz2) = 2cb7c97d7a0d7278851bbc9c61f467b69c094c72b81740b751108e7892ebe1f0 -SIZE (postgresql/postgresql-11.22.tar.bz2) = 20482994 diff --git a/databases/postgresql11-server/files/502.pgsql.in b/databases/postgresql11-server/files/502.pgsql.in deleted file mode 100644 index 604ad3dadab8..000000000000 --- a/databases/postgresql11-server/files/502.pgsql.in +++ /dev/null @@ -1,114 +0,0 @@ -#!/bin/sh -# -# Maintenance shell script to vacuum and backup database -# Put this in /usr/local/etc/periodic/daily, and it will be run -# every night -# -# Written by Palle Girgensohn -# -# In public domain, do what you like with it, -# and use it at your own risk... :) -# - -# Define these variables in either /etc/periodic.conf or -# /etc/periodic.conf.local to override the default values. -# -# daily_pgsql_backup_enable="YES" # do backup of all databases -# daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases -# daily_pgsql_vacuum_enable="YES" # do vacuum - -# If there is a global system configuration file, suck it in. -# -if [ -r /etc/defaults/periodic.conf ] -then - . /etc/defaults/periodic.conf - source_periodic_confs -fi - -: ${daily_pgsql_user:="%%PG_USER%%"} -: ${daily_pgsql_port:=5432} -: ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"} -: ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"} -: ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"} -# backupdir is relative to ~pgsql home directory unless it begins with a slash: -: ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"} -: ${daily_pgsql_savedays:="7"} - -# allow '~' in directory name -eval backupdir=${daily_pgsql_backupdir} - -rc=0 - -pgsql_backup() { - # daily_pgsql_backupdir must be writeable by user %%PG_USER%% - # ~%%PG_USER%% is just that under normal circumstances, - # but this might not be where you want the backups... - if [ ! -d ${backupdir} ] ; then - echo Creating ${backupdir} - mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir} - fi - - echo - echo "PostgreSQL backups" - - # Protect the data - umask 077 - rc=$? - now=`date "+%Y-%m-%dT%H:%M:%S"` - file=${daily_pgsql_backupdir}/pgglobals_${now} - su -l ${daily_pgsql_user} -c \ - "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz" - - db=$1 - while shift; do - echo -n " $db" - file=${backupdir}/pgdump_${db}_${now} - su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" - [ $? -gt 0 ] && rc=3 - db=$1 - done - - if [ $rc -gt 0 ]; then - echo - echo "Errors were reported during backup." - fi - - # cleaning up old data - find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' -o -name '*.dat.gz' -o -name 'toc.dat' \) \ - -a -mtime +${daily_pgsql_savedays} -delete - echo -} - -case "$daily_pgsql_backup_enable" in - [Yy][Ee][Ss]) - dbnames=`su -l ${daily_pgsql_user} -c "umask 077; psql -U ${daily_pgsql_user} -p ${daily_pgsql_port} -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` - pgsql_backup $dbnames - ;; - - [Nn][Oo]) - ;; - - "") - ;; - - *) - pgsql_backup $daily_pgsql_backup_enable - ;; -esac - -case "$daily_pgsql_vacuum_enable" in - [Yy][Ee][Ss]) - - echo - echo "PostgreSQL vacuum" - su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}" - if [ $? -gt 0 ] - then - echo - echo "Errors were reported during vacuum." - rc=3 - fi - ;; -esac - -exit $rc diff --git a/databases/postgresql11-server/files/dot.cshrc.in b/databases/postgresql11-server/files/dot.cshrc.in deleted file mode 100644 index 17c9ee69a7d0..000000000000 --- a/databases/postgresql11-server/files/dot.cshrc.in +++ /dev/null @@ -1,11 +0,0 @@ -setenv PGLIB %%PREFIX%%/lib - -# note: PGDATA can be overridden by the -D startup option -setenv PGDATA $HOME/data96 - -#You might want to set some locale stuff here -#setenv PGDATESTYLE ISO -#setenv LC_ALL sv_SE.ISO_8859-1 - -# if you want to make regression tests use this TZ -#setenv TZ PST8PDT diff --git a/databases/postgresql11-server/files/dot.profile.in b/databases/postgresql11-server/files/dot.profile.in deleted file mode 100644 index 5be3e6a36ca9..000000000000 --- a/databases/postgresql11-server/files/dot.profile.in +++ /dev/null @@ -1,22 +0,0 @@ -PGLIB=%%PREFIX%%/lib - -# note: PGDATA can be overridden by the -D startup option -PGDATA=${HOME}/data96 - -export PATH PGLIB PGDATA - -# if you use the periodic script from share/postgresql/502.pgsql, you -# can set these -#PGDUMP_ARGS="-b -F c" -#PGBACKUPDIR=${HOME}/backups -#PGBACKUP_SAVE_DAYS=7 -#export PGBACKUPDIR PGDUMP_ARGS PGBACKUP_SAVE_DAYS - -#You might want to set some locale stuff here -#PGDATESTYLE=ISO -#LC_ALL=sv_SE.ISO_8859-1 -#export PGDATESTYLE LC_ALL - -# if you want to make regression tests use this TZ -#TZ=PST8PDT -#export TZ diff --git a/databases/postgresql11-server/files/patch-doc-Makefile b/databases/postgresql11-server/files/patch-doc-Makefile deleted file mode 100644 index d5176bfb64b5..000000000000 --- a/databases/postgresql11-server/files/patch-doc-Makefile +++ /dev/null @@ -1,9 +0,0 @@ ---- doc/Makefile.orig 2015-10-08 21:45:57.360084007 +0200 -+++ doc/Makefile 2015-10-08 21:46:04.353084097 +0200 -@@ -12,5 +12,5 @@ - top_builddir = .. - include $(top_builddir)/src/Makefile.global - --all distprep html man install installdirs uninstall clean distclean maintainer-clean: -+all distprep man install installdirs uninstall clean distclean maintainer-clean: - $(MAKE) -C src $@ diff --git a/databases/postgresql11-server/files/patch-doc-src-sgml-Makefile b/databases/postgresql11-server/files/patch-doc-src-sgml-Makefile deleted file mode 100644 index 36f5d2a8224c..000000000000 --- a/databases/postgresql11-server/files/patch-doc-src-sgml-Makefile +++ /dev/null @@ -1,41 +0,0 @@ ---- doc/src/sgml/Makefile.orig 2018-10-15 23:12:02.000000000 +0200 -+++ doc/src/sgml/Makefile 2018-10-18 22:34:13.656029000 +0200 -@@ -15,7 +15,7 @@ - - # Make "html" the default target, since that is what most people tend - # to want to use. --html: -+man: - - # We don't need the tree-wide headers or install support here. - NO_GENERATED_HEADERS=yes -@@ -26,7 +26,7 @@ - include $(top_builddir)/src/Makefile.global - - --all: html man -+all: man - - distprep: html distprep-man - -@@ -62,7 +62,6 @@ - ## Man pages - ## - --man distprep-man: man-stamp - - man-stamp: stylesheet-man.xsl postgres.sgml $(ALLSGML) - $(XMLLINT) $(XMLINCLUDE) --noout --valid $(word 2,$^) -@@ -212,10 +211,10 @@ - ## Install - ## - --install: install-html install-man -+install: install-man - - installdirs: -- $(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum)) -+ $(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum)) - - # If the install used a man directory shared with other applications, this will remove all files. - uninstall: diff --git a/databases/postgresql11-server/files/patch-src-Makefile.shlib b/databases/postgresql11-server/files/patch-src-Makefile.shlib deleted file mode 100644 index 2435ffe1d280..000000000000 --- a/databases/postgresql11-server/files/patch-src-Makefile.shlib +++ /dev/null @@ -1,11 +0,0 @@ ---- src/Makefile.shlib.bak 2013-05-06 22:57:06.000000000 +0200 -+++ src/Makefile.shlib 2013-05-12 23:33:16.000000000 +0200 -@@ -87,7 +87,7 @@ - # Testing the soname variable is a reliable way to determine whether a - # linkable library is being built. - soname = $(shlib_major) --pkgconfigdir = $(libdir)/pkgconfig -+pkgconfigdir = $(prefix)/libdata/pkgconfig - else - # Naming convention for dynamically loadable modules - shlib = $(NAME)$(DLSUFFIX) diff --git a/databases/postgresql11-server/files/patch-src-backend-Makefile b/databases/postgresql11-server/files/patch-src-backend-Makefile deleted file mode 100644 index ce8a8d558de1..000000000000 --- a/databases/postgresql11-server/files/patch-src-backend-Makefile +++ /dev/null @@ -1,11 +0,0 @@ ---- src/backend/Makefile.orig 2009-07-07 15:58:33.000000000 +0200 -+++ src/backend/Makefile 2009-07-07 15:58:57.000000000 +0200 -@@ -107,6 +107,8 @@ - # Update the commonly used headers before building the subdirectories - $(SUBDIRS:%=%-recursive): $(top_builddir)/src/include/parser/gram.h $(top_builddir)/src/include/utils/fmgroids.h $(top_builddir)/src/include/utils/probes.h - -+symlinks: $(top_builddir)/src/include/parser/gram.h $(top_builddir)/src/include/storage/lwlocknames.h -+ - - # The postgres.o target is needed by the rule in Makefile.global that - # creates the exports file when MAKE_EXPORTS = true. diff --git a/databases/postgresql11-server/files/patch-src_backend_utils_misc_postgresql.conf.sample b/databases/postgresql11-server/files/patch-src_backend_utils_misc_postgresql.conf.sample deleted file mode 100644 index 9469421174a0..000000000000 --- a/databases/postgresql11-server/files/patch-src_backend_utils_misc_postgresql.conf.sample +++ /dev/null @@ -1,10 +0,0 @@ ---- src/backend/utils/misc/postgresql.conf.sample.orig 2016-10-24 20:08:51 UTC -+++ src/backend/utils/misc/postgresql.conf.sample -@@ -330,6 +330,7 @@ - - # - Where to Log - - -+log_destination = 'syslog' - #log_destination = 'stderr' # Valid values are combinations of - # stderr, csvlog, syslog, and eventlog, - # depending on platform. csvlog diff --git a/databases/postgresql11-server/files/pkg-message-client.in b/databases/postgresql11-server/files/pkg-message-client.in deleted file mode 100644 index 404124204b7d..000000000000 --- a/databases/postgresql11-server/files/pkg-message-client.in +++ /dev/null @@ -1,38 +0,0 @@ -[ -{ type: install - message: < postgresql profile: ${profile}" - %%PREFIX%%/etc/rc.d/postgresql $1 ${profile} - retcode="$?" - if [ "0${retcode}" -ne 0 ]; then - failed="${profile} (${retcode}) ${failed:-}" - else - success="${profile} ${success:-}" - fi - done - exit 0 - fi -fi - -command_args="-D ${postgresql_data} ${postgresql_flags}" - -postgresql_command() -{ - ${su_cmd} -l -c ${postgresql_login_class} ${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}" -} - -run_rc_command "$1" diff --git a/databases/postgresql11-server/pkg-descr b/databases/postgresql11-server/pkg-descr deleted file mode 100644 index cbef6ffab2d8..000000000000 --- a/databases/postgresql11-server/pkg-descr +++ /dev/null @@ -1,21 +0,0 @@ -PostgreSQL is a sophisticated Object-Relational DBMS, supporting -almost all SQL constructs, including subselects, transactions, and -user-defined types and functions. It is the most advanced open-source -database available anywhere. Commercial Support is also available. - -The original Postgres code was the effort of many graduate students, -undergraduate students, and staff programmers working under the direction of -Professor Michael Stonebraker at the University of California, Berkeley. In -1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query -language to SQL and created a new database system which came to known as -Postgres95. Many others contributed to the porting, testing, debugging and -enhancement of the Postgres95 code. As the code improved, and 1995 faded into -memory, PostgreSQL was born. - -PostgreSQL development is presently being performed by a team of Internet -developers who are now responsible for all current and future development. The -development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG). -Support is available from the PostgreSQL developer/user community through the -support mailing list (questions@PostgreSQL.ORG). - -PostgreSQL is free and the complete source is available. diff --git a/databases/postgresql11-server/pkg-install-server b/databases/postgresql11-server/pkg-install-server deleted file mode 100644 index 07a10b84eaab..000000000000 --- a/databases/postgresql11-server/pkg-install-server +++ /dev/null @@ -1,22 +0,0 @@ -#! /bin/sh - -PATH=/bin:/usr/bin:/usr/sbin - -backupwarning() { -cat < 8.4), a dump - and restore of all databases is - required. This is *NOT* done by the port! - =========================================== -EOF -} - -case $2 in -PRE-INSTALL) - backupwarning - ;; -esac diff --git a/databases/postgresql11-server/pkg-plist-client b/databases/postgresql11-server/pkg-plist-client deleted file mode 100644 index 2fad7e92b47b..000000000000 --- a/databases/postgresql11-server/pkg-plist-client +++ /dev/null @@ -1,1203 +0,0 @@ -bin/clusterdb -bin/createdb -bin/createuser -bin/dropdb -bin/dropuser -bin/ecpg -bin/pg_config -bin/pg_dump *** 3084 LINES SKIPPED ***