git: bbd8259de39f - main - databases/postgresql11: Sunset

From: Muhammad Moinur Rahman <bofh_at_FreeBSD.org>
Date: Sun, 31 Dec 2023 00:09:09 UTC
The branch main has been updated by bofh:

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

commit bbd8259de39f261bcd44716957c77536b3648bd6
Author:     Muhammad Moinur Rahman <bofh@FreeBSD.org>
AuthorDate: 2023-12-30 08:41:33 +0000
Commit:     Muhammad Moinur Rahman <bofh@FreeBSD.org>
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 <girgen@pingpong.net>
-#
-# 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: <<EOM
-The PostgreSQL port has a collection of "side orders":
-
-postgresql-docs
-  For all of the html documentation
-
-p5-Pg
-  A perl5 API for client access to PostgreSQL databases.
-
-postgresql-tcltk 
-  If you want tcl/tk client support.
-
-postgresql-jdbc
-  For Java JDBC support.
-
-postgresql-odbc
-  For client access from unix applications using ODBC as access
-  method. Not needed to access unix PostgreSQL servers from Win32
-  using ODBC. See below.
-
-ruby-postgres, py-psycopg2
-  For client access to PostgreSQL databases using the ruby & python
-  languages.
-
-postgresql-plperl, postgresql-pltcl & postgresql-plruby
-  For using perl5, tcl & ruby as procedural languages.
-
-postgresql-contrib
-  Lots of contributed utilities, postgresql functions and
-  datatypes. There you find pg_standby, pgcrypto and many other cool
-  things.
-
-etc...
-EOM
-}
-]
diff --git a/databases/postgresql11-server/files/pkg-message-contrib.in b/databases/postgresql11-server/files/pkg-message-contrib.in
deleted file mode 100644
index 2d9f3d86e71c..000000000000
--- a/databases/postgresql11-server/files/pkg-message-contrib.in
+++ /dev/null
@@ -1,9 +0,0 @@
-[
-{ type: install
-  message: <<EOM
-The PostgreSQL contrib utilities have been installed. Please see
-%%PREFIX%%/share/doc/postgresql/contrib/README
-for more information.
-EOM
-}
-]
diff --git a/databases/postgresql11-server/files/pkg-message-plperl.in b/databases/postgresql11-server/files/pkg-message-plperl.in
deleted file mode 100644
index dbda7daff5c2..000000000000
--- a/databases/postgresql11-server/files/pkg-message-plperl.in
+++ /dev/null
@@ -1,9 +0,0 @@
-[
-{ type: install
-  message: <<EOM
-PL/Perl has been installed. Check the createlang(l) manpage for more
-info. You can install PL/Perl as trusted or untrusted, by using either
-"createlang plperl" or "createlang plperlu".
-EOM
-}
-]
diff --git a/databases/postgresql11-server/files/pkg-message-plpython.in b/databases/postgresql11-server/files/pkg-message-plpython.in
deleted file mode 100644
index 3bd80d73d177..000000000000
--- a/databases/postgresql11-server/files/pkg-message-plpython.in
+++ /dev/null
@@ -1,9 +0,0 @@
-[
-{ type: install
-  message: <<EOM
-PL/Python has been installed. Check the createlang(l) manpage for more
-info. You can install PL/Python by using "createlang plpythonu" (it
-exists as an untrusted language only).
-EOM
-}
-]
diff --git a/databases/postgresql11-server/files/pkg-message-pltcl.in b/databases/postgresql11-server/files/pkg-message-pltcl.in
deleted file mode 100644
index c1776f7d6fb3..000000000000
--- a/databases/postgresql11-server/files/pkg-message-pltcl.in
+++ /dev/null
@@ -1,9 +0,0 @@
-[
-{ type: install
-  message: <<EOM
-PL/Tcl has been  installed. Check the createlang(l) manpage for more
-info. You can install pltcl as trusted or untrusted, by using either
-"createlang pltcl" or "createlang pltclu".
-EOM
-}
-]
diff --git a/databases/postgresql11-server/files/pkg-message-server.in b/databases/postgresql11-server/files/pkg-message-server.in
deleted file mode 100644
index 31703d7896bf..000000000000
--- a/databases/postgresql11-server/files/pkg-message-server.in
+++ /dev/null
@@ -1,69 +0,0 @@
-[
-{ type: install
-  message: <<EOM
-For procedural languages and postgresql functions, please note that
-you might have to update them when updating the server.
-
-If you have many tables and many clients running, consider raising
-kern.maxfiles using sysctl(8), or reconfigure your kernel
-appropriately.
-
-The port is set up to use autovacuum for new databases, but you might
-also want to vacuum and perhaps backup your database regularly. There
-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.
-
-If you plan to access your PostgreSQL server using ODBC, please
-consider running the SQL script %%PREFIX%%/share/postgresql/odbc.sql
-to get the functions required for ODBC compliance.
-
-Please note that if you use the rc script,
-%%PREFIX%%/etc/rc.d/postgresql, to initialize the database, unicode
-(UTF-8) will be used to store character data by default.  Set
-postgresql_initdb_flags or use login.conf settings described below to
-alter this behaviour. See the start rc script for more info.
-
-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:\
-	:lang=en_US.UTF-8:\
-	:setenv=LC_COLLATE=C:\
-	:tc=default:
----
-and run `cap_mkdb /etc/login.conf'.
-Then add 'postgresql_login_class="postgres"' to /etc/rc.conf.
-
-======================================================================
-
-To initialize the database, run
-
-  %%PREFIX%%/etc/rc.d/postgresql initdb
-
-You can then start PostgreSQL by running:
-
-  %%PREFIX%%/etc/rc.d/postgresql start
-
-For postmaster settings, see ~postgres/data/postgresql.conf
-
-NB. FreeBSD's PostgreSQL port logs to syslog by default
-    See ~postgres/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 only be enabled during
-    the initdb phase, by adding the "--data-checksums" flag to
-    the postgresql_initdb_flags rcvar.  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
-EOM
-}
-]
diff --git a/databases/postgresql11-server/files/pkgIndex.tcl.in b/databases/postgresql11-server/files/pkgIndex.tcl.in
deleted file mode 100644
index bd8329b15c69..000000000000
--- a/databases/postgresql11-server/files/pkgIndex.tcl.in
+++ /dev/null
@@ -1,4 +0,0 @@
-# Package-index file for Pgtcl-package. Enables you to load PostgreSQL
-# interface functions right into you TCL-interpreter as simply as
-#	package require Pgtcl
-package ifneeded Pgtcl 1.3 "load %%PREFIX%%/lib/libpgtcl.so"
diff --git a/databases/postgresql11-server/files/postgresql.in b/databases/postgresql11-server/files/postgresql.in
deleted file mode 100644
index 390c607f323e..000000000000
--- a/databases/postgresql11-server/files/postgresql.in
+++ /dev/null
@@ -1,115 +0,0 @@
-#!/bin/sh
-
-# PROVIDE: postgresql
-# REQUIRE: DAEMON mountlate
-# KEYWORD: shutdown
-#
-# Add the following line to /etc/rc.conf to enable PostgreSQL:
-#
-#  postgresql_enable="YES"
-#  # optional
-#  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"
-#  postgresql_profiles=""
-#
-# See %%PREFIX%%/share/doc/postgresql/README-server for more info
-#
-# This scripts takes one of the following commands:
-#
-#   start stop restart reload status initdb
-#
-# For postmaster startup options, edit ${postgresql_data}/postgresql.conf
-
-command=%%PREFIX%%/bin/pg_ctl
-
-. /etc/rc.subr
-
-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"}
-
-name=postgresql
-rcvar=postgresql_enable
-extra_commands="reload initdb"
-
-start_cmd="postgresql_command start"
-stop_cmd="postgresql_command stop"
-restart_cmd="postgresql_command restart"
-reload_cmd="postgresql_command reload"
-status_cmd="postgresql_command status"
-promote_cmd="postgresql_command promote"
-
-initdb_cmd="postgresql_initdb"
-
-su_cmd="/usr/bin/su"
-
-if [ -n "$2" ]; then
-	profile="$2"
-	if [ "x${postgresql_profiles}" != "x" ]; then
-		eval postgresql_data="\${postgresql_${profile}_data:-}"
-		if [ "x${postgresql_data}" = "x" ]; then
-			echo "You must define a data directory (postgresql_${profile}_data)"
-			exit 1
-		fi
-		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_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}"
-	fi
-else
-	if [ "x${postgresql_profiles}" != "x" -a "x$1" != "x" ]; then
-		for profile in ${postgresql_profiles}; do
-			eval _enable="\${postgresql_${profile}_enable}"
-			case "x${_enable:-${postgresql_enable}}" in
-			x|x[Nn][Oo]|x[Nn][Oo][Nn][Ee])
-				continue
-				;;
-			x[Yy][Ee][Ss])
-				;;
-			*)
-				if test -z "$_enable"; then
-					_var=postgresql_enable
-				else
-					_var=postgresql_"${profile}"_enable
-				fi
-				echo "Bad value" \
-					"'${_enable:-${postgresql_enable}}'" \
-					"for ${_var}. " \
-					"Profile ${profile} skipped."
-				continue
-				;;
-			esac
-			echo "===> 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 <<EOF
-
-  =========== BACKUP YOUR DATA! =============
-  As always, backup your data before
-  upgrading. If the upgrade leads to a higher
-  minor revision (e.g. 8.3.x -> 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 ***