Remove expired/expiring ports:

2016-10-01 databases/postgresql91-client: End-of-life is near
2016-10-08 databases/postgresql91-pgtcl: Depends on expired PostgreSQL 9.1
2016-10-01 databases/postgresql91-server: End-of-life is near
2016-10-08 databases/postgresql-pllua: Depends on expired PostgreSQL 9.1

16 files changed, 0 insertions, 860 deletions

diff --git a/databases/postgresql91-server/files/502.pgsql.in b/databases/postgresql91-server/files/502.pgsql.in
deleted file mode 100644
index 06026b1d831f..000000000000
--- a/databases/postgresql91-server/files/502.pgsql.in
+++ /dev/null
@@ -1,116 +0,0 @@
-#!/bin/sh
-#
-# $FreeBSD$
-#
-# 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 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/postgresql91-server/files/dot.cshrc.in b/databases/postgresql91-server/files/dot.cshrc.in
deleted file mode 100644
index 4069398b376e..000000000000
--- a/databases/postgresql91-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/postgresql91-server/files/dot.profile.in b/databases/postgresql91-server/files/dot.profile.in
deleted file mode 100644
index 954e22eae8f8..000000000000
--- a/databases/postgresql91-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/postgresql91-server/files/patch-contrib-uuid b/databases/postgresql91-server/files/patch-contrib-uuid
deleted file mode 100644
index b8ff815e724f..000000000000
--- a/databases/postgresql91-server/files/patch-contrib-uuid
+++ /dev/null
@@ -1,392 +0,0 @@
---- contrib/Makefile.orig	2014-07-21 20:14:13.000000000 +0100
-+++ contrib/Makefile	2014-07-30 18:07:16.305934690 +0100
-@@ -48,6 +48,7 @@
- 		test_parser	\
- 		tsearch2	\
- 		unaccent	\
-+		uuid-ossp	\
- 		vacuumlo
- 
- ifeq ($(with_openssl),yes)
---- contrib/uuid-ossp/Makefile.orig	2014-07-21 20:14:13.000000000 +0100
-+++ contrib/uuid-ossp/Makefile	2014-07-30 18:07:06.646935377 +0100
-@@ -1,12 +1,14 @@
- # contrib/uuid-ossp/Makefile
-+# modified using http://pgfoundry.org/projects/uuid-freebsd/
-+# to actually not use ossp, since uuid methods are all
-+# built in into libc in FreeBSD /girgen@
- 
- MODULE_big = uuid-ossp
- OBJS = uuid-ossp.o
- 
- EXTENSION = uuid-ossp
- DATA = uuid-ossp--1.0.sql uuid-ossp--unpackaged--1.0.sql
--
--SHLIB_LINK += $(OSSP_UUID_LIBS)
-+SHLIB_LINK = -lmd
- 
- ifdef USE_PGXS
- PG_CONFIG = pg_config
---- contrib/uuid-ossp/uuid-ossp.c.orig	2014-07-21 20:14:13.000000000 +0100
-+++ contrib/uuid-ossp/uuid-ossp.c	2014-07-30 18:07:00.309934687 +0100
-@@ -6,6 +6,10 @@
-  *
-  * contrib/uuid-ossp/uuid-ossp.c
-  *
-+ * Modified to use FreeBSD's built in uuid instead of ossp:
-+ * Copyright (c) 2009 Andrew Gierth
-+ *
-+ * URL: http://pgfoundry.org/projects/uuid-freebsd
-  *-------------------------------------------------------------------------
-  */
- 
-@@ -14,27 +18,14 @@
- #include "utils/builtins.h"
- #include "utils/uuid.h"
- 
--/*
-- * There's some confusion over the location of the uuid.h header file.
-- * On Debian, it's installed as ossp/uuid.h, while on Fedora, or if you
-- * install ossp-uuid from a tarball, it's installed as uuid.h. Don't know
-- * what other systems do.
-- */
--#ifdef HAVE_OSSP_UUID_H
--#include <ossp/uuid.h>
--#else
--#ifdef HAVE_UUID_H
--#include <uuid.h>
--#else
--#error OSSP uuid.h not found
--#endif
--#endif
--
--/* better both be 16 */
--#if (UUID_LEN != UUID_LEN_BIN)
--#error UUID length mismatch
--#endif
-+/* OS has a uuid_hash that conflicts with ours; kill it*/
-+/* explicit path since we do _not_ want to get any other version */
-+#define uuid_hash freebsd_uuid_hash
-+#include "/usr/include/uuid.h"
-+#undef uuid_hash
- 
-+#include <md5.h>
-+#include <sha.h>
- 
- PG_MODULE_MAGIC;
- 
-@@ -64,177 +55,175 @@
- PG_FUNCTION_INFO_V1(uuid_generate_v4);
- PG_FUNCTION_INFO_V1(uuid_generate_v5);
- 
--static void
--pguuid_complain(uuid_rc_t rc)
--{
--	char	   *err = uuid_error(rc);
--
--	if (err != NULL)
--		ereport(ERROR,
--				(errcode(ERRCODE_EXTERNAL_ROUTINE_EXCEPTION),
--				 errmsg("OSSP uuid library failure: %s", err)));
--	else
--		ereport(ERROR,
--				(errcode(ERRCODE_EXTERNAL_ROUTINE_EXCEPTION),
--				 errmsg("OSSP uuid library failure: error code %d", rc)));
--}
-+/* we assume that the string representation is portable and that the
-+ * native binary representation might not be. But for *ns, we assume
-+ * that pg's internal storage of uuids is the simple byte-oriented
-+ * binary format. */
- 
--/*
-- * We create a uuid_t object just once per session and re-use it for all
-- * operations in this module.  OSSP UUID caches the system MAC address and
-- * other state in this object.  Reusing the object has a number of benefits:
-- * saving the cycles needed to fetch the system MAC address over and over,
-- * reducing the amount of entropy we draw from /dev/urandom, and providing a
-- * positive guarantee that successive generated V1-style UUIDs don't collide.
-- * (On a machine fast enough to generate multiple UUIDs per microsecond,
-- * or whatever the system's wall-clock resolution is, we'd otherwise risk
-- * collisions whenever random initialization of the uuid_t's clock sequence
-- * value chanced to produce duplicates.)
-- *
-- * However: when we're doing V3 or V5 UUID creation, uuid_make needs two
-- * uuid_t objects, one holding the namespace UUID and one for the result.
-- * It's unspecified whether it's safe to use the same uuid_t for both cases,
-- * so let's cache a second uuid_t for use as the namespace holder object.
-- */
--static uuid_t *
--get_cached_uuid_t(int which)
-+static Datum
-+internal_uuid_create(int v, unsigned char *ns, char *ptr, int len)
- {
--	static uuid_t *cached_uuid[2] = {NULL, NULL};
-+	char strbuf[40];
- 
--	if (cached_uuid[which] == NULL)
-+	switch (v)
- 	{
--		uuid_rc_t	rc;
-+	case 0:	 /* constant-value uuids: nil, or namespace uuids */
-+		strlcpy(strbuf, ptr, 37);
-+		break;
- 
--		rc = uuid_create(&cached_uuid[which]);
--		if (rc != UUID_RC_OK)
--		{
--			cached_uuid[which] = NULL;
--			pguuid_complain(rc);
--		}
-+	case 4: default:   /* random uuid */
-+	{
-+		sprintf(strbuf, "%08lx-%04x-%04x-%04x-%04x%08lx",
-+			(unsigned long) arc4random(),
-+			(unsigned) (arc4random() & 0xffff),
-+			(unsigned) ((arc4random() & 0xfff) | 0x4000),
-+			(unsigned) ((arc4random() & 0x3fff) | 0x8000),
-+			(unsigned) (arc4random() & 0xffff),
-+			(unsigned long) arc4random());
-+		break;
- 	}
--	return cached_uuid[which];
--}
-+		
-+	case 1:	 /* time/node-based uuids */
-+	{
-+		uuid_t uu;
-+		uint32_t status = uuid_s_ok;
-+		char *str = NULL;
- 
--static char *
--uuid_to_string(const uuid_t *uuid)
--{
--	char	   *buf = palloc(UUID_LEN_STR + 1);
--	void	   *ptr = buf;
--	size_t		len = UUID_LEN_STR + 1;
--	uuid_rc_t	rc;
-+		uuid_create(&uu, &status);
- 
--	rc = uuid_export(uuid, UUID_FMT_STR, &ptr, &len);
--	if (rc != UUID_RC_OK)
--		pguuid_complain(rc);
-+		if (status == uuid_s_ok)
-+		{
-+		uuid_to_string(&uu, &str, &status);
-+		if (status == uuid_s_ok)
-+		{
-+			strlcpy(strbuf, str, 37);
- 
--	return buf;
--}
-+			/* PTR, if set, replaces the trailing characters of the uuid;
-+			 * this is to support v1mc, where a random multicast MAC is
-+			 * used instead of the physical one
-+			 */
-+			
-+			if (ptr && len <= 36)
-+			strcpy(strbuf + (36 - len), ptr);
-+		}
-+		if (str)
-+			free(str);
-+		}
- 
-+		if (status != uuid_s_ok)
-+		{
-+		ereport(ERROR,
-+			(errcode(ERRCODE_EXTERNAL_ROUTINE_EXCEPTION),
-+			 errmsg("FreeBSD uuid library failure: %d", (int) status)));
-+		}
-+		
-+		break;
-+	}
- 
--static void
--string_to_uuid(const char *str, uuid_t *uuid)
--{
--	uuid_rc_t	rc;
-+	case 3:	 /* namespace-based MD5 uuids */
-+	{
-+		/* we could use pg's md5(), but we're already pulling in libmd */
-+		MD5_CTX ctx;
-+		unsigned char buf[16];
-+
-+		MD5Init(&ctx);
-+		MD5Update(&ctx, ns, 16);
-+		MD5Update(&ctx, (unsigned char *)ptr, len);
-+		MD5Final(buf, &ctx);
-+
-+		sprintf(strbuf,
-+			"%02x%02x%02x%02x-"
-+			"%02x%02x-%02x%02x-%02x%02x-"
-+			"%02x%02x%02x%02x%02x%02x",
-+			buf[0], buf[1], buf[2], buf[3],
-+			buf[4], buf[5], ((buf[6] & 0xf) | 0x30), buf[7],
-+			((buf[8] & 0x3F) | 0x80), buf[9], buf[10], buf[11],
-+			buf[12], buf[13], buf[14], buf[15]);
- 
--	rc = uuid_import(uuid, UUID_FMT_STR, str, UUID_LEN_STR + 1);
--	if (rc != UUID_RC_OK)
--		pguuid_complain(rc);
--}
-+		break;
-+	}
-+
-+	case 5:	 /* namespace-based SHA1 uuids */
-+	{
-+		SHA_CTX ctx;
-+		unsigned char buf[20];
- 
-+		SHA1_Init(&ctx);
-+		SHA1_Update(&ctx, ns, 16);
-+		SHA1_Update(&ctx, (unsigned char *)ptr, len);
-+		SHA1_Final(buf, &ctx);
-+
-+		sprintf(strbuf,
-+			"%02x%02x%02x%02x-"
-+			"%02x%02x-%02x%02x-%02x%02x-"
-+			"%02x%02x%02x%02x%02x%02x",
-+			buf[0], buf[1], buf[2], buf[3],
-+			buf[4], buf[5], ((buf[6] & 0xf) | 0x30), buf[7],
-+			((buf[8] & 0x3F) | 0x80), buf[9], buf[10], buf[11],
-+			buf[12], buf[13], buf[14], buf[15]);
- 
--static Datum
--special_uuid_value(const char *name)
--{
--	uuid_t	   *uuid = get_cached_uuid_t(0);
--	char	   *str;
--	uuid_rc_t	rc;
--
--	rc = uuid_load(uuid, name);
--	if (rc != UUID_RC_OK)
--		pguuid_complain(rc);
--	str = uuid_to_string(uuid);
-+			break;
-+		}
-+	}
- 
--	return DirectFunctionCall1(uuid_in, CStringGetDatum(str));
-+	return DirectFunctionCall1(uuid_in, CStringGetDatum(strbuf));
- }
- 
- 
- Datum
- uuid_nil(PG_FUNCTION_ARGS)
- {
--	return special_uuid_value("nil");
-+	return internal_uuid_create(0, NULL, "00000000-0000-0000-0000-000000000000", 36);
- }
- 
- 
- Datum
- uuid_ns_dns(PG_FUNCTION_ARGS)
- {
--	return special_uuid_value("ns:DNS");
-+	return internal_uuid_create(0, NULL, "6ba7b810-9dad-11d1-80b4-00c04fd430c8", 36);
- }
- 
- 
- Datum
- uuid_ns_url(PG_FUNCTION_ARGS)
- {
--	return special_uuid_value("ns:URL");
-+	return internal_uuid_create(0, NULL, "6ba7b811-9dad-11d1-80b4-00c04fd430c8", 36);
- }
- 
- 
- Datum
- uuid_ns_oid(PG_FUNCTION_ARGS)
- {
--	return special_uuid_value("ns:OID");
-+	return internal_uuid_create(0, NULL, "6ba7b812-9dad-11d1-80b4-00c04fd430c8", 36);
- }
- 
- 
- Datum
- uuid_ns_x500(PG_FUNCTION_ARGS)
- {
--	return special_uuid_value("ns:X500");
--}
--
--
--static Datum
--uuid_generate_internal(int mode, const uuid_t *ns, const char *name)
--{
--	uuid_t	   *uuid = get_cached_uuid_t(0);
--	char	   *str;
--	uuid_rc_t	rc;
--
--	rc = uuid_make(uuid, mode, ns, name);
--	if (rc != UUID_RC_OK)
--		pguuid_complain(rc);
--	str = uuid_to_string(uuid);
--
--	return DirectFunctionCall1(uuid_in, CStringGetDatum(str));
-+	return internal_uuid_create(0, NULL, "6ba7b814-9dad-11d1-80b4-00c04fd430c8", 36);
- }
- 
- 
- Datum
- uuid_generate_v1(PG_FUNCTION_ARGS)
- {
--	return uuid_generate_internal(UUID_MAKE_V1, NULL, NULL);
-+	return internal_uuid_create(1, NULL, NULL, 0);
- }
- 
- 
- Datum
- uuid_generate_v1mc(PG_FUNCTION_ARGS)
- {
--	return uuid_generate_internal(UUID_MAKE_V1 | UUID_MAKE_MC, NULL, NULL);
--}
--
--
--static Datum
--uuid_generate_v35_internal(int mode, pg_uuid_t *ns, text *name)
--{
--	uuid_t	   *ns_uuid = get_cached_uuid_t(1);
--
--	string_to_uuid(DatumGetCString(DirectFunctionCall1(uuid_out,
--													   UUIDPGetDatum(ns))),
--				   ns_uuid);
-+	char buf[20];
- 
--	return uuid_generate_internal(mode,
--								  ns_uuid,
--								  text_to_cstring(name));
-+	sprintf(buf, "-%04x-%04x%08lx",
-+		(unsigned)((arc4random() & 0x3FFF) | 0x8000),
-+		/* set IEEE802 multicast and local-admin bits */
-+		(unsigned)((arc4random() & 0xffff) | 0x0300),
-+		(unsigned long) arc4random());
-+		
-+	return internal_uuid_create(1, NULL, buf, 18);
- }
- 
- 
-@@ -244,14 +233,15 @@
- 	pg_uuid_t  *ns = PG_GETARG_UUID_P(0);
- 	text	   *name = PG_GETARG_TEXT_P(1);
- 
--	return uuid_generate_v35_internal(UUID_MAKE_V3, ns, name);
-+	return internal_uuid_create(3, (unsigned char *)ns,
-+				VARDATA(name), VARSIZE(name) - VARHDRSZ);
- }
- 
- 
- Datum
- uuid_generate_v4(PG_FUNCTION_ARGS)
- {
--	return uuid_generate_internal(UUID_MAKE_V4, NULL, NULL);
-+	return internal_uuid_create(4, NULL, NULL, 0);
- }
- 
- 
-@@ -261,5 +251,6 @@
- 	pg_uuid_t  *ns = PG_GETARG_UUID_P(0);
- 	text	   *name = PG_GETARG_TEXT_P(1);
- 
--	return uuid_generate_v35_internal(UUID_MAKE_V5, ns, name);
-+	return internal_uuid_create(5, (unsigned char *)ns,
-+				VARDATA(name), VARSIZE(name) - VARHDRSZ);
- }
diff --git a/databases/postgresql91-server/files/patch-doc-Makefile b/databases/postgresql91-server/files/patch-doc-Makefile
deleted file mode 100644
index a366d4ca2620..000000000000
--- a/databases/postgresql91-server/files/patch-doc-Makefile
+++ /dev/null
@@ -1,28 +0,0 @@
---- doc/src/sgml/Makefile.orig	2010-06-12 23:40:31.000000000 +0200
-+++ doc/src/sgml/Makefile	2010-09-19 22:07:11.210759927 +0200
-@@ -15,14 +15,14 @@
- 
- # Make "html" the default target, since that is what most people tend
- # to want to use.
--html:
-+man:
- 
- subdir = doc/src/sgml
- top_builddir = ../../..
- include $(top_builddir)/src/Makefile.global
- 
- 
--all: html man
-+all: man
- 
- distprep: html distprep-man
- 
-@@ -285,7 +285,7 @@
- ## Install
- ##
- 
--install: install-html
-+##install: install-html
- 
- ifneq ($(PORTNAME), sco)
- install: install-man
diff --git a/databases/postgresql91-server/files/patch-doc-src-sgml-Makefile b/databases/postgresql91-server/files/patch-doc-src-sgml-Makefile
deleted file mode 100644
index ee9a537b1ecc..000000000000
--- a/databases/postgresql91-server/files/patch-doc-src-sgml-Makefile
+++ /dev/null
@@ -1,20 +0,0 @@
---- doc/src/sgml/Makefile.orig	2011-10-13 16:53:51.000000000 +0200
-+++ doc/src/sgml/Makefile	2011-10-13 17:05:08.000000000 +0200
-@@ -75,8 +75,6 @@
- ## Man pages
- ##
- 
--man distprep-man: man-stamp
--
- man-stamp: stylesheet-man.xsl postgres.xml
- 	$(XSLTPROC) $(XSLTPROCFLAGS) $(XSLTPROC_MAN_FLAGS) $^
- 	touch $@
-@@ -303,7 +301,7 @@
- endif
- 
- installdirs:
--	$(MKDIR_P) '$(DESTDIR)$(htmldir)'/html $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
-+	$(MKDIR_P) $(addprefix '$(DESTDIR)$(mandir)'/man, 1 3 $(sqlmansectnum))
- 
- uninstall:
- 	rm -f '$(DESTDIR)$(htmldir)/html/'* $(addprefix  '$(DESTDIR)$(mandir)'/man, 1/* 3/* $(sqlmansectnum)/*)
diff --git a/databases/postgresql91-server/files/patch-src-backend-Makefile b/databases/postgresql91-server/files/patch-src-backend-Makefile
deleted file mode 100644
index 6d6fb0ce660b..000000000000
--- a/databases/postgresql91-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/utils/fmgroids.h $(top_builddir)/src/include/utils/probes.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/postgresql91-server/files/patch-src_backend_utils_misc_postgresql.conf.sample b/databases/postgresql91-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
deleted file mode 100644
index 3c1609fdbbc7..000000000000
--- a/databases/postgresql91-server/files/patch-src_backend_utils_misc_postgresql.conf.sample
+++ /dev/null
@@ -1,28 +0,0 @@
---- src/backend/utils/misc/postgresql.conf.sample.orig	2010-10-01 16:25:44.000000000 +0200
-+++ src/backend/utils/misc/postgresql.conf.sample	2010-10-05 07:37:35.626282933 +0200
-@@ -256,6 +256,7 @@
- 
- # - Where to Log -
- 
-+log_destination = 'syslog'
- #log_destination = 'stderr'		# Valid values are combinations of
- 					# stderr, csvlog, syslog, and eventlog,
- 					# depending on platform.  csvlog
-@@ -290,6 +291,7 @@
- #syslog_facility = 'LOCAL0'
- #syslog_ident = 'postgres'
- 
-+silent_mode = on
- #silent_mode = off			# Run server silently.
- 					# DO NOT USE without syslog or
- 					# logging_collector
-@@ -394,6 +396,9 @@
- #track_counts = on
- #track_functions = none			# none, pl, all
- #track_activity_query_size = 1024 	# (change requires restart)
-+
-+# On FreeBSD, this is a performance hog, so keep it off if you need speed
-+update_process_title = off
- #update_process_title = on
- #stats_temp_directory = 'pg_stat_tmp'
- 
diff --git a/databases/postgresql91-server/files/pkg-message-client.in b/databases/postgresql91-server/files/pkg-message-client.in
deleted file mode 100644
index 07985360ee1b..000000000000
--- a/databases/postgresql91-server/files/pkg-message-client.in
+++ /dev/null
@@ -1,32 +0,0 @@
-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-PyGreSQL
-  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...
diff --git a/databases/postgresql91-server/files/pkg-message-contrib.in b/databases/postgresql91-server/files/pkg-message-contrib.in
deleted file mode 100644
index 2b29ffd33041..000000000000
--- a/databases/postgresql91-server/files/pkg-message-contrib.in
+++ /dev/null
@@ -1,3 +0,0 @@
-The PostgreSQL contrib utilities have been installed. Please see
-%%PREFIX%%/share/doc/postgresql/contrib/README
-for more information.
diff --git a/databases/postgresql91-server/files/pkg-message-plperl.in b/databases/postgresql91-server/files/pkg-message-plperl.in
deleted file mode 100644
index 5d0c83920563..000000000000
--- a/databases/postgresql91-server/files/pkg-message-plperl.in
+++ /dev/null
@@ -1,3 +0,0 @@
-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".
diff --git a/databases/postgresql91-server/files/pkg-message-plpython.in b/databases/postgresql91-server/files/pkg-message-plpython.in
deleted file mode 100644
index c413582b6295..000000000000
--- a/databases/postgresql91-server/files/pkg-message-plpython.in
+++ /dev/null
@@ -1,3 +0,0 @@
-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).
diff --git a/databases/postgresql91-server/files/pkg-message-pltcl.in b/databases/postgresql91-server/files/pkg-message-pltcl.in
deleted file mode 100644
index 0902b858de0b..000000000000
--- a/databases/postgresql91-server/files/pkg-message-pltcl.in
+++ /dev/null
@@ -1,3 +0,0 @@
-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".
diff --git a/databases/postgresql91-server/files/pkg-message-server.in b/databases/postgresql91-server/files/pkg-message-server.in
deleted file mode 100644
index 54f397448198..000000000000
--- a/databases/postgresql91-server/files/pkg-message-server.in
+++ /dev/null
@@ -1,70 +0,0 @@
-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 perfom vacuum on all
-databases nightly. Per default, it perfoms `vacuum analyze'. See the
-script for instructions. For autovacuum settings, please review
-~pgsql/data/postgresql.conf.
-
-To allow many simultaneous connections to your PostgreSQL server, you
-should raise the SystemV shared memory limits in your kernel. Here are
-example values for allowing up to 180 clients (configurations in
-postgresql.conf also needed, of course):
-  options         SYSVSHM
-  options         SYSVSEM
-  options         SYSVMSG
-  options         SHMMAXPGS=65536
-  options         SEMMNI=40
-  options         SEMMNS=240
-  options         SEMUME=40
-  options         SEMMNU=120
-
-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_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 ~pgsql/data/postgresql.conf
-
-NB. FreeBSD's PostgreSQL port logs to syslog by default
-    See ~pgsql/data/postgresql.conf for more info
-
-======================================================================
-
-To run PostgreSQL at startup, add
-'postgresql_enable="YES"' to /etc/rc.conf
-
diff --git a/databases/postgresql91-server/files/pkgIndex.tcl.in b/databases/postgresql91-server/files/pkgIndex.tcl.in
deleted file mode 100644
index bd8329b15c69..000000000000
--- a/databases/postgresql91-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/postgresql91-server/files/postgresql.in b/databases/postgresql91-server/files/postgresql.in
deleted file mode 100644
index 643171a44b91..000000000000
--- a/databases/postgresql91-server/files/postgresql.in
+++ /dev/null
@@ -1,114 +0,0 @@
-#!/bin/sh
-
-# $FreeBSD$
-#
-# PROVIDE: postgresql
-# REQUIRE: LOGIN
-# KEYWORD: shutdown
-#
-# Add the following line to /etc/rc.conf to enable PostgreSQL:
-#
-#  postgresql_enable="YES"
-#  # optional
-#  postgresql_data="%%PREFIX%%/%%PG_USER%%/data"
-#  postgresql_flags="-w -s -m fast"
-#  postgresql_initdb_flags="--encoding=utf-8 --lc-collate=C"
-#  postgresql_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"}
-postgresql_class=${postgresql_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"
-
-initdb_cmd="postgresql_initdb"
-
-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 -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}"
-}
-
-postgresql_initdb()
-{
-    su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data}"
-}
-
-run_rc_command "$1"