From owner-dev-commits-ports-main@freebsd.org Sun Jun 13 10:51:45 2021 Return-Path: Delivered-To: dev-commits-ports-main@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 752DB65AAD3; Sun, 13 Jun 2021 10:51:45 +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 4G2rxF2nC7z3FPb; Sun, 13 Jun 2021 10:51:45 +0000 (UTC) (envelope-from git@FreeBSD.org) 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 477BA1F9F7; Sun, 13 Jun 2021 10:51:45 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.16.1/8.16.1) with ESMTP id 15DApjTp081196; Sun, 13 Jun 2021 10:51:45 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.16.1/8.16.1/Submit) id 15DApjSA081195; Sun, 13 Jun 2021 10:51:45 GMT (envelope-from git) Date: Sun, 13 Jun 2021 10:51:45 GMT Message-Id: <202106131051.15DApjSA081195@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Rene Ladan Subject: git: a3da90c5e4f1 - main - */*: Remove expired ports: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: rene X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: a3da90c5e4f183d6a61b55ac6da01974ab575ed1 Auto-Submitted: auto-generated X-BeenThere: dev-commits-ports-main@freebsd.org X-Mailman-Version: 2.1.34 Precedence: list List-Id: Commits to the main branch of the FreeBSD ports repository List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 13 Jun 2021 10:51:45 -0000 The branch main has been updated by rene: URL: https://cgit.FreeBSD.org/ports/commit/?id=a3da90c5e4f183d6a61b55ac6da01974ab575ed1 commit a3da90c5e4f183d6a61b55ac6da01974ab575ed1 Author: Rene Ladan AuthorDate: 2021-06-13 10:49:56 +0000 Commit: Rene Ladan CommitDate: 2021-06-13 10:50:22 +0000 */*: Remove expired ports: 2021-06-13 databases/postgresql95-client: PostgreSQL-9.5 has reached end-of-life 2021-06-13 databases/postgresql95-contrib: PostgreSQL-9.5 has reached end-of-life 2021-06-13 databases/postgresql95-docs: PostgreSQL-9.5 has reached end-of-life 2021-06-13 databases/postgresql95-pgtcl: PostgreSQL-9.5 has reached end-of-life 2021-06-13 databases/postgresql95-plperl: PostgreSQL-9.5 has reached end-of-life 2021-06-13 databases/postgresql95-plpython: PostgreSQL-9.5 has reached end-of-life 2021-06-13 databases/postgresql95-pltcl: PostgreSQL-9.5 has reached end-of-life 2021-06-13 databases/postgresql95-server: PostgreSQL-9.5 has reached end-of-life databases/pg_reorg: abandonware only for PostgreSQL 9.5 databases/pgespresso: functionality part of PostgreSQL 9.6 and later --- MOVED | 10 + databases/Makefile | 10 - databases/pg_reorg/Makefile | 29 - databases/pg_reorg/distinfo | 2 - databases/pg_reorg/pkg-descr | 5 - databases/pg_reorg/pkg-plist | 6 - databases/pgespresso/Makefile | 37 - databases/pgespresso/distinfo | 3 - databases/pgespresso/pkg-descr | 4 - databases/postgresql95-client/Makefile | 20 - databases/postgresql95-contrib/Makefile | 33 - databases/postgresql95-contrib/pkg-descr | 23 - databases/postgresql95-docs/Makefile | 5 - databases/postgresql95-pgtcl/Makefile | 9 - databases/postgresql95-plperl/Makefile | 10 - databases/postgresql95-plpython/Makefile | 8 - databases/postgresql95-plpython/pkg-descr | 6 - databases/postgresql95-pltcl/Makefile | 8 - databases/postgresql95-server/Makefile | 30 - databases/postgresql95-server/distinfo | 5 - databases/postgresql95-server/files/502.pgsql.in | 114 --- databases/postgresql95-server/files/dot.cshrc.in | 11 - databases/postgresql95-server/files/dot.profile.in | 22 - .../postgresql95-server/files/patch-doc-Makefile | 9 - .../files/patch-doc-src-sgml-Makefile | 46 - databases/postgresql95-server/files/patch-icu68 | 278 ------ .../files/patch-src-Makefile.shlib | 11 - .../files/patch-src-backend-Makefile | 11 - ...h-src_backend_utils_misc_postgresql.conf.sample | 21 - .../files/pkg-message-client.in | 38 - .../files/pkg-message-contrib.in | 9 - .../files/pkg-message-plperl.in | 9 - .../files/pkg-message-plpython.in | 9 - .../postgresql95-server/files/pkg-message-pltcl.in | 9 - .../files/pkg-message-server.in | 69 -- .../postgresql95-server/files/pkgIndex.tcl.in | 4 - databases/postgresql95-server/files/postgresql.in | 115 --- databases/postgresql95-server/pkg-descr | 23 - databases/postgresql95-server/pkg-install-server | 25 - databases/postgresql95-server/pkg-plist-client | 1020 -------------------- databases/postgresql95-server/pkg-plist-contrib | 200 ---- databases/postgresql95-server/pkg-plist-plperl | 15 - databases/postgresql95-server/pkg-plist-plpython | 28 - databases/postgresql95-server/pkg-plist-pltcl | 12 - databases/postgresql95-server/pkg-plist-server | 785 --------------- 45 files changed, 10 insertions(+), 3146 deletions(-) diff --git a/MOVED b/MOVED index 97cea9fd70d0..b5c8a6997720 100644 --- a/MOVED +++ b/MOVED @@ -16386,3 +16386,13 @@ net/py-python-keystoneclient3|net/py-python-keystoneclient|2021-06-10|Remove obs net/py-python-novaclient16|net/py-python-novaclient|2021-06-10|Remove obsoleted port. Use net/py-python-novaclient instead print/py-pycups1|print/py-pycups|2021-06-10|Remove obsoleted port. Use print/py-pycups instead lang/gcc8-devel|lang/gcc8|2021-06-11|GCC 8 reached end of life, use the final release (or a new major version) +databases/postgresql95-client||2021-06-13|Has expired: PostgreSQL-9.5 has reached end-of-life +databases/postgresql95-contrib||2021-06-13|Has expired: PostgreSQL-9.5 has reached end-of-life +databases/postgresql95-docs||2021-06-13|Has expired: PostgreSQL-9.5 has reached end-of-life +databases/postgresql95-pgtcl||2021-06-13|Has expired: PostgreSQL-9.5 has reached end-of-life +databases/postgresql95-plperl||2021-06-13|Has expired: PostgreSQL-9.5 has reached end-of-life +databases/postgresql95-plpython||2021-06-13|Has expired: PostgreSQL-9.5 has reached end-of-life +databases/postgresql95-pltcl||2021-06-13|Has expired: PostgreSQL-9.5 has reached end-of-life +databases/postgresql95-server||2021-06-13|Has expired: PostgreSQL-9.5 has reached end-of-life +databases/pg_reorg||2021-06-13|Removed, abandonware only for PostgreSQL 9.5 +databases/pgespresso||2021-06-13|Removed, functionality part of PostgreSQL 9.6 and later. diff --git a/databases/Makefile b/databases/Makefile index 988dc8f7876e..fe5c21a83929 100644 --- a/databases/Makefile +++ b/databases/Makefile @@ -569,7 +569,6 @@ SUBDIR += pg_hashids SUBDIR += pg_partman SUBDIR += pg_qualstats - SUBDIR += pg_reorg SUBDIR += pg_repack SUBDIR += pg_similarity SUBDIR += pg_stat_kcache @@ -580,7 +579,6 @@ SUBDIR += pgbarman SUBDIR += pgbouncer SUBDIR += pgdbf - SUBDIR += pgespresso SUBDIR += pgfouine SUBDIR += pgloader3 SUBDIR += pglogical @@ -708,14 +706,6 @@ SUBDIR += postgresql14-plpython SUBDIR += postgresql14-pltcl SUBDIR += postgresql14-server - SUBDIR += postgresql95-client - SUBDIR += postgresql95-contrib - SUBDIR += postgresql95-docs - SUBDIR += postgresql95-pgtcl - SUBDIR += postgresql95-plperl - SUBDIR += postgresql95-plpython - SUBDIR += postgresql95-pltcl - SUBDIR += postgresql95-server SUBDIR += postgresql96-client SUBDIR += postgresql96-contrib SUBDIR += postgresql96-docs diff --git a/databases/pg_reorg/Makefile b/databases/pg_reorg/Makefile deleted file mode 100644 index 041e8142c072..000000000000 --- a/databases/pg_reorg/Makefile +++ /dev/null @@ -1,29 +0,0 @@ -# Created by: Alexander Pyhalov - -PORTNAME= pg_reorg -PORTVERSION= 1.1.11 -PORTREVISION= 3 -CATEGORIES= databases -MASTER_SITES= http://pgfoundry.org/frs/download.php/3821/ \ - https://BSDforge.com/projects/source/databases/pg_reorg/ - -MAINTAINER= portmaster@BSDforge.com -COMMENT= PostgreSQL utility to reorganize tables - -LICENSE= BSD3CLAUSE -LICENSE_FILE= ${WRKSRC}/COPYRIGHT - -MAKE_ENV= USE_PGXS=0 -USES= gmake pgsql:9.5 uidfix -LLD_UNSAFE= yes -WANT_PGSQL= server -INSTALL_TARGET= install-strip -PORTDOCS= * - -OPTIONS_DEFINE= DOCS - -post-install: - @${MKDIR} ${STAGEDIR}${DOCSDIR} - (cd ${WRKSRC}/doc && ${COPYTREE_SHARE} . ${STAGEDIR}${DOCSDIR}) - -.include diff --git a/databases/pg_reorg/distinfo b/databases/pg_reorg/distinfo deleted file mode 100644 index 538e6809572d..000000000000 --- a/databases/pg_reorg/distinfo +++ /dev/null @@ -1,2 +0,0 @@ -SHA256 (pg_reorg-1.1.11.tar.gz) = 595641e0e6745f99897ffc4c229b084ca0f8b52002469e22a0cf7c0ba676ec33 -SIZE (pg_reorg-1.1.11.tar.gz) = 74228 diff --git a/databases/pg_reorg/pkg-descr b/databases/pg_reorg/pkg-descr deleted file mode 100644 index 106c56e6e9a3..000000000000 --- a/databases/pg_reorg/pkg-descr +++ /dev/null @@ -1,5 +0,0 @@ -pg_reorg can reorganize tables of a PostgreSQL database without any locks, -so that you can retrieve or update rows in tables being reorganized. The -module is developed to be a better alternative to CLUSTER and VACUUM FULL. - -WWW: https://BSDforge.com/projects/databases/pg_reorg/ diff --git a/databases/pg_reorg/pkg-plist b/databases/pg_reorg/pkg-plist deleted file mode 100644 index 9985fb520f88..000000000000 --- a/databases/pg_reorg/pkg-plist +++ /dev/null @@ -1,6 +0,0 @@ -bin/pg_reorg -lib/postgresql/pg_reorg.so -share/postgresql/extension/pg_reorg--1.1.11.sql -share/postgresql/extension/pg_reorg.control -share/postgresql/extension/pg_reorg.sql -share/postgresql/extension/uninstall_pg_reorg.sql diff --git a/databases/pgespresso/Makefile b/databases/pgespresso/Makefile deleted file mode 100644 index cba20d4ed2fe..000000000000 --- a/databases/pgespresso/Makefile +++ /dev/null @@ -1,37 +0,0 @@ -# Created by: Matthew Seaman - -PORTNAME= pgespresso -PORTVERSION= 1.2 -PORTREVISION= 4 -CATEGORIES= databases - -MAINTAINER= matthew@FreeBSD.org -COMMENT= Optional extension to Barman backup and recovery manager - -LICENSE= PostgreSQL - -USE_GITHUB= yes -GH_ACCOUNT= 2ndquadrant-it - -USES= gmake pgsql:9.5 -LLD_UNSAFE= yes -WANT_PGSQL= server - -PLIST_FILES= lib/postgresql/pgespresso.so \ - share/postgresql/extension/pgespresso--1.0--1.1.sql \ - share/postgresql/extension/pgespresso--1.1--1.2.sql \ - share/postgresql/extension/pgespresso--1.2.sql \ - share/postgresql/extension/pgespresso.control - -PORTDOCS= README.asciidoc - -INSTALL_TARGET= install-strip -MAKE_ARGS= INSTALL="${INSTALL} -c" - -OPTIONS_DEFINE= DOCS - -post-install: - ${MKDIR} ${STAGEDIR}${DOCSDIR}/ - ${INSTALL_MAN} ${WRKSRC}/${PORTDOCS} ${STAGEDIR}${DOCSDIR}/ - -.include diff --git a/databases/pgespresso/distinfo b/databases/pgespresso/distinfo deleted file mode 100644 index 99801ea83c8e..000000000000 --- a/databases/pgespresso/distinfo +++ /dev/null @@ -1,3 +0,0 @@ -TIMESTAMP = 1469169767 -SHA256 (2ndquadrant-it-pgespresso-1.2_GH0.tar.gz) = ca989aa3713e5d0e066685d9db07db9854e56e43a67d4a06883ab84193a7b997 -SIZE (2ndquadrant-it-pgespresso-1.2_GH0.tar.gz) = 10290 diff --git a/databases/pgespresso/pkg-descr b/databases/pgespresso/pkg-descr deleted file mode 100644 index c448cc9b15c7..000000000000 --- a/databases/pgespresso/pkg-descr +++ /dev/null @@ -1,4 +0,0 @@ -pgespresso is an extension to postgresql that adds functions and views -to be used by Barman, the disaster recovery tool - -WWW: https://github.com/2ndquadrant-it/pgespresso diff --git a/databases/postgresql95-client/Makefile b/databases/postgresql95-client/Makefile deleted file mode 100644 index 74b2b6597d0f..000000000000 --- a/databases/postgresql95-client/Makefile +++ /dev/null @@ -1,20 +0,0 @@ -# Created by: Palle Girgensohn - -PORTNAME= postgresql -PORTREVISION= 0 - -COMMENT= PostgreSQL database (client) - -MASTERDIR= ${.CURDIR}/../postgresql95-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/postgresql95-contrib/Makefile b/databases/postgresql95-contrib/Makefile deleted file mode 100644 index 676564193d16..000000000000 --- a/databases/postgresql95-contrib/Makefile +++ /dev/null @@ -1,33 +0,0 @@ -# Created by: Palle Girgensohn - -PORTNAME= postgresql -PORTREVISION= 0 -CATEGORIES= databases - -MAINTAINER= pgsql@FreeBSD.org -COMMENT= The contrib utilities from the PostgreSQL distribution - -LIB_DEPENDS= libxslt.so:textproc/libxslt \ - libxml2.so:textproc/libxml2 - -MASTERDIR= ${.CURDIR}/../postgresql95-server - -USES= bison pgsql:${DISTVERSION:C/([0-9]\.?[0-9]).*/\1/g} - -# this port fails to build in parallel -MAKE_JOBS_UNSAFE= yes - -BUILD_DIRS= src/port src/common contrib -INSTALL_DIRS= contrib - -SLAVE_ONLY= yes -COMPONENT= -contrib -CONFIGURE_ARGS+=--with-libxslt --with-libxml --with-openssl --disable-nls --with-uuid=bsd -LDFLAGS+= -lpthread -L${PREFIX}/lib - -OPTIONS_DEFINE= DOCS - -post-install: - @- ${INSTALL_DATA} ${WRKSRC}/contrib/README ${STAGEDIR}${DOCSDIR}/extension/README - -.include "${MASTERDIR}/Makefile" diff --git a/databases/postgresql95-contrib/pkg-descr b/databases/postgresql95-contrib/pkg-descr deleted file mode 100644 index 18c3c1351c3b..000000000000 --- a/databases/postgresql95-contrib/pkg-descr +++ /dev/null @@ -1,23 +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. - -WWW: https://www.postgresql.org/ diff --git a/databases/postgresql95-docs/Makefile b/databases/postgresql95-docs/Makefile deleted file mode 100644 index 0324ba2c38db..000000000000 --- a/databases/postgresql95-docs/Makefile +++ /dev/null @@ -1,5 +0,0 @@ -# Created by: Palle Girgensohn - -WANT_PGSQL_VER=9.5 - -.include "${.CURDIR}/../postgresql14-docs/Makefile" diff --git a/databases/postgresql95-pgtcl/Makefile b/databases/postgresql95-pgtcl/Makefile deleted file mode 100644 index 407f46721782..000000000000 --- a/databases/postgresql95-pgtcl/Makefile +++ /dev/null @@ -1,9 +0,0 @@ -PORTREVISION= 0 -PKGNAMESUFFIX= -postgresql95 - -CONFLICTS= pgtcl-[0-9]* pgtcl-postgresql9[01234]-[0-9]* - -PGTCL_SLAVE= 9.5 -MASTERDIR= ${.CURDIR}/../pgtcl - -.include "${MASTERDIR}/Makefile" diff --git a/databases/postgresql95-plperl/Makefile b/databases/postgresql95-plperl/Makefile deleted file mode 100644 index f79b6bac3eca..000000000000 --- a/databases/postgresql95-plperl/Makefile +++ /dev/null @@ -1,10 +0,0 @@ -# Created by: Palle Girgensohn - -WANT_PGSQL_VER= 9.5 - -INSTALL_DIRS= src/pl/plperl contrib/hstore_plperl - -# this port fails to build in parallel -MAKE_JOBS_UNSAFE= yes - -.include "${.CURDIR}/../postgresql14-plperl/Makefile" diff --git a/databases/postgresql95-plpython/Makefile b/databases/postgresql95-plpython/Makefile deleted file mode 100644 index 3ab634d877cf..000000000000 --- a/databases/postgresql95-plpython/Makefile +++ /dev/null @@ -1,8 +0,0 @@ -WANT_PGSQL_VER= 9.5 - -INSTALL_DIRS= src/pl/plpython contrib/hstore_plpython contrib/ltree_plpython - -# this port fails to build in parallel -MAKE_JOBS_UNSAFE= yes - -.include "${.CURDIR}/../postgresql14-plpython/Makefile" diff --git a/databases/postgresql95-plpython/pkg-descr b/databases/postgresql95-plpython/pkg-descr deleted file mode 100644 index 416cce467d37..000000000000 --- a/databases/postgresql95-plpython/pkg-descr +++ /dev/null @@ -1,6 +0,0 @@ -PL/Python allows one to write PostgeSQL stored functions and -procedures in Python (http://www.python.org/). - -This software is part of the standard PostgreSQL distribution. - -WWW: https://www.postgresql.org/ diff --git a/databases/postgresql95-pltcl/Makefile b/databases/postgresql95-pltcl/Makefile deleted file mode 100644 index a4522ff702bd..000000000000 --- a/databases/postgresql95-pltcl/Makefile +++ /dev/null @@ -1,8 +0,0 @@ -# Created by: Palle Girgensohn - -WANT_PGSQL_VER= 9.5 - -# this port fails to build in parallel -MAKE_JOBS_UNSAFE= yes - -.include "${.CURDIR}/../postgresql14-pltcl/Makefile" diff --git a/databases/postgresql95-server/Makefile b/databases/postgresql95-server/Makefile deleted file mode 100644 index 8074f338f233..000000000000 --- a/databases/postgresql95-server/Makefile +++ /dev/null @@ -1,30 +0,0 @@ -# Created by: Marc G. Fournier - -DISTVERSION?= 9.5.25 -# 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 -PKGNAMESUFFIX?= ${PORTVERSION:R:S/.//}${COMPONENT} - -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/bin/initdb src/bin/pg_ctl \ - src/bin/pg_controldata src/bin/pg_resetxlog 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_xlogdump src/bin/pg_upgrade - -ICU_PATCHFILE= pg-954-icu-2016-08-10.diff.gz - -PG_USER?= pgsql -PG_GROUP?= pgsql -PG_UID?= 70 - -DEPRECATED= PostgreSQL-9.5 has reached end-of-life -EXPIRATION_DATE=2021-06-13 - -.include "${.CURDIR}/../postgresql14-server/Makefile" diff --git a/databases/postgresql95-server/distinfo b/databases/postgresql95-server/distinfo deleted file mode 100644 index b2da66a79c41..000000000000 --- a/databases/postgresql95-server/distinfo +++ /dev/null @@ -1,5 +0,0 @@ -TIMESTAMP = 1612956696 -SHA256 (postgresql/postgresql-9.5.25.tar.bz2) = 7628c55eb23768a2c799c018988d8f2ab48ee3d80f5e11259938f7a935f0d603 -SIZE (postgresql/postgresql-9.5.25.tar.bz2) = 17923796 -SHA256 (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5fa083ec38087d6a0961642208f012e902221270708b919b92e9eedaa755e365 -SIZE (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5952 diff --git a/databases/postgresql95-server/files/502.pgsql.in b/databases/postgresql95-server/files/502.pgsql.in deleted file mode 100644 index b1416697fa45..000000000000 --- a/databases/postgresql95-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 dir 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/postgresql95-server/files/dot.cshrc.in b/databases/postgresql95-server/files/dot.cshrc.in deleted file mode 100644 index 4069398b376e..000000000000 --- a/databases/postgresql95-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/data - -#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/postgresql95-server/files/dot.profile.in b/databases/postgresql95-server/files/dot.profile.in deleted file mode 100644 index 954e22eae8f8..000000000000 --- a/databases/postgresql95-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}/data - -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/postgresql95-server/files/patch-doc-Makefile b/databases/postgresql95-server/files/patch-doc-Makefile deleted file mode 100644 index d5176bfb64b5..000000000000 --- a/databases/postgresql95-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/postgresql95-server/files/patch-doc-src-sgml-Makefile b/databases/postgresql95-server/files/patch-doc-src-sgml-Makefile deleted file mode 100644 index 6e9522b1e45a..000000000000 --- a/databases/postgresql95-server/files/patch-doc-src-sgml-Makefile +++ /dev/null @@ -1,46 +0,0 @@ ---- doc/src/sgml/Makefile.orig 2015-10-05 21:09:44.000000000 +0200 -+++ doc/src/sgml/Makefile 2015-10-09 01:02:37.164797000 +0200 -@@ -15,7 +15,7 @@ - - # Make "html" the default target, since that is what most people tend - # to want to use. --html: -+man: - - NO_TEMP_INSTALL=yes - -@@ -24,7 +24,7 @@ - include $(top_builddir)/src/Makefile.global - - --all: html man -+all: man - - distprep: html distprep-man - -@@ -81,8 +81,6 @@ - ## Man pages - ## - --man distprep-man: man-stamp -- - man-stamp: stylesheet-man.xsl postgres.xml - $(XMLLINT) --noout --valid postgres.xml - $(XSLTPROC) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $^ -@@ -326,14 +324,14 @@ - ## Install - ## - --install: install-html -+install: install-man - - ifneq ($(PORTNAME), sco) - install: install-man - endif - - 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/postgresql95-server/files/patch-icu68 b/databases/postgresql95-server/files/patch-icu68 deleted file mode 100644 index 90cd386d9480..000000000000 --- a/databases/postgresql95-server/files/patch-icu68 +++ /dev/null @@ -1,278 +0,0 @@ -Regressed by https://github.com/unicode-org/icu/commit/c3fe7e09d844 - -dbcommands.c:770:1: error: conflicting types for 'dropdb' -dropdb(const char *dbname, bool missing_ok) -^ -../../../src/include/commands/dbcommands.h:23:13: note: previous declaration is here -extern void dropdb(const char *dbname, bool missing_ok); - ^ -dbcommands.c:1367:1: error: conflicting types for 'AlterDatabase' -AlterDatabase(AlterDatabaseStmt *stmt, bool isTopLevel) -^ -../../../src/include/commands/dbcommands.h:25:12: note: previous declaration is here -extern Oid AlterDatabase(AlterDatabaseStmt *stmt, bool isTopLevel); - ^ -dbcommands.c:1977:1: error: conflicting types for 'get_database_oid' -get_database_oid(const char *dbname, bool missing_ok) -^ -../../../src/include/commands/dbcommands.h:29:12: note: previous declaration is here -extern Oid get_database_oid(const char *dbname, bool missingok); - ^ -indxpath.c:2917:1: error: conflicting types for 'relation_has_unique_index_for' -relation_has_unique_index_for(PlannerInfo *root, RelOptInfo *rel, -^ -../../../../src/include/optimizer/paths.h:66:13: note: previous declaration is here -extern bool relation_has_unique_index_for(PlannerInfo *root, RelOptInfo *rel, - ^ -indxpath.c:3091:1: error: conflicting types for 'match_index_to_operand' -match_index_to_operand(Node *operand, -^ -../../../../src/include/optimizer/paths.h:69:13: note: previous declaration is here -extern bool match_index_to_operand(Node *operand, int indexcol, - ^ -indxpath.c:3735:1: error: conflicting types for 'adjust_rowcompare_for_index' -adjust_rowcompare_for_index(RowCompareExpr *clause, -^ -../../../../src/include/optimizer/paths.h:75:14: note: previous declaration is here -extern Expr *adjust_rowcompare_for_index(RowCompareExpr *clause, - ^ -regis.c:31:1: error: conflicting types for 'RS_isRegis' -RS_isRegis(const char *str) -^ -../../../src/include/tsearch/dicts/regis.h:41:7: note: previous declaration is here -bool RS_isRegis(const char *str); - ^ -regis.c:85:1: error: conflicting types for 'RS_compile' -RS_compile(Regis *r, bool issuffix, const char *str) -^ -../../../src/include/tsearch/dicts/regis.h:43:7: note: previous declaration is here -void RS_compile(Regis *r, bool issuffix, const char *str); - ^ -regis.c:218:1: error: conflicting types for 'RS_execute' -RS_execute(Regis *r, char *str) -^ -../../../src/include/tsearch/dicts/regis.h:47:7: note: previous declaration is here -bool RS_execute(Regis *r, char *str); - ^ -varlena.c:1845:1: error: conflicting types for 'varstr_sortsupport' -varstr_sortsupport(SortSupport ssup, Oid collid, bool bpchar) -^ -../../../../src/include/utils/builtins.h:849:13: note: previous declaration is here -extern void varstr_sortsupport(SortSupport ssup, Oid collid, bool bpchar); - ^ -varlena.c:3264:1: error: conflicting types for 'SplitIdentifierString' -SplitIdentifierString(char *rawstring, char separator, -^ -../../../../src/include/utils/builtins.h:859:13: note: previous declaration is here -extern bool SplitIdentifierString(char *rawstring, char separator, - ^ -varlena.c:3389:1: error: conflicting types for 'SplitDirectoriesString' -SplitDirectoriesString(char *rawstring, char separator, -^ -../../../../src/include/utils/builtins.h:861:13: note: previous declaration is here -extern bool SplitDirectoriesString(char *rawstring, char separator, - ^ -varlena.c:3510:1: error: conflicting types for 'SplitGUCList' -SplitGUCList(char *rawstring, char separator, -^ -../../../../src/include/utils/builtins.h:863:13: note: previous declaration is here -extern bool SplitGUCList(char *rawstring, char separator, - ^ -varlena.c:4022:1: error: conflicting types for 'replace_text_regexp' -replace_text_regexp(text *src_text, void *regexp, -^ -../../../../src/include/utils/builtins.h:866:14: note: previous declaration is here -extern text *replace_text_regexp(text *src_text, void *regexp, - ^ -In file included from varlena.c:5586: -./levenshtein.c:73:1: error: conflicting types for 'varstr_levenshtein' -varstr_levenshtein(const char *source, int slen, -^ -../../../../src/include/utils/builtins.h:850:12: note: previous declaration is here -extern int varstr_levenshtein(const char *source, int slen, - ^ -In file included from varlena.c:5588: -./levenshtein.c:68:1: error: conflicting types for 'varstr_levenshtein_less_equal' -varstr_levenshtein_less_equal(const char *source, int slen, -^ -../../../../src/include/utils/builtins.h:854:12: note: previous declaration is here -extern int varstr_levenshtein_less_equal(const char *source, int slen, - ^ -guc.c:408:7: error: redefinition of 'log_duration' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_duration = false; - ^ -../../../../src/include/utils/guc.h:233:13: note: previous declaration is here -extern bool log_duration; - ^ -guc.c:409:7: error: redefinition of 'Debug_print_plan' with a different type: 'bool' vs 'bool' (aka 'char') -bool Debug_print_plan = false; - ^ -../../../../src/include/utils/guc.h:234:13: note: previous declaration is here -extern bool Debug_print_plan; - ^ -guc.c:410:7: error: redefinition of 'Debug_print_parse' with a different type: 'bool' vs 'bool' (aka 'char') -bool Debug_print_parse = false; - ^ -../../../../src/include/utils/guc.h:235:13: note: previous declaration is here -extern bool Debug_print_parse; - ^ -guc.c:411:7: error: redefinition of 'Debug_print_rewritten' with a different type: 'bool' vs 'bool' (aka 'char') -bool Debug_print_rewritten = false; - ^ -../../../../src/include/utils/guc.h:236:13: note: previous declaration is here -extern bool Debug_print_rewritten; - ^ -guc.c:412:7: error: redefinition of 'Debug_pretty_print' with a different type: 'bool' vs 'bool' (aka 'char') -bool Debug_pretty_print = true; - ^ -../../../../src/include/utils/guc.h:237:13: note: previous declaration is here -extern bool Debug_pretty_print; - ^ -guc.c:414:7: error: redefinition of 'log_parser_stats' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_parser_stats = false; - ^ -../../../../src/include/utils/guc.h:239:13: note: previous declaration is here -extern bool log_parser_stats; - ^ -guc.c:415:7: error: redefinition of 'log_planner_stats' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_planner_stats = false; - ^ -../../../../src/include/utils/guc.h:240:13: note: previous declaration is here -extern bool log_planner_stats; - ^ -guc.c:416:7: error: redefinition of 'log_executor_stats' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_executor_stats = false; - ^ -../../../../src/include/utils/guc.h:241:13: note: previous declaration is here -extern bool log_executor_stats; - ^ -guc.c:417:7: error: redefinition of 'log_statement_stats' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_statement_stats = false; /* this is sort of all three - ^ -../../../../src/include/utils/guc.h:242:13: note: previous declaration is here -extern bool log_statement_stats; - ^ -guc.c:419:7: error: redefinition of 'log_btree_build_stats' with a different type: 'bool' vs 'bool' (aka 'char') -bool log_btree_build_stats = false; - ^ -../../../../src/include/utils/guc.h:243:13: note: previous declaration is here -extern bool log_btree_build_stats; - ^ -guc.c:423:7: error: redefinition of 'check_function_bodies' with a different type: 'bool' vs 'bool' (aka 'char') -bool check_function_bodies = true; - ^ -../../../../src/include/utils/guc.h:245:25: note: previous declaration is here -extern PGDLLIMPORT bool check_function_bodies; - ^ -guc.c:424:7: error: redefinition of 'default_with_oids' with a different type: 'bool' vs 'bool' (aka 'char') -bool default_with_oids = false; - ^ -../../../../src/include/utils/guc.h:246:13: note: previous declaration is here -extern bool default_with_oids; - ^ -guc.c:425:7: error: redefinition of 'SQL_inheritance' with a different type: 'bool' vs 'bool' (aka 'char') -bool SQL_inheritance = true; - ^ -../../../../src/include/utils/guc.h:247:13: note: previous declaration is here -extern bool SQL_inheritance; - ^ -guc.c:428:7: error: redefinition of 'session_auth_is_superuser' with a different type: 'bool' vs 'bool' (aka 'char') -bool session_auth_is_superuser; - ^ -../../../../src/include/utils/guc.h:248:13: note: previous declaration is here -extern bool session_auth_is_superuser; - ^ -guc.c:4599:1: error: conflicting types for 'SelectConfigFiles' -SelectConfigFiles(const char *userDoption, const char *progname) -^ -../../../../src/include/utils/guc.h:355:13: note: previous declaration is here -extern bool SelectConfigFiles(const char *userDoption, const char *progname); - ^ -guc.c:4989:1: error: conflicting types for 'AtEOXact_GUC' -AtEOXact_GUC(bool isCommit, int nestLevel) -^ -../../../../src/include/utils/guc.h:359:13: note: previous declaration is here -extern void AtEOXact_GUC(bool isCommit, int nestLevel); - ^ -guc.c:5407:1: error: conflicting types for 'parse_int' -parse_int(const char *value, int *result, int flags, const char **hintmsg) -^ -../../../../src/include/utils/guc.h:362:13: note: previous declaration is here -extern bool parse_int(const char *value, int *result, int flags, - ^ -guc.c:5493:1: error: conflicting types for 'parse_real' -parse_real(const char *value, double *result) -^ -../../../../src/include/utils/guc.h:364:13: note: previous declaration is here -extern bool parse_real(const char *value, double *result); - ^ -guc.c:5554:1: error: conflicting types for 'config_enum_lookup_by_name' -config_enum_lookup_by_name(struct config_enum * record, const char *value, -^ -../../../../src/include/utils/guc_tables.h:264:13: note: previous declaration is here -extern bool config_enum_lookup_by_name(struct config_enum * record, - ^ -fatal error: too many errors emitted, stopping now [-ferror-limit=] - ---- src/backend/commands/dbcommands.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/commands/dbcommands.c -@@ -19,6 +19,7 @@ - */ - #include "postgres.h" - -+#include - #include - #include - #include ---- src/backend/optimizer/path/indxpath.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/optimizer/path/indxpath.c -@@ -15,6 +15,7 @@ - */ - #include "postgres.h" - -+#include - #include - - #include "access/stratnum.h" ---- src/backend/tsearch/regis.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/tsearch/regis.c -@@ -14,6 +14,8 @@ - - #include "postgres.h" - -+#include -+ - #include "tsearch/dicts/regis.h" - #include "tsearch/ts_locale.h" - ---- src/backend/utils/adt/levenshtein.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/utils/adt/levenshtein.c -@@ -23,6 +23,8 @@ - * - *------------------------------------------------------------------------- - */ -+#include -+ - #define MAX_LEVENSHTEIN_STRLEN 255 - - /* ---- src/backend/utils/adt/varlena.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/utils/adt/varlena.c -@@ -14,6 +14,7 @@ - */ - #include "postgres.h" - -+#include - #include - #include - ---- src/backend/utils/misc/guc.c.orig 2020-08-10 21:21:12 UTC -+++ src/backend/utils/misc/guc.c -@@ -16,6 +16,7 @@ - */ - #include "postgres.h" - -+#include *** 2530 LINES SKIPPED ***