Add postgresql95 packages, converted from corresponding postgresql94

packages. postgresql95-upgrade is gone, the pg_upgrade tool is shipped
with postgresql95-client now.

Major enhancements in PostgreSQL 9.5 include:

  Allow INSERTs that would generate constraint conflicts to be turned into
    UPDATEs or ignored
  Add GROUP BY analysis features GROUPING SETS, CUBE and ROLLUP
  Add row-level security control
  Create mechanisms for tracking the progress of replication, including
    methods for identifying the origin of individual changes during logical
    replication
  Add Block Range Indexes (BRIN)
  Substantial performance improvements for sorting
  Substantial performance improvements for multi-CPU machines

4 files changed, 78 insertions, 0 deletions

diff --git a/databases/postgresql95-plpython/DESCR b/databases/postgresql95-plpython/DESCR
new file mode 100644
index 00000000000..142bb15309d
--- /dev/null
+++ b/databases/postgresql95-plpython/DESCR
@@ -0,0 +1,9 @@
+PL/Python allows you to write functions in the Python programming
+language that may be used in SQL queries as if they were built into
+Postgres.  The PL/Python intepreter is a full Python interpreter.
+
+PL/Python is currently only available as an "untrusted" language
+(meaning it does not offer any way of restricting what users can do
+in it).  It has therefore been named "plpythonu".  The trusted variant
+plpython may become available again in future, if a new secure execution
+mechanism is developed in Python.
diff --git a/databases/postgresql95-plpython/MESSAGE b/databases/postgresql95-plpython/MESSAGE
new file mode 100644
index 00000000000..d269e20a112
--- /dev/null
+++ b/databases/postgresql95-plpython/MESSAGE
@@ -0,0 +1,17 @@
+===========================================================================
+$NetBSD: MESSAGE,v 1.1 2016/02/25 21:37:36 tnn Exp $
+
+Please see the PL/Python section of the PostgreSQL Programmer's Guide
+(databases/postgresql-docs) for information on programming with
+${PKGNAME}.
+
+Note that PL/Python is unrestricted language, meaning it does not
+offer any way of restricting what users can do in it.  Any DB user with
+access to PL/Python can run arbitrary Python code under privileges
+of the PostgreSQL server process.
+
+To enable PL/Python for database <dbname>, run following:
+
+createlang plpythonu <dbname>
+
+===========================================================================
diff --git a/databases/postgresql95-plpython/Makefile b/databases/postgresql95-plpython/Makefile
new file mode 100644
index 00000000000..7fafb729dd6
--- /dev/null
+++ b/databases/postgresql95-plpython/Makefile
@@ -0,0 +1,18 @@
+# $NetBSD: Makefile,v 1.1 2016/02/25 21:37:36 tnn Exp $
+
+PKGNAME=	${DISTNAME:C/-/95-plpython-/}
+COMMENT=	PL/Python procedural language for the PostgreSQL backend
+
+DEPENDS+=	postgresql95-server>=${PKGVERSION_NOREV}:../../databases/postgresql95-server
+
+.include "../../databases/postgresql95/Makefile.common"
+
+CONFIGURE_ARGS+=	--with-python
+CONFIGURE_ENV+=		PYTHON="${PYTHONBIN}"
+BUILD_MAKE_FLAGS=	PGXS=1
+
+BUILD_DIRS=		src/pl/plpython contrib/hstore_plpython
+
+.include "../../databases/postgresql95-client/buildlink3.mk"
+.include "../../lang/python/extension.mk"
+.include "../../mk/bsd.pkg.mk"
diff --git a/databases/postgresql95-plpython/PLIST b/databases/postgresql95-plpython/PLIST
new file mode 100644
index 00000000000..f6be4ded2a4
--- /dev/null
+++ b/databases/postgresql95-plpython/PLIST
@@ -0,0 +1,34 @@
+@comment $NetBSD: PLIST,v 1.1 2016/02/25 21:37:36 tnn Exp $
+include/postgresql/server/plpy_util.h
+include/postgresql/server/plpython.h
+${PLIST.py2x}lib/postgresql/hstore_plpython2.so
+${PLIST.py3x}lib/postgresql/hstore_plpython3.so
+${PLIST.py2x}lib/postgresql/plpython2.so
+${PLIST.py3x}lib/postgresql/plpython3.so
+share/locale/cs/LC_MESSAGES/plpython-9.5.mo
+share/locale/de/LC_MESSAGES/plpython-9.5.mo
+share/locale/es/LC_MESSAGES/plpython-9.5.mo
+share/locale/fr/LC_MESSAGES/plpython-9.5.mo
+share/locale/it/LC_MESSAGES/plpython-9.5.mo
+share/locale/ja/LC_MESSAGES/plpython-9.5.mo
+share/locale/ko/LC_MESSAGES/plpython-9.5.mo
+share/locale/pl/LC_MESSAGES/plpython-9.5.mo
+share/locale/pt_BR/LC_MESSAGES/plpython-9.5.mo
+share/locale/ru/LC_MESSAGES/plpython-9.5.mo
+share/locale/zh_CN/LC_MESSAGES/plpython-9.5.mo
+@comment as of 9.5.1 installation of these is not dependent on python version
+share/postgresql/extension/hstore_plpython2u--1.0.sql
+share/postgresql/extension/hstore_plpython2u.control
+share/postgresql/extension/hstore_plpython3u--1.0.sql
+share/postgresql/extension/hstore_plpython3u.control
+share/postgresql/extension/hstore_plpythonu--1.0.sql
+share/postgresql/extension/hstore_plpythonu.control
+${PLIST.py2x}share/postgresql/extension/plpython2u--1.0.sql
+${PLIST.py2x}share/postgresql/extension/plpython2u--unpackaged--1.0.sql
+${PLIST.py2x}share/postgresql/extension/plpython2u.control
+${PLIST.py3x}share/postgresql/extension/plpython3u--1.0.sql
+${PLIST.py3x}share/postgresql/extension/plpython3u--unpackaged--1.0.sql
+${PLIST.py3x}share/postgresql/extension/plpython3u.control
+${PLIST.py2x}share/postgresql/extension/plpythonu--1.0.sql
+${PLIST.py2x}share/postgresql/extension/plpythonu--unpackaged--1.0.sql
+${PLIST.py2x}share/postgresql/extension/plpythonu.control