git: bbd8259de39f - main - databases/postgresql11: Sunset
- Go to: [ bottom of page ] [ top of archives ] [ this month ]
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 ***