On Wed, Nov 01, 2017 at 11:26:45AM -0700, Jeremy Evans wrote:
> This updates PostgreSQL from 9.6.5 to 10.0. Starting in 10.0,
> the versioning policy will change, so instead of 10.0.1, the
> next bugfix release will be 10.1, and the next feature release
> will be 11.0.
>
> There are many compelling reasons to upgrade, see:
>
> https://www.postgresql.org/about/news/1786/
> https://www.postgresql.org/docs/10/static/release-10.html
>
> The update is fairly straightforward, though I moved some things
> around in the PLISTs:
>
> * All python-dependent code moves to the -plpython subpackage,
> as it doesn't make sense to have plpython itself in -plpython,
> but hstore-plpython and ltree-plpython in -contrib.
>
> * Some server-specific programs such as pg_basebackup and
> pg_receivexlog (renamed to pg_receivewal) move from -client
> to -server, since they are only useful if you are running
> a PostgreSQL server.
>
> postgresql-previous gets updated from 9.5.5 to 9.6.5, and
> postgresql-pg_upgrade now depends on a postgresql-previous
> version that is at least greater than the previous major
> version, which should fix issues if someone runs
> "pkg_add postgresql-server".
>
> I've tried a pg_upgrade from 9.6 to 10 and didn't run into
> any problems, but it was on a very simple test database.
>
> Included at the bottom are necessary bumps for postgresql-pllua
> and postgresql-plv8, since those always depend on specific
> PostgreSQL versions.
>
> I've tried building some of the dependencies. citus needs an
> update to work with PostgreSQL 10, the diff to update to the
> latest citus version is included below. No other issues
> noticed yet, but I haven't finished building the dependencies
> for PostGIS.
>
> This should probably go into a bulk so we can see what the
> fallout is.
>
Hi Jeremy,
Thanks for your diff. Let me compare it with my own diff (i'm running pg 10
since beta 1).
Regards,
> Thanks,
> Jeremy
>
> Index: postgresql/Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/Makefile,v
> retrieving revision 1.229
> diff -u -p -u -p -r1.229 Makefile
> --- postgresql/Makefile 13 Sep 2017 14:24:08 -0000 1.229
> +++ postgresql/Makefile 1 Nov 2017 17:14:24 -0000
> @@ -7,8 +7,8 @@ COMMENT-contrib=PostgreSQL RDBMS contrib
> COMMENT-plpython=Python procedural language for PostgreSQL
> COMMENT-pg_upgrade=Support for upgrading PostgreSQL data from previous
> version
>
> -VERSION= 9.6.5
> -PREV_MAJOR= 9.5
> +VERSION= 10.0
> +PREV_MAJOR= 9.6
> DISTNAME= postgresql-${VERSION}
> PKGNAME-main= postgresql-client-${VERSION}
> PKGNAME-server= postgresql-server-${VERSION}
> @@ -18,10 +18,10 @@ PKGNAME-plpython=postgresql-plpython-${V
> PKGNAME-pg_upgrade=postgresql-pg_upgrade-${VERSION}
>
> CATEGORIES= databases
> -SHARED_LIBS= ecpg 7.8 \
> - ecpg_compat 4.8 \
> - pgtypes 4.7 \
> - pq 6.9
> +SHARED_LIBS= ecpg 7.9 \
> + ecpg_compat 4.9 \
> + pgtypes 4.8 \
> + pq 6.10
>
> HOMEPAGE= http://www.postgresql.org/
>
> @@ -96,10 +96,10 @@ WANTLIB-server= ${WANTLIB-main} perl pq>
> RUN_DEPENDS-contrib= databases/postgresql,-server=${VERSION}
> LIB_DEPENDS-contrib= databases/postgresql=${VERSION} \
> ${LIB_DEPENDS-main}
> -WANTLIB-contrib= ${WANTLIB-main} pq>=4
> +WANTLIB-contrib= ${WANTLIB-main} pq>=4 perl
>
> RUN_DEPENDS-pg_upgrade= databases/postgresql,-server=${VERSION} \
> - databases/postgresql-previous
> + databases/postgresql-previous>=${PREV_MAJOR}
> LIB_DEPENDS-pg_upgrade= databases/postgresql=${VERSION} \
> ${LIB_DEPENDS-main}
> WANTLIB-pg_upgrade= ${WANTLIB-main} pq>=4
> Index: postgresql/distinfo
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/distinfo,v
> retrieving revision 1.68
> diff -u -p -u -p -r1.68 distinfo
> --- postgresql/distinfo 13 Sep 2017 14:24:08 -0000 1.68
> +++ postgresql/distinfo 1 Nov 2017 14:12:43 -0000
> @@ -1,2 +1,2 @@
> -SHA256 (postgresql-9.6.5.tar.gz) =
> eelgXTIbVFsu2d8Yrf0uUslQ3JNGtl6VJ/EXExYn3Ao=
> -SIZE (postgresql-9.6.5.tar.gz) = 25652523
> +SHA256 (postgresql-10.0.tar.gz) =
> hsg6Zkt3ARSGG8lqnso8Pv4owDhManHGEEJs1CsBZPs=
> +SIZE (postgresql-10.0.tar.gz) = 25830653
> Index: postgresql/patches/patch-src_backend_libpq_ip_c
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql/patches/patch-src_backend_libpq_ip_c,v
> retrieving revision 1.2
> diff -u -p -u -p -r1.2 patch-src_backend_libpq_ip_c
> --- postgresql/patches/patch-src_backend_libpq_ip_c 13 Feb 2016 21:54:28
> -0000 1.2
> +++ postgresql/patches/patch-src_backend_libpq_ip_c 1 Nov 2017 14:22:27
> -0000
> @@ -3,9 +3,10 @@ $OpenBSD: patch-src_backend_libpq_ip_c,v
> Use the address family from the address, not from the netmask,
> since the latter is unreliable. Fixes "samenet"/"samehost".
>
> ---- src/backend/libpq/ip.c.orig Mon Feb 8 21:15:19 2016
> -+++ src/backend/libpq/ip.c Fri Feb 12 17:18:09 2016
> -@@ -423,17 +423,16 @@ run_ifaddr_callback(PgIfAddrCallback callback, void *c
> +Index: src/backend/libpq/ifaddr.c
> +--- src/backend/libpq/ifaddr.c.orig
> ++++ src/backend/libpq/ifaddr.c
> +@@ -200,17 +200,16 @@ run_ifaddr_callback(PgIfAddrCallback callback, void *c
> /* Check that the mask is valid */
> if (mask)
> {
> Index: postgresql/patches/patch-src_backend_storage_lmgr_s_lock_c
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql/patches/patch-src_backend_storage_lmgr_s_lock_c,v
> retrieving revision 1.2
> diff -u -p -u -p -r1.2 patch-src_backend_storage_lmgr_s_lock_c
> --- postgresql/patches/patch-src_backend_storage_lmgr_s_lock_c 8 Jan
> 2015 15:01:11 -0000 1.2
> +++ postgresql/patches/patch-src_backend_storage_lmgr_s_lock_c 1 Nov
> 2017 14:21:21 -0000
> @@ -1,12 +1,13 @@
> $OpenBSD: patch-src_backend_storage_lmgr_s_lock_c,v 1.2 2015/01/08 15:01:11
> pea Exp $
> ---- src/backend/storage/lmgr/s_lock.c.orig Sun May 11 14:16:48 2014
> -+++ src/backend/storage/lmgr/s_lock.c Thu May 15 21:52:50 2014
> -@@ -219,7 +219,7 @@ static void
> +Index: src/backend/storage/lmgr/s_lock.c
> +--- src/backend/storage/lmgr/s_lock.c.orig
> ++++ src/backend/storage/lmgr/s_lock.c
> +@@ -251,7 +251,7 @@ static void
> tas_dummy()
> {
> - __asm__ __volatile__(
> + __asm__ __volatile__(
> -#if defined(__NetBSD__) && defined(__ELF__)
> +#if (defined(__NetBSD__) || defined(__OpenBSD__)) && defined(__ELF__)
> /* no underscore for label and % for registers */
> -
> "\
> + "\
> .global tas \n\
> Index: postgresql/patches/patch-src_bin_scripts_vacuumdb_c
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql/patches/patch-src_bin_scripts_vacuumdb_c,v
> retrieving revision 1.1
> diff -u -p -u -p -r1.1 patch-src_bin_scripts_vacuumdb_c
> --- postgresql/patches/patch-src_bin_scripts_vacuumdb_c 10 Sep 2016
> 13:03:41 -0000 1.1
> +++ postgresql/patches/patch-src_bin_scripts_vacuumdb_c 1 Nov 2017
> 14:21:21 -0000
> @@ -1,6 +1,7 @@
> $OpenBSD: patch-src_bin_scripts_vacuumdb_c,v 1.1 2016/09/10 13:03:41
> ajacoutot Exp $
> ---- src/bin/scripts/vacuumdb.c.orig Sat Sep 10 10:37:08 2016
> -+++ src/bin/scripts/vacuumdb.c Sat Sep 10 10:38:12 2016
> +Index: src/bin/scripts/vacuumdb.c
> +--- src/bin/scripts/vacuumdb.c.orig
> ++++ src/bin/scripts/vacuumdb.c
> @@ -10,6 +10,8 @@
> *-------------------------------------------------------------------------
> */
> @@ -9,4 +10,4 @@ $OpenBSD: patch-src_bin_scripts_vacuumdb
> +
> #include "postgres_fe.h"
>
> - #include "common.h"
> + #ifdef HAVE_SYS_SELECT_H
> Index: postgresql/patches/patch-src_include_storage_s_lock_h
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql/patches/patch-src_include_storage_s_lock_h,v
> retrieving revision 1.3
> diff -u -p -u -p -r1.3 patch-src_include_storage_s_lock_h
> --- postgresql/patches/patch-src_include_storage_s_lock_h 13 Feb 2016
> 21:54:28 -0000 1.3
> +++ postgresql/patches/patch-src_include_storage_s_lock_h 1 Nov 2017
> 14:21:21 -0000
> @@ -1,9 +1,10 @@
> $OpenBSD: patch-src_include_storage_s_lock_h,v 1.3 2016/02/13 21:54:28 sthen
> Exp $
> ---- src/include/storage/s_lock.h.orig Mon Feb 8 21:15:19 2016
> -+++ src/include/storage/s_lock.h Fri Feb 12 17:18:09 2016
> -@@ -749,6 +749,29 @@ typedef unsigned char slock_t;
> +Index: src/include/storage/s_lock.h
> +--- src/include/storage/s_lock.h.orig
> ++++ src/include/storage/s_lock.h
> +@@ -693,6 +693,29 @@ typedef unsigned char slock_t;
> + do { __asm__ __volatile__("" : : : "memory"); *(lock) = 0; } while (0)
> #endif
> -
>
> +#if defined(__m88k__) /* Motorola 88k */
> +#define HAS_TEST_AND_SET
> Index: postgresql/patches/patch-src_interfaces_ecpg_compatlib_Makefile
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_compatlib_Makefile,v
> retrieving revision 1.12
> diff -u -p -u -p -r1.12 patch-src_interfaces_ecpg_compatlib_Makefile
> --- postgresql/patches/patch-src_interfaces_ecpg_compatlib_Makefile 18 Dec
> 2016 18:18:27 -0000 1.12
> +++ postgresql/patches/patch-src_interfaces_ecpg_compatlib_Makefile 1 Nov
> 2017 14:21:21 -0000
> @@ -1,12 +1,13 @@
> $OpenBSD: patch-src_interfaces_ecpg_compatlib_Makefile,v 1.12 2016/12/18
> 18:18:27 jeremy Exp $
> ---- src/interfaces/ecpg/compatlib/Makefile.orig Mon Jul 18 22:54:26 2016
> -+++ src/interfaces/ecpg/compatlib/Makefile Wed Aug 3 15:53:41 2016
> +Index: src/interfaces/ecpg/compatlib/Makefile
> +--- src/interfaces/ecpg/compatlib/Makefile.orig
> ++++ src/interfaces/ecpg/compatlib/Makefile
> @@ -15,8 +15,8 @@ include $(top_builddir)/src/Makefile.global
>
> PGFILEDESC = "ECPG compat - compatibility library for ECPG"
> NAME= ecpg_compat
> -SO_MAJOR_VERSION= 3
> --SO_MINOR_VERSION= 8
> +-SO_MINOR_VERSION= $(MAJORVERSION)
> +SO_MAJOR_VERSION= ${LIBecpg_compat_MAJOR}
> +SO_MINOR_VERSION= ${LIBecpg_compat_MINOR}
>
> Index: postgresql/patches/patch-src_interfaces_ecpg_ecpglib_Makefile
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_ecpglib_Makefile,v
> retrieving revision 1.11
> diff -u -p -u -p -r1.11 patch-src_interfaces_ecpg_ecpglib_Makefile
> --- postgresql/patches/patch-src_interfaces_ecpg_ecpglib_Makefile 18 Dec
> 2016 18:18:27 -0000 1.11
> +++ postgresql/patches/patch-src_interfaces_ecpg_ecpglib_Makefile 1 Nov
> 2017 14:21:21 -0000
> @@ -1,12 +1,13 @@
> $OpenBSD: patch-src_interfaces_ecpg_ecpglib_Makefile,v 1.11 2016/12/18
> 18:18:27 jeremy Exp $
> ---- src/interfaces/ecpg/ecpglib/Makefile.orig Mon Jul 18 22:54:26 2016
> -+++ src/interfaces/ecpg/ecpglib/Makefile Wed Aug 3 15:54:25 2016
> +Index: src/interfaces/ecpg/ecpglib/Makefile
> +--- src/interfaces/ecpg/ecpglib/Makefile.orig
> ++++ src/interfaces/ecpg/ecpglib/Makefile
> @@ -15,8 +15,8 @@ include $(top_builddir)/src/Makefile.global
>
> PGFILEDESC = "ECPG - embedded SQL in C"
> NAME= ecpg
> -SO_MAJOR_VERSION= 6
> --SO_MINOR_VERSION= 8
> +-SO_MINOR_VERSION= $(MAJORVERSION)
> +SO_MAJOR_VERSION= ${LIBecpg_MAJOR}
> +SO_MINOR_VERSION= ${LIBecpg_MINOR}
>
> Index: postgresql/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile,v
> retrieving revision 1.12
> diff -u -p -u -p -r1.12 patch-src_interfaces_ecpg_pgtypeslib_Makefile
> --- postgresql/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile 18 Dec
> 2016 18:18:27 -0000 1.12
> +++ postgresql/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile 1 Nov
> 2017 14:21:21 -0000
> @@ -1,12 +1,13 @@
> $OpenBSD: patch-src_interfaces_ecpg_pgtypeslib_Makefile,v 1.12 2016/12/18
> 18:18:27 jeremy Exp $
> ---- src/interfaces/ecpg/pgtypeslib/Makefile.orig Mon Jul 18 22:54:26 2016
> -+++ src/interfaces/ecpg/pgtypeslib/Makefile Wed Aug 3 15:55:16 2016
> +Index: src/interfaces/ecpg/pgtypeslib/Makefile
> +--- src/interfaces/ecpg/pgtypeslib/Makefile.orig
> ++++ src/interfaces/ecpg/pgtypeslib/Makefile
> @@ -15,8 +15,8 @@ include $(top_builddir)/src/Makefile.global
>
> PGFILEDESC = "pgtypes - library for data type mapping"
> NAME= pgtypes
> -SO_MAJOR_VERSION= 3
> --SO_MINOR_VERSION= 7
> +-SO_MINOR_VERSION= $(MAJORVERSION)
> +SO_MAJOR_VERSION= ${LIBpgtypes_MAJOR}
> +SO_MINOR_VERSION= ${LIBpgtypes_MINOR}
>
> Index: postgresql/patches/patch-src_interfaces_libpq_Makefile
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql/patches/patch-src_interfaces_libpq_Makefile,v
> retrieving revision 1.13
> diff -u -p -u -p -r1.13 patch-src_interfaces_libpq_Makefile
> --- postgresql/patches/patch-src_interfaces_libpq_Makefile 18 Dec 2016
> 18:18:27 -0000 1.13
> +++ postgresql/patches/patch-src_interfaces_libpq_Makefile 1 Nov 2017
> 14:21:21 -0000
> @@ -1,12 +1,13 @@
> $OpenBSD: patch-src_interfaces_libpq_Makefile,v 1.13 2016/12/18 18:18:27
> jeremy Exp $
> ---- src/interfaces/libpq/Makefile.orig Mon Jul 18 22:54:26 2016
> -+++ src/interfaces/libpq/Makefile Wed Aug 3 15:58:08 2016
> +Index: src/interfaces/libpq/Makefile
> +--- src/interfaces/libpq/Makefile.orig
> ++++ src/interfaces/libpq/Makefile
> @@ -16,8 +16,8 @@ include $(top_builddir)/src/Makefile.global
>
> # shared library parameters
> NAME= pq
> -SO_MAJOR_VERSION= 5
> --SO_MINOR_VERSION= 9
> +-SO_MINOR_VERSION= $(MAJORVERSION)
> +SO_MAJOR_VERSION= ${LIBpq_MAJOR}
> +SO_MINOR_VERSION= ${LIBpq_MINOR}
>
> Index: postgresql/pkg/DESCR-main
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/pkg/DESCR-main,v
> retrieving revision 1.2
> diff -u -p -u -p -r1.2 DESCR-main
> --- postgresql/pkg/DESCR-main 22 Mar 2007 19:29:17 -0000 1.2
> +++ postgresql/pkg/DESCR-main 1 Nov 2017 17:09:17 -0000
> @@ -19,3 +19,9 @@ The OpenBSD PostgreSQL port build produc
>
> * postgresql-contrib-${VERSION} - contributions
> Additional utilities and usefull libraries.
> +
> +* postgresql-plpython-${VERSION} - PL/Python procedural language.
> +
> +* postgresql-pg_upgrade-${VERSION} - Used to upgrade database
> + clusters directly from the previous version without a dump
> + and restore.
> Index: postgresql/pkg/PLIST-contrib
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v
> retrieving revision 1.16
> diff -u -p -u -p -r1.16 PLIST-contrib
> --- postgresql/pkg/PLIST-contrib 18 Dec 2016 18:18:27 -0000 1.16
> +++ postgresql/pkg/PLIST-contrib 1 Nov 2017 16:49:23 -0000
> @@ -11,6 +11,7 @@
> @bin bin/vacuumlo
> lib/postgresql/_int.so
> lib/postgresql/adminpack.so
> +lib/postgresql/amcheck.so
> lib/postgresql/auth_delay.so
> lib/postgresql/auto_explain.so
> lib/postgresql/autoinc.so
> @@ -26,12 +27,10 @@ lib/postgresql/file_fdw.so
> lib/postgresql/fuzzystrmatch.so
> lib/postgresql/hstore.so
> lib/postgresql/hstore_plperl.so
> -lib/postgresql/hstore_plpython2.so
> lib/postgresql/insert_username.so
> lib/postgresql/isn.so
> lib/postgresql/lo.so
> lib/postgresql/ltree.so
> -lib/postgresql/ltree_plpython2.so
> lib/postgresql/moddatetime.so
> lib/postgresql/pageinspect.so
> lib/postgresql/passwordcheck.so
> @@ -52,7 +51,6 @@ lib/postgresql/sslinfo.so
> lib/postgresql/tablefunc.so
> lib/postgresql/tcn.so
> lib/postgresql/timetravel.so
> -lib/postgresql/tsearch2.so
> lib/postgresql/tsm_system_rows.so
> lib/postgresql/tsm_system_time.so
> lib/postgresql/unaccent.so
> @@ -64,19 +62,27 @@ lib/postgresql/uuid-ossp.so
> @man man/man1/pg_test_timing.1
> @man man/man1/pgbench.1
> @man man/man1/vacuumlo.1
> +share/postgresql/extension/
> share/postgresql/extension/adminpack--1.0.sql
> share/postgresql/extension/adminpack.control
> +share/postgresql/extension/amcheck--1.0.sql
> +share/postgresql/extension/amcheck.control
> share/postgresql/extension/autoinc--1.0.sql
> share/postgresql/extension/autoinc--unpackaged--1.0.sql
> share/postgresql/extension/autoinc.control
> share/postgresql/extension/bloom--1.0.sql
> share/postgresql/extension/bloom.control
> +share/postgresql/extension/btree_gin--1.0--1.1.sql
> share/postgresql/extension/btree_gin--1.0.sql
> +share/postgresql/extension/btree_gin--1.1--1.2.sql
> share/postgresql/extension/btree_gin--unpackaged--1.0.sql
> share/postgresql/extension/btree_gin.control
> share/postgresql/extension/btree_gist--1.0--1.1.sql
> share/postgresql/extension/btree_gist--1.1--1.2.sql
> +share/postgresql/extension/btree_gist--1.2--1.3.sql
> share/postgresql/extension/btree_gist--1.2.sql
> +share/postgresql/extension/btree_gist--1.3--1.4.sql
> +share/postgresql/extension/btree_gist--1.4--1.5.sql
> share/postgresql/extension/btree_gist--unpackaged--1.0.sql
> share/postgresql/extension/btree_gist.control
> share/postgresql/extension/chkpass--1.0.sql
> @@ -85,7 +91,8 @@ share/postgresql/extension/chkpass.contr
> share/postgresql/extension/citext--1.0--1.1.sql
> share/postgresql/extension/citext--1.1--1.2.sql
> share/postgresql/extension/citext--1.2--1.3.sql
> -share/postgresql/extension/citext--1.3.sql
> +share/postgresql/extension/citext--1.3--1.4.sql
> +share/postgresql/extension/citext--1.4.sql
> share/postgresql/extension/citext--unpackaged--1.0.sql
> share/postgresql/extension/citext.control
> share/postgresql/extension/cube--1.0--1.1.sql
> @@ -125,12 +132,6 @@ share/postgresql/extension/hstore_plperl
> share/postgresql/extension/hstore_plperl.control
> share/postgresql/extension/hstore_plperlu--1.0.sql
> share/postgresql/extension/hstore_plperlu.control
> -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
> share/postgresql/extension/insert_username--1.0.sql
> share/postgresql/extension/insert_username--unpackaged--1.0.sql
> share/postgresql/extension/insert_username.control
> @@ -155,12 +156,6 @@ share/postgresql/extension/ltree--1.0--1
> share/postgresql/extension/ltree--1.1.sql
> share/postgresql/extension/ltree--unpackaged--1.0.sql
> share/postgresql/extension/ltree.control
> -share/postgresql/extension/ltree_plpython2u--1.0.sql
> -share/postgresql/extension/ltree_plpython2u.control
> -share/postgresql/extension/ltree_plpython3u--1.0.sql
> -share/postgresql/extension/ltree_plpython3u.control
> -share/postgresql/extension/ltree_plpythonu--1.0.sql
> -share/postgresql/extension/ltree_plpythonu.control
> share/postgresql/extension/moddatetime--1.0.sql
> share/postgresql/extension/moddatetime--unpackaged--1.0.sql
> share/postgresql/extension/moddatetime.control
> @@ -169,15 +164,18 @@ share/postgresql/extension/pageinspect--
> share/postgresql/extension/pageinspect--1.2--1.3.sql
> share/postgresql/extension/pageinspect--1.3--1.4.sql
> share/postgresql/extension/pageinspect--1.4--1.5.sql
> +share/postgresql/extension/pageinspect--1.5--1.6.sql
> share/postgresql/extension/pageinspect--1.5.sql
> share/postgresql/extension/pageinspect--unpackaged--1.0.sql
> share/postgresql/extension/pageinspect.control
> share/postgresql/extension/pg_buffercache--1.0--1.1.sql
> share/postgresql/extension/pg_buffercache--1.1--1.2.sql
> +share/postgresql/extension/pg_buffercache--1.2--1.3.sql
> share/postgresql/extension/pg_buffercache--1.2.sql
> share/postgresql/extension/pg_buffercache--unpackaged--1.0.sql
> share/postgresql/extension/pg_buffercache.control
> share/postgresql/extension/pg_freespacemap--1.0--1.1.sql
> +share/postgresql/extension/pg_freespacemap--1.1--1.2.sql
> share/postgresql/extension/pg_freespacemap--1.1.sql
> share/postgresql/extension/pg_freespacemap--unpackaged--1.0.sql
> share/postgresql/extension/pg_freespacemap.control
> @@ -188,6 +186,7 @@ share/postgresql/extension/pg_stat_state
> share/postgresql/extension/pg_stat_statements--1.1--1.2.sql
> share/postgresql/extension/pg_stat_statements--1.2--1.3.sql
> share/postgresql/extension/pg_stat_statements--1.3--1.4.sql
> +share/postgresql/extension/pg_stat_statements--1.4--1.5.sql
> share/postgresql/extension/pg_stat_statements--1.4.sql
> share/postgresql/extension/pg_stat_statements--unpackaged--1.0.sql
> share/postgresql/extension/pg_stat_statements.control
> @@ -198,6 +197,7 @@ share/postgresql/extension/pg_trgm--1.3.
> share/postgresql/extension/pg_trgm--unpackaged--1.0.sql
> share/postgresql/extension/pg_trgm.control
> share/postgresql/extension/pg_visibility--1.0--1.1.sql
> +share/postgresql/extension/pg_visibility--1.1--1.2.sql
> share/postgresql/extension/pg_visibility--1.1.sql
> share/postgresql/extension/pg_visibility.control
> share/postgresql/extension/pgcrypto--1.0--1.1.sql
> @@ -215,6 +215,7 @@ share/postgresql/extension/pgstattuple--
> share/postgresql/extension/pgstattuple--1.1--1.2.sql
> share/postgresql/extension/pgstattuple--1.2--1.3.sql
> share/postgresql/extension/pgstattuple--1.3--1.4.sql
> +share/postgresql/extension/pgstattuple--1.4--1.5.sql
> share/postgresql/extension/pgstattuple--1.4.sql
> share/postgresql/extension/pgstattuple--unpackaged--1.0.sql
> share/postgresql/extension/pgstattuple.control
> @@ -240,9 +241,6 @@ share/postgresql/extension/tcn.control
> share/postgresql/extension/timetravel--1.0.sql
> share/postgresql/extension/timetravel--unpackaged--1.0.sql
> share/postgresql/extension/timetravel.control
> -share/postgresql/extension/tsearch2--1.0.sql
> -share/postgresql/extension/tsearch2--unpackaged--1.0.sql
> -share/postgresql/extension/tsearch2.control
> share/postgresql/extension/tsm_system_rows--1.0.sql
> share/postgresql/extension/tsm_system_rows.control
> share/postgresql/extension/tsm_system_time--1.0.sql
> Index: postgresql/pkg/PLIST-docs
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
> retrieving revision 1.80
> diff -u -p -u -p -r1.80 PLIST-docs
> --- postgresql/pkg/PLIST-docs 13 Sep 2017 14:24:08 -0000 1.80
> +++ postgresql/pkg/PLIST-docs 1 Nov 2017 16:46:06 -0000
> @@ -12,16 +12,14 @@ share/doc/postgresql/extension/moddateti
> share/doc/postgresql/extension/refint.example
> share/doc/postgresql/extension/timetravel.example
> share/doc/postgresql/html/
> -share/doc/postgresql/html/LEGALNOTICE.html
> share/doc/postgresql/html/acronyms.html
> share/doc/postgresql/html/admin.html
> share/doc/postgresql/html/adminpack.html
> +share/doc/postgresql/html/amcheck.html
> share/doc/postgresql/html/app-clusterdb.html
> share/doc/postgresql/html/app-createdb.html
> -share/doc/postgresql/html/app-createlang.html
> share/doc/postgresql/html/app-createuser.html
> share/doc/postgresql/html/app-dropdb.html
> -share/doc/postgresql/html/app-droplang.html
> share/doc/postgresql/html/app-dropuser.html
> share/doc/postgresql/html/app-ecpg.html
> share/doc/postgresql/html/app-initdb.html
> @@ -32,9 +30,9 @@ share/doc/postgresql/html/app-pgbaseback
> share/doc/postgresql/html/app-pgconfig.html
> share/doc/postgresql/html/app-pgcontroldata.html
> share/doc/postgresql/html/app-pgdump.html
> -share/doc/postgresql/html/app-pgreceivexlog.html
> +share/doc/postgresql/html/app-pgreceivewal.html
> share/doc/postgresql/html/app-pgrecvlogical.html
> -share/doc/postgresql/html/app-pgresetxlog.html
> +share/doc/postgresql/html/app-pgresetwal.html
> share/doc/postgresql/html/app-pgrestore.html
> share/doc/postgresql/html/app-pgrewind.html
> share/doc/postgresql/html/app-postgres.html
> @@ -104,17 +102,24 @@ share/doc/postgresql/html/catalog-pg-nam
> share/doc/postgresql/html/catalog-pg-opclass.html
> share/doc/postgresql/html/catalog-pg-operator.html
> share/doc/postgresql/html/catalog-pg-opfamily.html
> +share/doc/postgresql/html/catalog-pg-partitioned-table.html
> share/doc/postgresql/html/catalog-pg-pltemplate.html
> share/doc/postgresql/html/catalog-pg-policy.html
> share/doc/postgresql/html/catalog-pg-proc.html
> +share/doc/postgresql/html/catalog-pg-publication-rel.html
> +share/doc/postgresql/html/catalog-pg-publication.html
> share/doc/postgresql/html/catalog-pg-range.html
> share/doc/postgresql/html/catalog-pg-replication-origin.html
> share/doc/postgresql/html/catalog-pg-rewrite.html
> share/doc/postgresql/html/catalog-pg-seclabel.html
> +share/doc/postgresql/html/catalog-pg-sequence.html
> share/doc/postgresql/html/catalog-pg-shdepend.html
> share/doc/postgresql/html/catalog-pg-shdescription.html
> share/doc/postgresql/html/catalog-pg-shseclabel.html
> +share/doc/postgresql/html/catalog-pg-statistic-ext.html
> share/doc/postgresql/html/catalog-pg-statistic.html
> +share/doc/postgresql/html/catalog-pg-subscription-rel.html
> +share/doc/postgresql/html/catalog-pg-subscription.html
> share/doc/postgresql/html/catalog-pg-tablespace.html
> share/doc/postgresql/html/catalog-pg-transform.html
> share/doc/postgresql/html/catalog-pg-trigger.html
> @@ -440,7 +445,6 @@ share/doc/postgresql/html/install-proced
> share/doc/postgresql/html/install-requirements.html
> share/doc/postgresql/html/install-short.html
> share/doc/postgresql/html/install-windows-full.html
> -share/doc/postgresql/html/install-windows-libpq.html
> share/doc/postgresql/html/install-windows.html
> share/doc/postgresql/html/installation-platform-notes.html
> share/doc/postgresql/html/installation.html
> @@ -451,6 +455,7 @@ share/doc/postgresql/html/intro-whatis.h
> share/doc/postgresql/html/isn.html
> share/doc/postgresql/html/kernel-resources.html
> share/doc/postgresql/html/largeobjects.html
> +share/doc/postgresql/html/legalnotice.html
> share/doc/postgresql/html/libpq-async.html
> share/doc/postgresql/html/libpq-build.html
> share/doc/postgresql/html/libpq-cancel.html
> @@ -483,6 +488,16 @@ share/doc/postgresql/html/locale.html
> share/doc/postgresql/html/locking-indexes.html
> share/doc/postgresql/html/log-shipping-alternative.html
> share/doc/postgresql/html/logfile-maintenance.html
> +share/doc/postgresql/html/logical-replication-architecture.html
> +share/doc/postgresql/html/logical-replication-config.html
> +share/doc/postgresql/html/logical-replication-conflicts.html
> +share/doc/postgresql/html/logical-replication-monitoring.html
> +share/doc/postgresql/html/logical-replication-publication.html
> +share/doc/postgresql/html/logical-replication-quick-setup.html
> +share/doc/postgresql/html/logical-replication-restrictions.html
> +share/doc/postgresql/html/logical-replication-security.html
> +share/doc/postgresql/html/logical-replication-subscription.html
> +share/doc/postgresql/html/logical-replication.html
> share/doc/postgresql/html/logicaldecoding-catalogs.html
> share/doc/postgresql/html/logicaldecoding-example.html
> share/doc/postgresql/html/logicaldecoding-explanation.html
> @@ -506,6 +521,7 @@ share/doc/postgresql/html/monitoring-ps.
> share/doc/postgresql/html/monitoring-stats.html
> share/doc/postgresql/html/monitoring.html
> share/doc/postgresql/html/multibyte.html
> +share/doc/postgresql/html/multivariate-statistics-examples.html
> share/doc/postgresql/html/mvcc-caveats.html
> share/doc/postgresql/html/mvcc-intro.html
> share/doc/postgresql/html/mvcc.html
> @@ -539,7 +555,7 @@ share/doc/postgresql/html/pgtesttiming.h
> share/doc/postgresql/html/pgtrgm.html
> share/doc/postgresql/html/pgupgrade.html
> share/doc/postgresql/html/pgvisibility.html
> -share/doc/postgresql/html/pgxlogdump.html
> +share/doc/postgresql/html/pgwaldump.html
> share/doc/postgresql/html/planner-optimizer.html
> share/doc/postgresql/html/planner-stats-details.html
> share/doc/postgresql/html/planner-stats-security.html
> @@ -578,6 +594,7 @@ share/doc/postgresql/html/plpython-subtr
> share/doc/postgresql/html/plpython-trigger.html
> share/doc/postgresql/html/plpython-util.html
> share/doc/postgresql/html/plpython.html
> +share/doc/postgresql/html/pltcl-config.html
> share/doc/postgresql/html/pltcl-data.html
> share/doc/postgresql/html/pltcl-dbaccess.html
> share/doc/postgresql/html/pltcl-error-handling.html
> @@ -586,8 +603,8 @@ share/doc/postgresql/html/pltcl-function
> share/doc/postgresql/html/pltcl-global.html
> share/doc/postgresql/html/pltcl-overview.html
> share/doc/postgresql/html/pltcl-procnames.html
> +share/doc/postgresql/html/pltcl-subtransactions.html
> share/doc/postgresql/html/pltcl-trigger.html
> -share/doc/postgresql/html/pltcl-unknown.html
> share/doc/postgresql/html/pltcl.html
> share/doc/postgresql/html/populate.html
> share/doc/postgresql/html/postgres-fdw.html
> @@ -598,6 +615,8 @@ share/doc/postgresql/html/progress-repor
> share/doc/postgresql/html/protocol-changes.html
> share/doc/postgresql/html/protocol-error-fields.html
> share/doc/postgresql/html/protocol-flow.html
> +share/doc/postgresql/html/protocol-logical-replication.html
> +share/doc/postgresql/html/protocol-logicalrep-message-formats.html
> share/doc/postgresql/html/protocol-message-formats.html
> share/doc/postgresql/html/protocol-message-types.html
> share/doc/postgresql/html/protocol-overview.html
> @@ -633,6 +652,7 @@ share/doc/postgresql/html/release-1-0.ht
> share/doc/postgresql/html/release-1-01.html
> share/doc/postgresql/html/release-1-02.html
> share/doc/postgresql/html/release-1-09.html
> +share/doc/postgresql/html/release-10.html
> share/doc/postgresql/html/release-6-0.html
> share/doc/postgresql/html/release-6-1-1.html
> share/doc/postgresql/html/release-6-1.html
> @@ -1001,6 +1021,7 @@ share/doc/postgresql/html/runtime-config
> share/doc/postgresql/html/runtime-config-wal.html
> share/doc/postgresql/html/runtime-config.html
> share/doc/postgresql/html/runtime.html
> +share/doc/postgresql/html/sasl-authentication.html
> share/doc/postgresql/html/seg.html
> share/doc/postgresql/html/sepgsql.html
> share/doc/postgresql/html/server-programming.html
> @@ -1055,15 +1076,16 @@ share/doc/postgresql/html/spi-spi-keeppl
> share/doc/postgresql/html/spi-spi-modifytuple.html
> share/doc/postgresql/html/spi-spi-palloc.html
> share/doc/postgresql/html/spi-spi-pfree.html
> -share/doc/postgresql/html/spi-spi-pop.html
> share/doc/postgresql/html/spi-spi-prepare-cursor.html
> share/doc/postgresql/html/spi-spi-prepare-params.html
> share/doc/postgresql/html/spi-spi-prepare.html
> -share/doc/postgresql/html/spi-spi-push.html
> +share/doc/postgresql/html/spi-spi-register-relation.html
> +share/doc/postgresql/html/spi-spi-register-trigger-data.html
> share/doc/postgresql/html/spi-spi-returntuple.html
> share/doc/postgresql/html/spi-spi-saveplan.html
> share/doc/postgresql/html/spi-spi-scroll-cursor-fetch.html
> share/doc/postgresql/html/spi-spi-scroll-cursor-move.html
> +share/doc/postgresql/html/spi-spi-unregister-relation.html
> share/doc/postgresql/html/spi-visibility.html
> share/doc/postgresql/html/spi.html
> share/doc/postgresql/html/sql-abort.html
> @@ -1087,11 +1109,14 @@ share/doc/postgresql/html/sql-alteropcla
> share/doc/postgresql/html/sql-alteroperator.html
> share/doc/postgresql/html/sql-alteropfamily.html
> share/doc/postgresql/html/sql-alterpolicy.html
> +share/doc/postgresql/html/sql-alterpublication.html
> share/doc/postgresql/html/sql-alterrole.html
> share/doc/postgresql/html/sql-alterrule.html
> share/doc/postgresql/html/sql-alterschema.html
> share/doc/postgresql/html/sql-altersequence.html
> share/doc/postgresql/html/sql-alterserver.html
> +share/doc/postgresql/html/sql-alterstatistics.html
> +share/doc/postgresql/html/sql-altersubscription.html
> share/doc/postgresql/html/sql-altersystem.html
> share/doc/postgresql/html/sql-altertable.html
> share/doc/postgresql/html/sql-altertablespace.html
> @@ -1134,11 +1159,14 @@ share/doc/postgresql/html/sql-createopcl
> share/doc/postgresql/html/sql-createoperator.html
> share/doc/postgresql/html/sql-createopfamily.html
> share/doc/postgresql/html/sql-createpolicy.html
> +share/doc/postgresql/html/sql-createpublication.html
> share/doc/postgresql/html/sql-createrole.html
> share/doc/postgresql/html/sql-createrule.html
> share/doc/postgresql/html/sql-createschema.html
> share/doc/postgresql/html/sql-createsequence.html
> share/doc/postgresql/html/sql-createserver.html
> +share/doc/postgresql/html/sql-createstatistics.html
> +share/doc/postgresql/html/sql-createsubscription.html
> share/doc/postgresql/html/sql-createtable.html
> share/doc/postgresql/html/sql-createtableas.html
> share/doc/postgresql/html/sql-createtablespace.html
> @@ -1178,11 +1206,14 @@ share/doc/postgresql/html/sql-dropopclas
> share/doc/postgresql/html/sql-dropoperator.html
> share/doc/postgresql/html/sql-dropopfamily.html
> share/doc/postgresql/html/sql-droppolicy.html
> +share/doc/postgresql/html/sql-droppublication.html
> share/doc/postgresql/html/sql-droprole.html
> share/doc/postgresql/html/sql-droprule.html
> share/doc/postgresql/html/sql-dropschema.html
> share/doc/postgresql/html/sql-dropsequence.html
> share/doc/postgresql/html/sql-dropserver.html
> +share/doc/postgresql/html/sql-dropstatistics.html
> +share/doc/postgresql/html/sql-dropsubscription.html
> share/doc/postgresql/html/sql-droptable.html
> share/doc/postgresql/html/sql-droptablespace.html
> share/doc/postgresql/html/sql-droptransform.html
> @@ -1266,7 +1297,6 @@ share/doc/postgresql/html/textsearch-fea
> share/doc/postgresql/html/textsearch-indexes.html
> share/doc/postgresql/html/textsearch-intro.html
> share/doc/postgresql/html/textsearch-limitations.html
> -share/doc/postgresql/html/textsearch-migration.html
> share/doc/postgresql/html/textsearch-parsers.html
> share/doc/postgresql/html/textsearch-psql.html
> share/doc/postgresql/html/textsearch-tables.html
> @@ -1277,7 +1307,6 @@ share/doc/postgresql/html/trigger-defini
> share/doc/postgresql/html/trigger-example.html
> share/doc/postgresql/html/trigger-interface.html
> share/doc/postgresql/html/triggers.html
> -share/doc/postgresql/html/tsearch2.html
> share/doc/postgresql/html/tsm-system-rows.html
> share/doc/postgresql/html/tsm-system-time.html
> share/doc/postgresql/html/tutorial-accessdb.html
> @@ -1308,6 +1337,7 @@ share/doc/postgresql/html/typeconv-func.
> share/doc/postgresql/html/typeconv-oper.html
> share/doc/postgresql/html/typeconv-overview.html
> share/doc/postgresql/html/typeconv-query.html
> +share/doc/postgresql/html/typeconv-select.html
> share/doc/postgresql/html/typeconv-union-case.html
> share/doc/postgresql/html/typeconv.html
> share/doc/postgresql/html/unaccent.html
> @@ -1323,17 +1353,20 @@ share/doc/postgresql/html/view-pg-config
> share/doc/postgresql/html/view-pg-cursors.html
> share/doc/postgresql/html/view-pg-file-settings.html
> share/doc/postgresql/html/view-pg-group.html
> +share/doc/postgresql/html/view-pg-hba-file-rules.html
> share/doc/postgresql/html/view-pg-indexes.html
> share/doc/postgresql/html/view-pg-locks.html
> share/doc/postgresql/html/view-pg-matviews.html
> share/doc/postgresql/html/view-pg-policies.html
> share/doc/postgresql/html/view-pg-prepared-statements.html
> share/doc/postgresql/html/view-pg-prepared-xacts.html
> +share/doc/postgresql/html/view-pg-publication-tables.html
> share/doc/postgresql/html/view-pg-replication-origin-status.html
> share/doc/postgresql/html/view-pg-replication-slots.html
> share/doc/postgresql/html/view-pg-roles.html
> share/doc/postgresql/html/view-pg-rules.html
> share/doc/postgresql/html/view-pg-seclabels.html
> +share/doc/postgresql/html/view-pg-sequences.html
> share/doc/postgresql/html/view-pg-settings.html
> share/doc/postgresql/html/view-pg-shadow.html
> share/doc/postgresql/html/view-pg-stats.html
> Index: postgresql/pkg/PLIST-main
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-main,v
> retrieving revision 1.27
> diff -u -p -u -p -r1.27 PLIST-main
> --- postgresql/pkg/PLIST-main 18 Dec 2016 18:18:27 -0000 1.27
> +++ postgresql/pkg/PLIST-main 1 Nov 2017 16:46:44 -0000
> @@ -5,17 +5,13 @@
> @pkgpath databases/postgresql
> @bin bin/clusterdb
> @bin bin/createdb
> -@bin bin/createlang
> @bin bin/createuser
> @bin bin/dropdb
> -@bin bin/droplang
> @bin bin/dropuser
> @bin bin/ecpg
> -@bin bin/pg_basebackup
> @bin bin/pg_config
> @bin bin/pg_dump
> @bin bin/pg_dumpall
> -@bin bin/pg_receivexlog
> @bin bin/pg_restore
> @bin bin/psql
> @bin bin/reindexdb
> @@ -98,20 +94,15 @@ lib/postgresql/pgxs/src/test/regress/
> @bin lib/postgresql/pgxs/src/test/regress/pg_regress
> @man man/man1/clusterdb.1
> @man man/man1/createdb.1
> -@man man/man1/createlang.1
> @man man/man1/createuser.1
> @man man/man1/dropdb.1
> -@man man/man1/droplang.1
> @man man/man1/dropuser.1
> @man man/man1/ecpg.1
> -@man man/man1/pg_basebackup.1
> @man man/man1/pg_config.1
> @man man/man1/pg_dump.1
> @man man/man1/pg_dumpall.1
> @man man/man1/pg_isready.1
> -@man man/man1/pg_receivexlog.1
> @man man/man1/pg_restore.1
> -@man man/man1/pg_xlogdump.1
> @man man/man1/psql.1
> @man man/man1/reindexdb.1
> @man man/man1/vacuumdb.1
> @@ -149,16 +140,17 @@ lib/postgresql/pgxs/src/test/regress/
> @man man/man3/SPI_modifytuple.3
> @man man/man3/SPI_palloc.3
> @man man/man3/SPI_pfree.3
> -@man man/man3/SPI_pop.3
> @man man/man3/SPI_prepare.3
> @man man/man3/SPI_prepare_cursor.3
> @man man/man3/SPI_prepare_params.3
> -@man man/man3/SPI_push.3
> +@man man/man3/SPI_register_relation.3
> +@man man/man3/SPI_register_trigger_data.3
> @man man/man3/SPI_repalloc.3
> @man man/man3/SPI_returntuple.3
> @man man/man3/SPI_saveplan.3
> @man man/man3/SPI_scroll_cursor_fetch.3
> @man man/man3/SPI_scroll_cursor_move.3
> +@man man/man3/SPI_unregister_relation.3
> @man man/man3/dblink.3
> @man man/man3/dblink_build_sql_delete.3
> @man man/man3/dblink_build_sql_insert.3
> @@ -199,11 +191,14 @@ lib/postgresql/pgxs/src/test/regress/
> @man man/man7/ALTER_OPERATOR_CLASS.7
> @man man/man7/ALTER_OPERATOR_FAMILY.7
> @man man/man7/ALTER_POLICY.7
> +@man man/man7/ALTER_PUBLICATION.7
> @man man/man7/ALTER_ROLE.7
> @man man/man7/ALTER_RULE.7
> @man man/man7/ALTER_SCHEMA.7
> @man man/man7/ALTER_SEQUENCE.7
> @man man/man7/ALTER_SERVER.7
> +@man man/man7/ALTER_STATISTICS.7
> +@man man/man7/ALTER_SUBSCRIPTION.7
> @man man/man7/ALTER_SYSTEM.7
> @man man/man7/ALTER_TABLE.7
> @man man/man7/ALTER_TABLESPACE.7
> @@ -245,11 +240,14 @@ lib/postgresql/pgxs/src/test/regress/
> @man man/man7/CREATE_OPERATOR_CLASS.7
> @man man/man7/CREATE_OPERATOR_FAMILY.7
> @man man/man7/CREATE_POLICY.7
> +@man man/man7/CREATE_PUBLICATION.7
> @man man/man7/CREATE_ROLE.7
> @man man/man7/CREATE_RULE.7
> @man man/man7/CREATE_SCHEMA.7
> @man man/man7/CREATE_SEQUENCE.7
> @man man/man7/CREATE_SERVER.7
> +@man man/man7/CREATE_STATISTICS.7
> +@man man/man7/CREATE_SUBSCRIPTION.7
> @man man/man7/CREATE_TABLE.7
> @man man/man7/CREATE_TABLESPACE.7
> @man man/man7/CREATE_TABLE_AS.7
> @@ -289,11 +287,14 @@ lib/postgresql/pgxs/src/test/regress/
> @man man/man7/DROP_OPERATOR_FAMILY.7
> @man man/man7/DROP_OWNED.7
> @man man/man7/DROP_POLICY.7
> +@man man/man7/DROP_PUBLICATION.7
> @man man/man7/DROP_ROLE.7
> @man man/man7/DROP_RULE.7
> @man man/man7/DROP_SCHEMA.7
> @man man/man7/DROP_SEQUENCE.7
> @man man/man7/DROP_SERVER.7
> +@man man/man7/DROP_STATISTICS.7
> +@man man/man7/DROP_SUBSCRIPTION.7
> @man man/man7/DROP_TABLE.7
> @man man/man7/DROP_TABLESPACE.7
> @man man/man7/DROP_TEXT_SEARCH_CONFIGURATION.7
> Index: postgresql/pkg/PLIST-plpython
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-plpython,v
> retrieving revision 1.6
> diff -u -p -u -p -r1.6 PLIST-plpython
> --- postgresql/pkg/PLIST-plpython 2 Sep 2014 13:39:39 -0000 1.6
> +++ postgresql/pkg/PLIST-plpython 1 Nov 2017 16:38:47 -0000
> @@ -1,5 +1,21 @@
> @comment $OpenBSD: PLIST-plpython,v 1.6 2014/09/02 13:39:39 pea Exp $
> +include/postgresql/server/plpy_util.h
> +include/postgresql/server/plpython.h
> +lib/postgresql/hstore_plpython2.so
> +lib/postgresql/ltree_plpython2.so
> lib/postgresql/plpython2.so
> +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
> +share/postgresql/extension/ltree_plpython2u--1.0.sql
> +share/postgresql/extension/ltree_plpython2u.control
> +share/postgresql/extension/ltree_plpython3u--1.0.sql
> +share/postgresql/extension/ltree_plpython3u.control
> +share/postgresql/extension/ltree_plpythonu--1.0.sql
> +share/postgresql/extension/ltree_plpythonu.control
> share/postgresql/extension/plpython2u--1.0.sql
> share/postgresql/extension/plpython2u--unpackaged--1.0.sql
> share/postgresql/extension/plpython2u.control
> Index: postgresql/pkg/PLIST-server
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v
> retrieving revision 1.32
> diff -u -p -u -p -r1.32 PLIST-server
> --- postgresql/pkg/PLIST-server 17 May 2017 07:34:19 -0000 1.32
> +++ postgresql/pkg/PLIST-server 1 Nov 2017 16:48:46 -0000
> @@ -8,13 +8,15 @@
> @newgroup _postgresql:503
> @newuser _postgresql:503:_postgresql:daemon:PostgreSQL
> Manager:/var/postgresql:/bin/sh
> @bin bin/initdb
> +@bin bin/pg_basebackup
> @bin bin/pg_controldata
> @bin bin/pg_ctl
> @bin bin/pg_isready
> +@bin bin/pg_receivewal
> @bin bin/pg_recvlogical
> -@bin bin/pg_resetxlog
> +@bin bin/pg_resetwal
> @bin bin/pg_rewind
> -@bin bin/pg_xlogdump
> +@bin bin/pg_waldump
> @bin bin/postgres
> bin/postmaster
> include/postgresql/server/
> @@ -29,16 +31,21 @@ include/postgresql/server/access/brin_pa
> include/postgresql/server/access/brin_revmap.h
> include/postgresql/server/access/brin_tuple.h
> include/postgresql/server/access/brin_xlog.h
> +include/postgresql/server/access/bufmask.h
> include/postgresql/server/access/clog.h
> include/postgresql/server/access/commit_ts.h
> include/postgresql/server/access/genam.h
> include/postgresql/server/access/generic_xlog.h
> include/postgresql/server/access/gin.h
> include/postgresql/server/access/gin_private.h
> +include/postgresql/server/access/ginblock.h
> +include/postgresql/server/access/ginxlog.h
> include/postgresql/server/access/gist.h
> include/postgresql/server/access/gist_private.h
> include/postgresql/server/access/gistscan.h
> +include/postgresql/server/access/gistxlog.h
> include/postgresql/server/access/hash.h
> +include/postgresql/server/access/hash_xlog.h
> include/postgresql/server/access/heapam.h
> include/postgresql/server/access/heapam_xlog.h
> include/postgresql/server/access/hio.h
> @@ -47,7 +54,9 @@ include/postgresql/server/access/htup_de
> include/postgresql/server/access/itup.h
> include/postgresql/server/access/multixact.h
> include/postgresql/server/access/nbtree.h
> +include/postgresql/server/access/nbtxlog.h
> include/postgresql/server/access/parallel.h
> +include/postgresql/server/access/printsimple.h
> include/postgresql/server/access/printtup.h
> include/postgresql/server/access/reloptions.h
> include/postgresql/server/access/relscan.h
> @@ -59,6 +68,7 @@ include/postgresql/server/access/skey.h
> include/postgresql/server/access/slru.h
> include/postgresql/server/access/spgist.h
> include/postgresql/server/access/spgist_private.h
> +include/postgresql/server/access/spgxlog.h
> include/postgresql/server/access/stratnum.h
> include/postgresql/server/access/subtrans.h
> include/postgresql/server/access/sysattr.h
> @@ -75,7 +85,6 @@ include/postgresql/server/access/valid.h
> include/postgresql/server/access/visibilitymap.h
> include/postgresql/server/access/xact.h
> include/postgresql/server/access/xlog.h
> -include/postgresql/server/access/xlog_fn.h
> include/postgresql/server/access/xlog_internal.h
> include/postgresql/server/access/xlogdefs.h
> include/postgresql/server/access/xloginsert.h
> @@ -98,6 +107,7 @@ include/postgresql/server/catalog/namesp
> include/postgresql/server/catalog/objectaccess.h
> include/postgresql/server/catalog/objectaddress.h
> include/postgresql/server/catalog/opfam_internal.h
> +include/postgresql/server/catalog/partition.h
> include/postgresql/server/catalog/pg_aggregate.h
> include/postgresql/server/catalog/pg_am.h
> include/postgresql/server/catalog/pg_amop.h
> @@ -138,18 +148,25 @@ include/postgresql/server/catalog/pg_opc
> include/postgresql/server/catalog/pg_operator.h
> include/postgresql/server/catalog/pg_operator_fn.h
> include/postgresql/server/catalog/pg_opfamily.h
> +include/postgresql/server/catalog/pg_partitioned_table.h
> include/postgresql/server/catalog/pg_pltemplate.h
> include/postgresql/server/catalog/pg_policy.h
> include/postgresql/server/catalog/pg_proc.h
> include/postgresql/server/catalog/pg_proc_fn.h
> +include/postgresql/server/catalog/pg_publication.h
> +include/postgresql/server/catalog/pg_publication_rel.h
> include/postgresql/server/catalog/pg_range.h
> include/postgresql/server/catalog/pg_replication_origin.h
> include/postgresql/server/catalog/pg_rewrite.h
> include/postgresql/server/catalog/pg_seclabel.h
> +include/postgresql/server/catalog/pg_sequence.h
> include/postgresql/server/catalog/pg_shdepend.h
> include/postgresql/server/catalog/pg_shdescription.h
> include/postgresql/server/catalog/pg_shseclabel.h
> include/postgresql/server/catalog/pg_statistic.h
> +include/postgresql/server/catalog/pg_statistic_ext.h
> +include/postgresql/server/catalog/pg_subscription.h
> +include/postgresql/server/catalog/pg_subscription_rel.h
> include/postgresql/server/catalog/pg_tablespace.h
> include/postgresql/server/catalog/pg_transform.h
> include/postgresql/server/catalog/pg_trigger.h
> @@ -188,9 +205,11 @@ include/postgresql/server/commands/porta
> include/postgresql/server/commands/prepare.h
> include/postgresql/server/commands/proclang.h
> include/postgresql/server/commands/progress.h
> +include/postgresql/server/commands/publicationcmds.h
> include/postgresql/server/commands/schemacmds.h
> include/postgresql/server/commands/seclabel.h
> include/postgresql/server/commands/sequence.h
> +include/postgresql/server/commands/subscriptioncmds.h
> include/postgresql/server/commands/tablecmds.h
> include/postgresql/server/commands/tablespace.h
> include/postgresql/server/commands/trigger.h
> @@ -200,20 +219,30 @@ include/postgresql/server/commands/vacuu
> include/postgresql/server/commands/variable.h
> include/postgresql/server/commands/view.h
> include/postgresql/server/common/
> +include/postgresql/server/common/base64.h
> include/postgresql/server/common/config_info.h
> include/postgresql/server/common/controldata_utils.h
> include/postgresql/server/common/fe_memutils.h
> +include/postgresql/server/common/file_utils.h
> include/postgresql/server/common/int128.h
> +include/postgresql/server/common/ip.h
> include/postgresql/server/common/keywords.h
> +include/postgresql/server/common/md5.h
> include/postgresql/server/common/pg_lzcompress.h
> include/postgresql/server/common/relpath.h
> include/postgresql/server/common/restricted_token.h
> +include/postgresql/server/common/saslprep.h
> +include/postgresql/server/common/scram-common.h
> +include/postgresql/server/common/sha2.h
> include/postgresql/server/common/string.h
> +include/postgresql/server/common/unicode_norm.h
> +include/postgresql/server/common/unicode_norm_table.h
> include/postgresql/server/common/username.h
> include/postgresql/server/datatype/
> include/postgresql/server/datatype/timestamp.h
> include/postgresql/server/dynloader.h
> include/postgresql/server/executor/
> +include/postgresql/server/executor/execExpr.h
> include/postgresql/server/executor/execParallel.h
> include/postgresql/server/executor/execdebug.h
> include/postgresql/server/executor/execdesc.h
> @@ -232,6 +261,7 @@ include/postgresql/server/executor/nodeC
> include/postgresql/server/executor/nodeForeignscan.h
> include/postgresql/server/executor/nodeFunctionscan.h
> include/postgresql/server/executor/nodeGather.h
> +include/postgresql/server/executor/nodeGatherMerge.h
> include/postgresql/server/executor/nodeGroup.h
> include/postgresql/server/executor/nodeHash.h
> include/postgresql/server/executor/nodeHashjoin.h
> @@ -243,7 +273,9 @@ include/postgresql/server/executor/nodeM
> include/postgresql/server/executor/nodeMergeAppend.h
> include/postgresql/server/executor/nodeMergejoin.h
> include/postgresql/server/executor/nodeModifyTable.h
> +include/postgresql/server/executor/nodeNamedtuplestorescan.h
> include/postgresql/server/executor/nodeNestloop.h
> +include/postgresql/server/executor/nodeProjectSet.h
> include/postgresql/server/executor/nodeRecursiveunion.h
> include/postgresql/server/executor/nodeResult.h
> include/postgresql/server/executor/nodeSamplescan.h
> @@ -252,6 +284,7 @@ include/postgresql/server/executor/nodeS
> include/postgresql/server/executor/nodeSort.h
> include/postgresql/server/executor/nodeSubplan.h
> include/postgresql/server/executor/nodeSubqueryscan.h
> +include/postgresql/server/executor/nodeTableFuncscan.h
> include/postgresql/server/executor/nodeTidscan.h
> include/postgresql/server/executor/nodeUnique.h
> include/postgresql/server/executor/nodeValuesscan.h
> @@ -259,6 +292,7 @@ include/postgresql/server/executor/nodeW
> include/postgresql/server/executor/nodeWorktablescan.h
> include/postgresql/server/executor/spi.h
> include/postgresql/server/executor/spi_priv.h
> +include/postgresql/server/executor/tablefunc.h
> include/postgresql/server/executor/tqueue.h
> include/postgresql/server/executor/tstoreReceiver.h
> include/postgresql/server/executor/tuptable.h
> @@ -280,23 +314,25 @@ include/postgresql/server/lib/
> include/postgresql/server/lib/binaryheap.h
> include/postgresql/server/lib/bipartite_match.h
> include/postgresql/server/lib/hyperloglog.h
> +include/postgresql/server/lib/knapsack.h
> include/postgresql/server/lib/ilist.h
> include/postgresql/server/lib/pairingheap.h
> include/postgresql/server/lib/rbtree.h
> +include/postgresql/server/lib/simplehash.h
> include/postgresql/server/lib/stringinfo.h
> include/postgresql/server/libpq/
> include/postgresql/server/libpq/auth.h
> include/postgresql/server/libpq/be-fsstubs.h
> include/postgresql/server/libpq/crypt.h
> include/postgresql/server/libpq/hba.h
> -include/postgresql/server/libpq/ip.h
> +include/postgresql/server/libpq/ifaddr.h
> include/postgresql/server/libpq/libpq-be.h
> include/postgresql/server/libpq/libpq-fs.h
> include/postgresql/server/libpq/libpq.h
> -include/postgresql/server/libpq/md5.h
> include/postgresql/server/libpq/pqcomm.h
> include/postgresql/server/libpq/pqformat.h
> include/postgresql/server/libpq/pqmq.h
> +include/postgresql/server/libpq/scram.h
> include/postgresql/server/libpq/pqsignal.h
> include/postgresql/server/mb/
> include/postgresql/server/mb/pg_wchar.h
> @@ -357,6 +393,7 @@ include/postgresql/server/parser/parse_c
> include/postgresql/server/parser/parse_coerce.h
> include/postgresql/server/parser/parse_collate.h
> include/postgresql/server/parser/parse_cte.h
> +include/postgresql/server/parser/parse_enr.h
> include/postgresql/server/parser/parse_expr.h
> include/postgresql/server/parser/parse_func.h
> include/postgresql/server/parser/parse_node.h
> @@ -381,8 +418,6 @@ include/postgresql/server/pgtar.h
> include/postgresql/server/pgtime.h
> include/postgresql/server/plperl.h
> include/postgresql/server/plpgsql.h
> -include/postgresql/server/plpy_util.h
> -include/postgresql/server/plpython.h
> include/postgresql/server/port/
> include/postgresql/server/port.h
> include/postgresql/server/port/aix.h
> @@ -409,9 +444,7 @@ include/postgresql/server/port/netbsd.h
> include/postgresql/server/port/openbsd.h
> include/postgresql/server/port/pg_bswap.h
> include/postgresql/server/port/pg_crc32c.h
> -include/postgresql/server/port/sco.h
> include/postgresql/server/port/solaris.h
> -include/postgresql/server/port/unixware.h
> @comment include/postgresql/server/port/win32/
> @comment include/postgresql/server/port/win32.h
> @comment include/postgresql/server/port/win32/arpa/
> @@ -462,9 +495,14 @@ include/postgresql/server/replication/ba
> include/postgresql/server/replication/decode.h
> include/postgresql/server/replication/logical.h
> include/postgresql/server/replication/logicalfuncs.h
> +include/postgresql/server/replication/logicallauncher.h
> +include/postgresql/server/replication/logicalproto.h
> +include/postgresql/server/replication/logicalrelation.h
> +include/postgresql/server/replication/logicalworker.h
> include/postgresql/server/replication/message.h
> include/postgresql/server/replication/origin.h
> include/postgresql/server/replication/output_plugin.h
> +include/postgresql/server/replication/pgoutput.h
> include/postgresql/server/replication/reorderbuffer.h
> include/postgresql/server/replication/slot.h
> include/postgresql/server/replication/snapbuild.h
> @@ -472,6 +510,7 @@ include/postgresql/server/replication/sy
> include/postgresql/server/replication/walreceiver.h
> include/postgresql/server/replication/walsender.h
> include/postgresql/server/replication/walsender_private.h
> +include/postgresql/server/replication/worker_internal.h
> include/postgresql/server/rewrite/
> include/postgresql/server/rewrite/prs2lock.h
> include/postgresql/server/rewrite/rewriteDefine.h
> @@ -517,9 +556,11 @@ include/postgresql/server/snowball/libst
> include/postgresql/server/snowball/libstemmer/stem_UTF_8_spanish.h
> include/postgresql/server/snowball/libstemmer/stem_UTF_8_swedish.h
> include/postgresql/server/snowball/libstemmer/stem_UTF_8_turkish.h
> +include/postgresql/server/statistics/
> +include/postgresql/server/statistics/extended_stats_internal.h
> +include/postgresql/server/statistics/statistics.h
> include/postgresql/server/storage/
> include/postgresql/server/storage/backendid.h
> -include/postgresql/server/storage/barrier.h
> include/postgresql/server/storage/block.h
> include/postgresql/server/storage/buf.h
> include/postgresql/server/storage/buf_internals.h
> @@ -528,6 +569,7 @@ include/postgresql/server/storage/bufmgr
> include/postgresql/server/storage/bufpage.h
> include/postgresql/server/storage/checksum.h
> include/postgresql/server/storage/checksum_impl.h
> +include/postgresql/server/storage/condition_variable.h
> include/postgresql/server/storage/copydir.h
> include/postgresql/server/storage/dsm.h
> include/postgresql/server/storage/dsm_impl.h
> @@ -550,11 +592,12 @@ include/postgresql/server/storage/off.h
> include/postgresql/server/storage/pg_sema.h
> include/postgresql/server/storage/pg_shmem.h
> include/postgresql/server/storage/pmsignal.h
> -include/postgresql/server/storage/pos.h
> include/postgresql/server/storage/predicate.h
> include/postgresql/server/storage/predicate_internals.h
> include/postgresql/server/storage/proc.h
> include/postgresql/server/storage/procarray.h
> +include/postgresql/server/storage/proclist.h
> +include/postgresql/server/storage/proclist_types.h
> include/postgresql/server/storage/procsignal.h
> include/postgresql/server/storage/reinit.h
> include/postgresql/server/storage/relfilenode.h
> @@ -591,6 +634,7 @@ include/postgresql/server/utils/array.h
> include/postgresql/server/utils/arrayaccess.h
> include/postgresql/server/utils/ascii.h
> include/postgresql/server/utils/attoptcache.h
> +include/postgresql/server/utils/backend_random.h
> include/postgresql/server/utils/builtins.h
> include/postgresql/server/utils/bytea.h
> include/postgresql/server/utils/cash.h
> @@ -599,6 +643,7 @@ include/postgresql/server/utils/combocid
> include/postgresql/server/utils/date.h
> include/postgresql/server/utils/datetime.h
> include/postgresql/server/utils/datum.h
> +include/postgresql/server/utils/dsa.h
> include/postgresql/server/utils/dynahash.h
> include/postgresql/server/utils/dynamic_loader.h
> include/postgresql/server/utils/elog.h
> @@ -606,8 +651,10 @@ include/postgresql/server/utils/errcodes
> include/postgresql/server/utils/evtcache.h
> include/postgresql/server/utils/expandeddatum.h
> include/postgresql/server/utils/fmgroids.h
> +include/postgresql/server/utils/fmgrprotos.h
> include/postgresql/server/utils/fmgrtab.h
> include/postgresql/server/utils/formatting.h
> +include/postgresql/server/utils/freepage.h
> include/postgresql/server/utils/geo_decls.h
> include/postgresql/server/utils/guc.h
> include/postgresql/server/utils/guc_tables.h
> @@ -631,15 +678,19 @@ include/postgresql/server/utils/pg_crc.h
> include/postgresql/server/utils/pg_locale.h
> include/postgresql/server/utils/pg_lsn.h
> include/postgresql/server/utils/pg_rusage.h
> +include/postgresql/server/utils/pidfile.h
> include/postgresql/server/utils/plancache.h
> include/postgresql/server/utils/portal.h
> include/postgresql/server/utils/probes.h
> include/postgresql/server/utils/ps_status.h
> +include/postgresql/server/utils/queryenvironment.h
> include/postgresql/server/utils/rangetypes.h
> +include/postgresql/server/utils/regproc.h
> include/postgresql/server/utils/rel.h
> include/postgresql/server/utils/relcache.h
> include/postgresql/server/utils/relfilenodemap.h
> include/postgresql/server/utils/relmapper.h
> +include/postgresql/server/utils/relptr.h
> include/postgresql/server/utils/reltrigger.h
> include/postgresql/server/utils/resowner.h
> include/postgresql/server/utils/resowner_private.h
> @@ -661,6 +712,7 @@ include/postgresql/server/utils/typcache
> include/postgresql/server/utils/tzparser.h
> include/postgresql/server/utils/uuid.h
> include/postgresql/server/utils/varbit.h
> +include/postgresql/server/utils/varlena.h
> include/postgresql/server/utils/xml.h
> include/postgresql/server/windowapi.h
> lib/postgresql/ascii_and_mic.so
> @@ -676,6 +728,7 @@ lib/postgresql/euc_tw_and_big5.so
> lib/postgresql/latin2_and_win1250.so
> lib/postgresql/latin_and_mic.so
> lib/postgresql/libpqwalreceiver.so
> +lib/postgresql/pgoutput.so
> lib/postgresql/plperl.so
> lib/postgresql/plpgsql.so
> lib/postgresql/test_decoding.so
> @@ -697,11 +750,14 @@ lib/postgresql/utf8_and_sjis2004.so
> lib/postgresql/utf8_and_uhc.so
> lib/postgresql/utf8_and_win.so
> @man man/man1/initdb.1
> +@man man/man1/pg_basebackup.1
> @man man/man1/pg_controldata.1
> @man man/man1/pg_ctl.1
> +@man man/man1/pg_receivewal.1
> @man man/man1/pg_recvlogical.1
> -@man man/man1/pg_resetxlog.1
> +@man man/man1/pg_resetwal.1
> @man man/man1/pg_rewind.1
> +@man man/man1/pg_waldump.1
> @man man/man1/postgres.1
> @man man/man1/postmaster.1
> share/doc/pkg-readmes/${FULLPKGNAME}
> Index: postgresql-previous/Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql-previous/Makefile,v
> retrieving revision 1.3
> diff -u -p -u -p -r1.3 Makefile
> --- postgresql-previous/Makefile 13 Jun 2017 12:31:44 -0000 1.3
> +++ postgresql-previous/Makefile 1 Nov 2017 17:11:57 -0000
> @@ -2,15 +2,15 @@
>
> COMMENT= PostgreSQL RDBMS (previous version, for pg_upgrade)
>
> -VERSION= 9.5.5
> +VERSION= 9.6.5
> DISTNAME= postgresql-${VERSION}
> PKGNAME= postgresql-previous-${VERSION}
>
> CATEGORIES= databases
> -SHARED_LIBS= ecpg 7.7 \
> - ecpg_compat 4.7 \
> - pgtypes 4.6 \
> - pq 6.8
> +SHARED_LIBS= ecpg 7.8 \
> + ecpg_compat 4.8 \
> + pgtypes 4.7 \
> + pq 6.9
>
> HOMEPAGE= http://www.postgresql.org/
>
> @@ -72,7 +72,7 @@ ALL_TARGET= all
> INSTALL_TARGET= install
>
> LIB_DEPENDS = textproc/libxml
> -WANTLIB += c crypto m readline ssl termcap z xml2 perl util
> +WANTLIB += c crypto m readline ssl termcap z xml2 perl
>
> MAKE_ENV= LIBpq_MAJOR=${LIBpq_VERSION:R} \
> LIBpq_MINOR=${LIBpq_VERSION:E} \
> Index: postgresql-previous/distinfo
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql-previous/distinfo,v
> retrieving revision 1.1.1.1
> diff -u -p -u -p -r1.1.1.1 distinfo
> --- postgresql-previous/distinfo 18 Dec 2016 18:13:25 -0000 1.1.1.1
> +++ postgresql-previous/distinfo 1 Nov 2017 16:51:10 -0000
> @@ -1,2 +1,2 @@
> -SHA256 (postgresql-9.5.5.tar.gz) =
> mZ+pKe95/Rns/PFdFohYQW6psZ88G7lCggSC3obhCSQ=
> -SIZE (postgresql-9.5.5.tar.gz) = 24194032
> +SHA256 (postgresql-9.6.5.tar.gz) =
> eelgXTIbVFsu2d8Yrf0uUslQ3JNGtl6VJ/EXExYn3Ao=
> +SIZE (postgresql-9.6.5.tar.gz) = 25652523
> Index:
> postgresql-previous/patches/patch-src_interfaces_ecpg_compatlib_Makefile
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql-previous/patches/patch-src_interfaces_ecpg_compatlib_Makefile,v
> retrieving revision 1.1.1.1
> diff -u -p -u -p -r1.1.1.1 patch-src_interfaces_ecpg_compatlib_Makefile
> --- postgresql-previous/patches/patch-src_interfaces_ecpg_compatlib_Makefile
> 18 Dec 2016 18:13:25 -0000 1.1.1.1
> +++ postgresql-previous/patches/patch-src_interfaces_ecpg_compatlib_Makefile
> 1 Nov 2017 16:51:47 -0000
> @@ -6,7 +6,7 @@ $OpenBSD: patch-src_interfaces_ecpg_comp
>
> NAME= ecpg_compat
> -SO_MAJOR_VERSION= 3
> --SO_MINOR_VERSION= 7
> +-SO_MINOR_VERSION= 8
> +SO_MAJOR_VERSION= ${LIBecpg_compat_MAJOR}
> +SO_MINOR_VERSION= ${LIBecpg_compat_MINOR}
>
> Index: postgresql-previous/patches/patch-src_interfaces_ecpg_ecpglib_Makefile
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql-previous/patches/patch-src_interfaces_ecpg_ecpglib_Makefile,v
> retrieving revision 1.1.1.1
> diff -u -p -u -p -r1.1.1.1 patch-src_interfaces_ecpg_ecpglib_Makefile
> --- postgresql-previous/patches/patch-src_interfaces_ecpg_ecpglib_Makefile
> 18 Dec 2016 18:13:25 -0000 1.1.1.1
> +++ postgresql-previous/patches/patch-src_interfaces_ecpg_ecpglib_Makefile
> 1 Nov 2017 16:51:56 -0000
> @@ -6,7 +6,7 @@ $OpenBSD: patch-src_interfaces_ecpg_ecpg
>
> NAME= ecpg
> -SO_MAJOR_VERSION= 6
> --SO_MINOR_VERSION= 7
> +-SO_MINOR_VERSION= 8
> +SO_MAJOR_VERSION= ${LIBecpg_MAJOR}
> +SO_MINOR_VERSION= ${LIBecpg_MINOR}
>
> Index:
> postgresql-previous/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql-previous/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile,v
> retrieving revision 1.1.1.1
> diff -u -p -u -p -r1.1.1.1 patch-src_interfaces_ecpg_pgtypeslib_Makefile
> --- postgresql-previous/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile
> 18 Dec 2016 18:13:25 -0000 1.1.1.1
> +++ postgresql-previous/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile
> 1 Nov 2017 16:52:03 -0000
> @@ -6,7 +6,7 @@ $OpenBSD: patch-src_interfaces_ecpg_pgty
>
> NAME= pgtypes
> -SO_MAJOR_VERSION= 3
> --SO_MINOR_VERSION= 6
> +-SO_MINOR_VERSION= 7
> +SO_MAJOR_VERSION= ${LIBpgtypes_MAJOR}
> +SO_MINOR_VERSION= ${LIBpgtypes_MINOR}
> +
> Index: postgresql-previous/patches/patch-src_interfaces_libpq_Makefile
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql-previous/patches/patch-src_interfaces_libpq_Makefile,v
> retrieving revision 1.1.1.1
> diff -u -p -u -p -r1.1.1.1 patch-src_interfaces_libpq_Makefile
> --- postgresql-previous/patches/patch-src_interfaces_libpq_Makefile 18 Dec
> 2016 18:13:25 -0000 1.1.1.1
> +++ postgresql-previous/patches/patch-src_interfaces_libpq_Makefile 1 Nov
> 2017 16:52:08 -0000
> @@ -6,7 +6,7 @@ $OpenBSD: patch-src_interfaces_libpq_Mak
> # shared library parameters
> NAME= pq
> -SO_MAJOR_VERSION= 5
> --SO_MINOR_VERSION= 8
> +-SO_MINOR_VERSION= 9
> +SO_MAJOR_VERSION= ${LIBpq_MAJOR}
> +SO_MINOR_VERSION= ${LIBpq_MINOR}
>
> Index: postgresql-previous/pkg/PLIST
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql-previous/pkg/PLIST,v
> retrieving revision 1.1.1.1
> diff -u -p -u -p -r1.1.1.1 PLIST
> --- postgresql-previous/pkg/PLIST 18 Dec 2016 18:13:26 -0000 1.1.1.1
> +++ postgresql-previous/pkg/PLIST 1 Nov 2017 17:06:40 -0000
> @@ -70,6 +70,8 @@ include/${POSTGRESQL_DIR}/pgtypes_timest
> include/${POSTGRESQL_DIR}/postgres_ext.h
> include/${POSTGRESQL_DIR}/server/
> include/${POSTGRESQL_DIR}/server/access/
> +include/${POSTGRESQL_DIR}/server/access/amapi.h
> +include/${POSTGRESQL_DIR}/server/access/amvalidate.h
> include/${POSTGRESQL_DIR}/server/access/attnum.h
> include/${POSTGRESQL_DIR}/server/access/brin.h
> include/${POSTGRESQL_DIR}/server/access/brin_internal.h
> @@ -81,6 +83,7 @@ include/${POSTGRESQL_DIR}/server/access/
> include/${POSTGRESQL_DIR}/server/access/clog.h
> include/${POSTGRESQL_DIR}/server/access/commit_ts.h
> include/${POSTGRESQL_DIR}/server/access/genam.h
> +include/${POSTGRESQL_DIR}/server/access/generic_xlog.h
> include/${POSTGRESQL_DIR}/server/access/gin.h
> include/${POSTGRESQL_DIR}/server/access/gin_private.h
> include/${POSTGRESQL_DIR}/server/access/gist.h
> @@ -159,6 +162,7 @@ include/${POSTGRESQL_DIR}/server/catalog
> include/${POSTGRESQL_DIR}/server/catalog/pg_collation.h
> include/${POSTGRESQL_DIR}/server/catalog/pg_collation_fn.h
> include/${POSTGRESQL_DIR}/server/catalog/pg_constraint.h
> +include/${POSTGRESQL_DIR}/server/catalog/pg_constraint_fn.h
> include/${POSTGRESQL_DIR}/server/catalog/pg_control.h
> include/${POSTGRESQL_DIR}/server/catalog/pg_conversion.h
> include/${POSTGRESQL_DIR}/server/catalog/pg_conversion_fn.h
> @@ -176,6 +180,7 @@ include/${POSTGRESQL_DIR}/server/catalog
> include/${POSTGRESQL_DIR}/server/catalog/pg_index.h
> include/${POSTGRESQL_DIR}/server/catalog/pg_inherits.h
> include/${POSTGRESQL_DIR}/server/catalog/pg_inherits_fn.h
> +include/${POSTGRESQL_DIR}/server/catalog/pg_init_privs.h
> include/${POSTGRESQL_DIR}/server/catalog/pg_language.h
> include/${POSTGRESQL_DIR}/server/catalog/pg_largeobject.h
> include/${POSTGRESQL_DIR}/server/catalog/pg_largeobject_metadata.h
> @@ -233,6 +238,7 @@ include/${POSTGRESQL_DIR}/server/command
> include/${POSTGRESQL_DIR}/server/commands/portalcmds.h
> include/${POSTGRESQL_DIR}/server/commands/prepare.h
> include/${POSTGRESQL_DIR}/server/commands/proclang.h
> +include/${POSTGRESQL_DIR}/server/commands/progress.h
> include/${POSTGRESQL_DIR}/server/commands/schemacmds.h
> include/${POSTGRESQL_DIR}/server/commands/seclabel.h
> include/${POSTGRESQL_DIR}/server/commands/sequence.h
> @@ -245,7 +251,11 @@ include/${POSTGRESQL_DIR}/server/command
> include/${POSTGRESQL_DIR}/server/commands/variable.h
> include/${POSTGRESQL_DIR}/server/commands/view.h
> include/${POSTGRESQL_DIR}/server/common/
> +include/${POSTGRESQL_DIR}/server/common/config_info.h
> +include/${POSTGRESQL_DIR}/server/common/controldata_utils.h
> include/${POSTGRESQL_DIR}/server/common/fe_memutils.h
> +include/${POSTGRESQL_DIR}/server/common/int128.h
> +include/${POSTGRESQL_DIR}/server/common/keywords.h
> include/${POSTGRESQL_DIR}/server/common/pg_lzcompress.h
> include/${POSTGRESQL_DIR}/server/common/relpath.h
> include/${POSTGRESQL_DIR}/server/common/restricted_token.h
> @@ -255,6 +265,7 @@ include/${POSTGRESQL_DIR}/server/datatyp
> include/${POSTGRESQL_DIR}/server/datatype/timestamp.h
> include/${POSTGRESQL_DIR}/server/dynloader.h
> include/${POSTGRESQL_DIR}/server/executor/
> +include/${POSTGRESQL_DIR}/server/executor/execParallel.h
> include/${POSTGRESQL_DIR}/server/executor/execdebug.h
> include/${POSTGRESQL_DIR}/server/executor/execdesc.h
> include/${POSTGRESQL_DIR}/server/executor/executor.h
> @@ -271,6 +282,7 @@ include/${POSTGRESQL_DIR}/server/executo
> include/${POSTGRESQL_DIR}/server/executor/nodeCustom.h
> include/${POSTGRESQL_DIR}/server/executor/nodeForeignscan.h
> include/${POSTGRESQL_DIR}/server/executor/nodeFunctionscan.h
> +include/${POSTGRESQL_DIR}/server/executor/nodeGather.h
> include/${POSTGRESQL_DIR}/server/executor/nodeGroup.h
> include/${POSTGRESQL_DIR}/server/executor/nodeHash.h
> include/${POSTGRESQL_DIR}/server/executor/nodeHashjoin.h
> @@ -298,8 +310,16 @@ include/${POSTGRESQL_DIR}/server/executo
> include/${POSTGRESQL_DIR}/server/executor/nodeWorktablescan.h
> include/${POSTGRESQL_DIR}/server/executor/spi.h
> include/${POSTGRESQL_DIR}/server/executor/spi_priv.h
> +include/${POSTGRESQL_DIR}/server/executor/tqueue.h
> include/${POSTGRESQL_DIR}/server/executor/tstoreReceiver.h
> include/${POSTGRESQL_DIR}/server/executor/tuptable.h
> +include/${POSTGRESQL_DIR}/server/fe_utils/
> +include/${POSTGRESQL_DIR}/server/fe_utils/mbprint.h
> +include/${POSTGRESQL_DIR}/server/fe_utils/print.h
> +include/${POSTGRESQL_DIR}/server/fe_utils/psqlscan.h
> +include/${POSTGRESQL_DIR}/server/fe_utils/psqlscan_int.h
> +include/${POSTGRESQL_DIR}/server/fe_utils/simple_list.h
> +include/${POSTGRESQL_DIR}/server/fe_utils/string_utils.h
> include/${POSTGRESQL_DIR}/server/fmgr.h
> include/${POSTGRESQL_DIR}/server/foreign/
> include/${POSTGRESQL_DIR}/server/foreign/fdwapi.h
> @@ -335,6 +355,7 @@ include/${POSTGRESQL_DIR}/server/miscadm
> include/${POSTGRESQL_DIR}/server/nodes/
> include/${POSTGRESQL_DIR}/server/nodes/bitmapset.h
> include/${POSTGRESQL_DIR}/server/nodes/execnodes.h
> +include/${POSTGRESQL_DIR}/server/nodes/extensible.h
> include/${POSTGRESQL_DIR}/server/nodes/lockoptions.h
> include/${POSTGRESQL_DIR}/server/nodes/makefuncs.h
> include/${POSTGRESQL_DIR}/server/nodes/memnodes.h
> @@ -381,7 +402,6 @@ include/${POSTGRESQL_DIR}/server/parser/
> include/${POSTGRESQL_DIR}/server/parser/analyze.h
> include/${POSTGRESQL_DIR}/server/parser/gram.h
> include/${POSTGRESQL_DIR}/server/parser/gramparse.h
> -include/${POSTGRESQL_DIR}/server/parser/keywords.h
> include/${POSTGRESQL_DIR}/server/parser/kwlist.h
> include/${POSTGRESQL_DIR}/server/parser/parse_agg.h
> include/${POSTGRESQL_DIR}/server/parser/parse_clause.h
> @@ -436,31 +456,11 @@ include/${POSTGRESQL_DIR}/server/port/hp
> include/${POSTGRESQL_DIR}/server/port/linux.h
> include/${POSTGRESQL_DIR}/server/port/netbsd.h
> include/${POSTGRESQL_DIR}/server/port/openbsd.h
> +include/${POSTGRESQL_DIR}/server/port/pg_bswap.h
> include/${POSTGRESQL_DIR}/server/port/pg_crc32c.h
> include/${POSTGRESQL_DIR}/server/port/sco.h
> include/${POSTGRESQL_DIR}/server/port/solaris.h
> include/${POSTGRESQL_DIR}/server/port/unixware.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/
> -@comment include/${POSTGRESQL_DIR}/server/port/win32.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/arpa/
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/arpa/inet.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/dlfcn.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/grp.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/netdb.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/netinet/
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/netinet/in.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/pwd.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/sys/
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/sys/socket.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32/sys/wait.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32_msvc/
> -@comment include/${POSTGRESQL_DIR}/server/port/win32_msvc/dirent.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32_msvc/sys/
> -@comment include/${POSTGRESQL_DIR}/server/port/win32_msvc/sys/file.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32_msvc/sys/param.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32_msvc/sys/time.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32_msvc/unistd.h
> -@comment include/${POSTGRESQL_DIR}/server/port/win32_msvc/utime.h
> include/${POSTGRESQL_DIR}/server/portability/
> include/${POSTGRESQL_DIR}/server/portability/instr_time.h
> include/${POSTGRESQL_DIR}/server/portability/mem.h
> @@ -490,6 +490,7 @@ include/${POSTGRESQL_DIR}/server/replica
> include/${POSTGRESQL_DIR}/server/replication/decode.h
> include/${POSTGRESQL_DIR}/server/replication/logical.h
> include/${POSTGRESQL_DIR}/server/replication/logicalfuncs.h
> +include/${POSTGRESQL_DIR}/server/replication/message.h
> include/${POSTGRESQL_DIR}/server/replication/origin.h
> include/${POSTGRESQL_DIR}/server/replication/output_plugin.h
> include/${POSTGRESQL_DIR}/server/replication/reorderbuffer.h
> @@ -510,7 +511,6 @@ include/${POSTGRESQL_DIR}/server/rewrite
> include/${POSTGRESQL_DIR}/server/rusagestub.h
> include/${POSTGRESQL_DIR}/server/snowball/
> include/${POSTGRESQL_DIR}/server/snowball/header.h
> -include/${POSTGRESQL_DIR}/server/snowball/libstemmer/
> include/${POSTGRESQL_DIR}/server/snowball/libstemmer/api.h
> include/${POSTGRESQL_DIR}/server/snowball/libstemmer/header.h
> include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_danish.h
> @@ -570,7 +570,9 @@ include/${POSTGRESQL_DIR}/server/storage
> include/${POSTGRESQL_DIR}/server/storage/latch.h
> include/${POSTGRESQL_DIR}/server/storage/lmgr.h
> include/${POSTGRESQL_DIR}/server/storage/lock.h
> +include/${POSTGRESQL_DIR}/server/storage/lockdefs.h
> include/${POSTGRESQL_DIR}/server/storage/lwlock.h
> +include/${POSTGRESQL_DIR}/server/storage/lwlocknames.h
> include/${POSTGRESQL_DIR}/server/storage/off.h
> include/${POSTGRESQL_DIR}/server/storage/pg_sema.h
> include/${POSTGRESQL_DIR}/server/storage/pg_shmem.h
> @@ -592,12 +594,12 @@ include/${POSTGRESQL_DIR}/server/storage
> include/${POSTGRESQL_DIR}/server/storage/smgr.h
> include/${POSTGRESQL_DIR}/server/storage/spin.h
> include/${POSTGRESQL_DIR}/server/storage/standby.h
> +include/${POSTGRESQL_DIR}/server/storage/standbydefs.h
> include/${POSTGRESQL_DIR}/server/tcop/
> include/${POSTGRESQL_DIR}/server/tcop/deparse_utility.h
> include/${POSTGRESQL_DIR}/server/tcop/dest.h
> include/${POSTGRESQL_DIR}/server/tcop/fastpath.h
> include/${POSTGRESQL_DIR}/server/tcop/pquery.h
> -include/${POSTGRESQL_DIR}/server/tcop/tcopdebug.h
> include/${POSTGRESQL_DIR}/server/tcop/tcopprot.h
> include/${POSTGRESQL_DIR}/server/tcop/utility.h
> include/${POSTGRESQL_DIR}/server/tsearch/
> @@ -638,6 +640,7 @@ include/${POSTGRESQL_DIR}/server/utils/g
> include/${POSTGRESQL_DIR}/server/utils/guc_tables.h
> include/${POSTGRESQL_DIR}/server/utils/help_config.h
> include/${POSTGRESQL_DIR}/server/utils/hsearch.h
> +include/${POSTGRESQL_DIR}/server/utils/index_selfuncs.h
> include/${POSTGRESQL_DIR}/server/utils/inet.h
> include/${POSTGRESQL_DIR}/server/utils/int8.h
> include/${POSTGRESQL_DIR}/server/utils/inval.h
> @@ -699,6 +702,7 @@ lib/${POSTGRESQL_DIR}/ascii_and_mic.so
> lib/${POSTGRESQL_DIR}/auth_delay.so
> lib/${POSTGRESQL_DIR}/auto_explain.so
> lib/${POSTGRESQL_DIR}/autoinc.so
> +lib/${POSTGRESQL_DIR}/bloom.so
> lib/${POSTGRESQL_DIR}/btree_gin.so
> lib/${POSTGRESQL_DIR}/btree_gist.so
> lib/${POSTGRESQL_DIR}/chkpass.so
> @@ -724,22 +728,15 @@ lib/${POSTGRESQL_DIR}/isn.so
> lib/${POSTGRESQL_DIR}/latin2_and_win1250.so
> lib/${POSTGRESQL_DIR}/latin_and_mic.so
> lib/${POSTGRESQL_DIR}/libecpg.a
> -@comment lib/${POSTGRESQL_DIR}/libecpg.so
> -@comment lib/${POSTGRESQL_DIR}/libecpg.so.7
> @lib lib/${POSTGRESQL_DIR}/libecpg.so.${LIBecpg_VERSION}
> lib/${POSTGRESQL_DIR}/libecpg_compat.a
> -@comment lib/${POSTGRESQL_DIR}/libecpg_compat.so
> -@comment lib/${POSTGRESQL_DIR}/libecpg_compat.so.4
> @lib lib/${POSTGRESQL_DIR}/libecpg_compat.so.${LIBecpg_compat_VERSION}
> lib/${POSTGRESQL_DIR}/libpgcommon.a
> +lib/${POSTGRESQL_DIR}/libpgfeutils.a
> lib/${POSTGRESQL_DIR}/libpgport.a
> lib/${POSTGRESQL_DIR}/libpgtypes.a
> -@comment lib/${POSTGRESQL_DIR}/libpgtypes.so
> -@comment lib/${POSTGRESQL_DIR}/libpgtypes.so.4
> @lib lib/${POSTGRESQL_DIR}/libpgtypes.so.${LIBpgtypes_VERSION}
> lib/${POSTGRESQL_DIR}/libpq.a
> -@comment lib/${POSTGRESQL_DIR}/libpq.so
> -@comment lib/${POSTGRESQL_DIR}/libpq.so.6
> @lib lib/${POSTGRESQL_DIR}/libpq.so.${LIBpq_VERSION}
> lib/${POSTGRESQL_DIR}/libpqwalreceiver.so
> lib/${POSTGRESQL_DIR}/lo.so
> @@ -752,6 +749,7 @@ lib/${POSTGRESQL_DIR}/pg_freespacemap.so
> lib/${POSTGRESQL_DIR}/pg_prewarm.so
> lib/${POSTGRESQL_DIR}/pg_stat_statements.so
> lib/${POSTGRESQL_DIR}/pg_trgm.so
> +lib/${POSTGRESQL_DIR}/pg_visibility.so
> lib/${POSTGRESQL_DIR}/pgcrypto.so
> lib/${POSTGRESQL_DIR}/pgrowlocks.so
> lib/${POSTGRESQL_DIR}/pgstattuple.so
> @@ -815,25 +813,33 @@ share/${POSTGRESQL_DIR}/extension/adminp
> share/${POSTGRESQL_DIR}/extension/autoinc--1.0.sql
> share/${POSTGRESQL_DIR}/extension/autoinc--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/autoinc.control
> +share/${POSTGRESQL_DIR}/extension/bloom--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/bloom.control
> share/${POSTGRESQL_DIR}/extension/btree_gin--1.0.sql
> share/${POSTGRESQL_DIR}/extension/btree_gin--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/btree_gin.control
> share/${POSTGRESQL_DIR}/extension/btree_gist--1.0--1.1.sql
> -share/${POSTGRESQL_DIR}/extension/btree_gist--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/btree_gist--1.1--1.2.sql
> +share/${POSTGRESQL_DIR}/extension/btree_gist--1.2.sql
> share/${POSTGRESQL_DIR}/extension/btree_gist--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/btree_gist.control
> share/${POSTGRESQL_DIR}/extension/chkpass--1.0.sql
> share/${POSTGRESQL_DIR}/extension/chkpass--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/chkpass.control
> share/${POSTGRESQL_DIR}/extension/citext--1.0--1.1.sql
> -share/${POSTGRESQL_DIR}/extension/citext--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/citext--1.1--1.2.sql
> +share/${POSTGRESQL_DIR}/extension/citext--1.2--1.3.sql
> +share/${POSTGRESQL_DIR}/extension/citext--1.3.sql
> share/${POSTGRESQL_DIR}/extension/citext--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/citext.control
> -share/${POSTGRESQL_DIR}/extension/cube--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/cube--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/cube--1.1--1.2.sql
> +share/${POSTGRESQL_DIR}/extension/cube--1.2.sql
> share/${POSTGRESQL_DIR}/extension/cube--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/cube.control
> share/${POSTGRESQL_DIR}/extension/dblink--1.0--1.1.sql
> -share/${POSTGRESQL_DIR}/extension/dblink--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/dblink--1.1--1.2.sql
> +share/${POSTGRESQL_DIR}/extension/dblink--1.2.sql
> share/${POSTGRESQL_DIR}/extension/dblink--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/dblink.control
> share/${POSTGRESQL_DIR}/extension/dict_int--1.0.sql
> @@ -842,18 +848,21 @@ share/${POSTGRESQL_DIR}/extension/dict_i
> share/${POSTGRESQL_DIR}/extension/dict_xsyn--1.0.sql
> share/${POSTGRESQL_DIR}/extension/dict_xsyn--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/dict_xsyn.control
> -share/${POSTGRESQL_DIR}/extension/earthdistance--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/earthdistance--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/earthdistance--1.1.sql
> share/${POSTGRESQL_DIR}/extension/earthdistance--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/earthdistance.control
> share/${POSTGRESQL_DIR}/extension/file_fdw--1.0.sql
> share/${POSTGRESQL_DIR}/extension/file_fdw.control
> -share/${POSTGRESQL_DIR}/extension/fuzzystrmatch--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/fuzzystrmatch--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/fuzzystrmatch--1.1.sql
> share/${POSTGRESQL_DIR}/extension/fuzzystrmatch--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/fuzzystrmatch.control
> share/${POSTGRESQL_DIR}/extension/hstore--1.0--1.1.sql
> share/${POSTGRESQL_DIR}/extension/hstore--1.1--1.2.sql
> share/${POSTGRESQL_DIR}/extension/hstore--1.2--1.3.sql
> -share/${POSTGRESQL_DIR}/extension/hstore--1.3.sql
> +share/${POSTGRESQL_DIR}/extension/hstore--1.3--1.4.sql
> +share/${POSTGRESQL_DIR}/extension/hstore--1.4.sql
> share/${POSTGRESQL_DIR}/extension/hstore--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/hstore.control
> share/${POSTGRESQL_DIR}/extension/hstore_plperl--1.0.sql
> @@ -863,19 +872,25 @@ share/${POSTGRESQL_DIR}/extension/hstore
> share/${POSTGRESQL_DIR}/extension/insert_username--1.0.sql
> share/${POSTGRESQL_DIR}/extension/insert_username--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/insert_username.control
> -share/${POSTGRESQL_DIR}/extension/intagg--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/intagg--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/intagg--1.1.sql
> share/${POSTGRESQL_DIR}/extension/intagg--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/intagg.control
> -share/${POSTGRESQL_DIR}/extension/intarray--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/intarray--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/intarray--1.1--1.2.sql
> +share/${POSTGRESQL_DIR}/extension/intarray--1.2.sql
> share/${POSTGRESQL_DIR}/extension/intarray--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/intarray.control
> -share/${POSTGRESQL_DIR}/extension/isn--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/isn--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/isn--1.1.sql
> share/${POSTGRESQL_DIR}/extension/isn--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/isn.control
> -share/${POSTGRESQL_DIR}/extension/lo--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/lo--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/lo--1.1.sql
> share/${POSTGRESQL_DIR}/extension/lo--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/lo.control
> -share/${POSTGRESQL_DIR}/extension/ltree--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/ltree--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/ltree--1.1.sql
> share/${POSTGRESQL_DIR}/extension/ltree--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/ltree.control
> share/${POSTGRESQL_DIR}/extension/moddatetime--1.0.sql
> @@ -884,41 +899,55 @@ share/${POSTGRESQL_DIR}/extension/moddat
> share/${POSTGRESQL_DIR}/extension/pageinspect--1.0--1.1.sql
> share/${POSTGRESQL_DIR}/extension/pageinspect--1.1--1.2.sql
> share/${POSTGRESQL_DIR}/extension/pageinspect--1.2--1.3.sql
> -share/${POSTGRESQL_DIR}/extension/pageinspect--1.3.sql
> +share/${POSTGRESQL_DIR}/extension/pageinspect--1.3--1.4.sql
> +share/${POSTGRESQL_DIR}/extension/pageinspect--1.4--1.5.sql
> +share/${POSTGRESQL_DIR}/extension/pageinspect--1.5.sql
> share/${POSTGRESQL_DIR}/extension/pageinspect--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/pageinspect.control
> share/${POSTGRESQL_DIR}/extension/pg_buffercache--1.0--1.1.sql
> -share/${POSTGRESQL_DIR}/extension/pg_buffercache--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/pg_buffercache--1.1--1.2.sql
> +share/${POSTGRESQL_DIR}/extension/pg_buffercache--1.2.sql
> share/${POSTGRESQL_DIR}/extension/pg_buffercache--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/pg_buffercache.control
> -share/${POSTGRESQL_DIR}/extension/pg_freespacemap--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/pg_freespacemap--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/pg_freespacemap--1.1.sql
> share/${POSTGRESQL_DIR}/extension/pg_freespacemap--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/pg_freespacemap.control
> -share/${POSTGRESQL_DIR}/extension/pg_prewarm--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/pg_prewarm--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/pg_prewarm--1.1.sql
> share/${POSTGRESQL_DIR}/extension/pg_prewarm.control
> share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.0--1.1.sql
> share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.1--1.2.sql
> share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.2--1.3.sql
> -share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.3.sql
> +share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.3--1.4.sql
> +share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.4.sql
> share/${POSTGRESQL_DIR}/extension/pg_stat_statements--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/pg_stat_statements.control
> share/${POSTGRESQL_DIR}/extension/pg_trgm--1.0--1.1.sql
> -share/${POSTGRESQL_DIR}/extension/pg_trgm--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/pg_trgm--1.1--1.2.sql
> +share/${POSTGRESQL_DIR}/extension/pg_trgm--1.2--1.3.sql
> +share/${POSTGRESQL_DIR}/extension/pg_trgm--1.3.sql
> share/${POSTGRESQL_DIR}/extension/pg_trgm--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/pg_trgm.control
> +share/${POSTGRESQL_DIR}/extension/pg_visibility--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/pg_visibility--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/pg_visibility.control
> share/${POSTGRESQL_DIR}/extension/pgcrypto--1.0--1.1.sql
> share/${POSTGRESQL_DIR}/extension/pgcrypto--1.1--1.2.sql
> -share/${POSTGRESQL_DIR}/extension/pgcrypto--1.2.sql
> +share/${POSTGRESQL_DIR}/extension/pgcrypto--1.2--1.3.sql
> +share/${POSTGRESQL_DIR}/extension/pgcrypto--1.3.sql
> share/${POSTGRESQL_DIR}/extension/pgcrypto--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/pgcrypto.control
> share/${POSTGRESQL_DIR}/extension/pgrowlocks--1.0--1.1.sql
> -share/${POSTGRESQL_DIR}/extension/pgrowlocks--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/pgrowlocks--1.1--1.2.sql
> +share/${POSTGRESQL_DIR}/extension/pgrowlocks--1.2.sql
> share/${POSTGRESQL_DIR}/extension/pgrowlocks--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/pgrowlocks.control
> share/${POSTGRESQL_DIR}/extension/pgstattuple--1.0--1.1.sql
> share/${POSTGRESQL_DIR}/extension/pgstattuple--1.1--1.2.sql
> share/${POSTGRESQL_DIR}/extension/pgstattuple--1.2--1.3.sql
> -share/${POSTGRESQL_DIR}/extension/pgstattuple--1.3.sql
> +share/${POSTGRESQL_DIR}/extension/pgstattuple--1.3--1.4.sql
> +share/${POSTGRESQL_DIR}/extension/pgstattuple--1.4.sql
> share/${POSTGRESQL_DIR}/extension/pgstattuple--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/pgstattuple.control
> share/${POSTGRESQL_DIR}/extension/plperl--1.0.sql
> @@ -935,10 +964,13 @@ share/${POSTGRESQL_DIR}/extension/postgr
> share/${POSTGRESQL_DIR}/extension/refint--1.0.sql
> share/${POSTGRESQL_DIR}/extension/refint--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/refint.control
> -share/${POSTGRESQL_DIR}/extension/seg--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/seg--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/seg--1.1.sql
> share/${POSTGRESQL_DIR}/extension/seg--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/seg.control
> -share/${POSTGRESQL_DIR}/extension/sslinfo--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/sslinfo--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/sslinfo--1.1--1.2.sql
> +share/${POSTGRESQL_DIR}/extension/sslinfo--1.2.sql
> share/${POSTGRESQL_DIR}/extension/sslinfo--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/sslinfo.control
> share/${POSTGRESQL_DIR}/extension/tablefunc--1.0.sql
> @@ -956,13 +988,16 @@ share/${POSTGRESQL_DIR}/extension/tsm_sy
> share/${POSTGRESQL_DIR}/extension/tsm_system_rows.control
> share/${POSTGRESQL_DIR}/extension/tsm_system_time--1.0.sql
> share/${POSTGRESQL_DIR}/extension/tsm_system_time.control
> -share/${POSTGRESQL_DIR}/extension/unaccent--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/unaccent--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/unaccent--1.1.sql
> share/${POSTGRESQL_DIR}/extension/unaccent--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/unaccent.control
> -share/${POSTGRESQL_DIR}/extension/uuid-ossp--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/uuid-ossp--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/uuid-ossp--1.1.sql
> share/${POSTGRESQL_DIR}/extension/uuid-ossp--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/uuid-ossp.control
> -share/${POSTGRESQL_DIR}/extension/xml2--1.0.sql
> +share/${POSTGRESQL_DIR}/extension/xml2--1.0--1.1.sql
> +share/${POSTGRESQL_DIR}/extension/xml2--1.1.sql
> share/${POSTGRESQL_DIR}/extension/xml2--unpackaged--1.0.sql
> share/${POSTGRESQL_DIR}/extension/xml2.control
> share/${POSTGRESQL_DIR}/information_schema.sql
> @@ -1001,6 +1036,10 @@ share/${POSTGRESQL_DIR}/tsearch_data/fre
> share/${POSTGRESQL_DIR}/tsearch_data/german.stop
> share/${POSTGRESQL_DIR}/tsearch_data/hungarian.stop
> share/${POSTGRESQL_DIR}/tsearch_data/hunspell_sample.affix
> +share/${POSTGRESQL_DIR}/tsearch_data/hunspell_sample_long.affix
> +share/${POSTGRESQL_DIR}/tsearch_data/hunspell_sample_long.dict
> +share/${POSTGRESQL_DIR}/tsearch_data/hunspell_sample_num.affix
> +share/${POSTGRESQL_DIR}/tsearch_data/hunspell_sample_num.dict
> share/${POSTGRESQL_DIR}/tsearch_data/ispell_sample.affix
> share/${POSTGRESQL_DIR}/tsearch_data/ispell_sample.dict
> share/${POSTGRESQL_DIR}/tsearch_data/italian.stop
> Index: postgresql-pllua/Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql-pllua/Makefile,v
> retrieving revision 1.8
> diff -u -p -u -p -r1.8 Makefile
> --- postgresql-pllua/Makefile 18 Dec 2016 18:19:37 -0000 1.8
> +++ postgresql-pllua/Makefile 1 Nov 2017 14:08:09 -0000
> @@ -5,7 +5,7 @@ COMMENT = Lua procedural language suppo
> VERSION = 1.0
> DISTNAME = pllua-${VERSION}
> PKGNAME = postgresql-pllua-${VERSION}
> -REVISION = 2
> +REVISION = 3
>
> CATEGORIES = databases
>
> @@ -22,7 +22,7 @@ MASTER_SITES = http://pgfoundry.org/frs
>
> MODULES = lang/lua
> BUILD_DEPENDS = ${RUN_DEPENDS}
> -RUN_DEPENDS =
> postgresql-server->=9.6,<9.7:databases/postgresql,-server
> +RUN_DEPENDS =
> postgresql-server->=10,<11:databases/postgresql,-server
>
> USE_GMAKE = Yes
>
> Index: postgresql-plv8/Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql-plv8/Makefile,v
> retrieving revision 1.13
> diff -u -p -u -p -r1.13 Makefile
> --- postgresql-plv8/Makefile 26 Jul 2017 22:45:16 -0000 1.13
> +++ postgresql-plv8/Makefile 1 Nov 2017 14:08:34 -0000
> @@ -6,7 +6,7 @@ ONLY_FOR_ARCHS = amd64 i386
> COMMENT = PostgreSQL V8 javascript procedural language
>
> VERSION = 1.4.2
> -REVISION = 5
> +REVISION = 6
> DISTNAME = plv8-${VERSION}
> PKGNAME = postgresql-${DISTNAME}
>
> @@ -24,7 +24,7 @@ EXTRACT_SUFX = .zip
>
> BUILD_DEPENDS = ${RUN_DEPENDS}
> LIB_DEPENDS = lang/libv8
> -RUN_DEPENDS =
> postgresql-server->=9.6,<9.7:databases/postgresql,-server
> +RUN_DEPENDS =
> postgresql-server->=10,<11:databases/postgresql,-server
>
> MAKE_FLAGS = V8DIR=${LOCALBASE}/lib \
> CUSTOM_CC="${CXX}" \
> Index: citus/Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/citus/Makefile,v
> retrieving revision 1.3
> diff -u -p -u -p -r1.3 Makefile
> --- citus/Makefile 15 Aug 2017 02:32:50 -0000 1.3
> +++ citus/Makefile 1 Nov 2017 18:17:03 -0000
> @@ -3,7 +3,7 @@
> COMMENT = extension to horizontally scale PostgreSQL
> GH_ACCOUNT = citusdata
> GH_PROJECT = citus
> -GH_TAGNAME = v6.2.3
> +GH_TAGNAME = v7.0.3
>
> CATEGORIES = databases
> HOMEPAGE = https://www.citusdata.com/
> Index: citus/distinfo
> ===================================================================
> RCS file: /cvs/ports/databases/citus/distinfo,v
> retrieving revision 1.2
> diff -u -p -u -p -r1.2 distinfo
> --- citus/distinfo 15 Aug 2017 02:32:50 -0000 1.2
> +++ citus/distinfo 1 Nov 2017 18:17:18 -0000
> @@ -1,2 +1,2 @@
> -SHA256 (citus-6.2.3.tar.gz) = A6zjYuPyO08CwFy1ZyaK0T9k7BqN6W5ewOYHry471n4=
> -SIZE (citus-6.2.3.tar.gz) = 2282287
> +SHA256 (citus-7.0.3.tar.gz) = OGmJhsuAcwmHWxH1SOlrBqNTkMmj5gwjO1k1b6rNFmM=
> +SIZE (citus-7.0.3.tar.gz) = 2459522
> Index: citus/pkg/PLIST
> ===================================================================
> RCS file: /cvs/ports/databases/citus/pkg/PLIST,v
> retrieving revision 1.1.1.1
> diff -u -p -u -p -r1.1.1.1 PLIST
> --- citus/pkg/PLIST 7 Jul 2017 19:58:07 -0000 1.1.1.1
> +++ citus/pkg/PLIST 1 Nov 2017 18:18:09 -0000
> @@ -1,6 +1,7 @@
> @comment $OpenBSD: PLIST,v 1.1.1.1 2017/07/07 19:58:07 landry Exp $
> include/postgresql/server/citus_version.h
> include/postgresql/server/distributed/
> +include/postgresql/server/distributed/backend_data.h
> include/postgresql/server/distributed/citus_clauses.h
> include/postgresql/server/distributed/citus_nodefuncs.h
> include/postgresql/server/distributed/citus_nodes.h
> @@ -8,10 +9,15 @@ include/postgresql/server/distributed/ci
> include/postgresql/server/distributed/colocation_utils.h
> include/postgresql/server/distributed/connection_management.h
> include/postgresql/server/distributed/deparse_shard_query.h
> +include/postgresql/server/distributed/distributed_deadlock_detection.h
> include/postgresql/server/distributed/distribution_column.h
> include/postgresql/server/distributed/errormessage.h
> include/postgresql/server/distributed/hash_helpers.h
> +include/postgresql/server/distributed/insert_select_executor.h
> +include/postgresql/server/distributed/insert_select_planner.h
> include/postgresql/server/distributed/listutils.h
> +include/postgresql/server/distributed/lock_graph.h
> +include/postgresql/server/distributed/maintenanced.h
> include/postgresql/server/distributed/master_metadata_utility.h
> include/postgresql/server/distributed/master_protocol.h
> include/postgresql/server/distributed/metadata_cache.h
> @@ -24,8 +30,10 @@ include/postgresql/server/distributed/mu
> include/postgresql/server/distributed/multi_logical_optimizer.h
> include/postgresql/server/distributed/multi_logical_planner.h
> include/postgresql/server/distributed/multi_master_planner.h
> +include/postgresql/server/distributed/multi_partitioning_utils.h
> include/postgresql/server/distributed/multi_physical_planner.h
> include/postgresql/server/distributed/multi_planner.h
> +include/postgresql/server/distributed/multi_progress.h
> include/postgresql/server/distributed/multi_resowner.h
> include/postgresql/server/distributed/multi_router_executor.h
> include/postgresql/server/distributed/multi_router_planner.h
> @@ -36,8 +44,8 @@ include/postgresql/server/distributed/pg
> include/postgresql/server/distributed/pg_dist_local_group.h
> include/postgresql/server/distributed/pg_dist_node.h
> include/postgresql/server/distributed/pg_dist_partition.h
> +include/postgresql/server/distributed/pg_dist_placement.h
> include/postgresql/server/distributed/pg_dist_shard.h
> -include/postgresql/server/distributed/pg_dist_shard_placement.h
> include/postgresql/server/distributed/pg_dist_transaction.h
> include/postgresql/server/distributed/placement_connection.h
> include/postgresql/server/distributed/reference_table_utils.h
> @@ -48,9 +56,10 @@ include/postgresql/server/distributed/re
> include/postgresql/server/distributed/resource_lock.h
> include/postgresql/server/distributed/shard_pruning.h
> include/postgresql/server/distributed/shardinterval_utils.h
> +include/postgresql/server/distributed/shared_library_init.h
> include/postgresql/server/distributed/task_tracker.h
> include/postgresql/server/distributed/task_tracker_protocol.h
> -include/postgresql/server/distributed/test_helper_functions.h
> +include/postgresql/server/distributed/transaction_identifier.h
> include/postgresql/server/distributed/transaction_management.h
> include/postgresql/server/distributed/transaction_recovery.h
> include/postgresql/server/distributed/transmit.h
> @@ -164,5 +173,35 @@ share/postgresql/extension/citus--6.2-2-
> share/postgresql/extension/citus--6.2-2.sql
> share/postgresql/extension/citus--6.2-3--6.2-4.sql
> share/postgresql/extension/citus--6.2-3.sql
> +share/postgresql/extension/citus--6.2-4--7.0-1.sql
> share/postgresql/extension/citus--6.2-4.sql
> +share/postgresql/extension/citus--7.0-1--7.0-2.sql
> +share/postgresql/extension/citus--7.0-1.sql
> +share/postgresql/extension/citus--7.0-10--7.0-11.sql
> +share/postgresql/extension/citus--7.0-10.sql
> +share/postgresql/extension/citus--7.0-11--7.0-12.sql
> +share/postgresql/extension/citus--7.0-11.sql
> +share/postgresql/extension/citus--7.0-12--7.0-13.sql
> +share/postgresql/extension/citus--7.0-12.sql
> +share/postgresql/extension/citus--7.0-13--7.0-14.sql
> +share/postgresql/extension/citus--7.0-13.sql
> +share/postgresql/extension/citus--7.0-14--7.0-15.sql
> +share/postgresql/extension/citus--7.0-14.sql
> +share/postgresql/extension/citus--7.0-15.sql
> +share/postgresql/extension/citus--7.0-2--7.0-3.sql
> +share/postgresql/extension/citus--7.0-2.sql
> +share/postgresql/extension/citus--7.0-3--7.0-4.sql
> +share/postgresql/extension/citus--7.0-3.sql
> +share/postgresql/extension/citus--7.0-4--7.0-5.sql
> +share/postgresql/extension/citus--7.0-4.sql
> +share/postgresql/extension/citus--7.0-5--7.0-6.sql
> +share/postgresql/extension/citus--7.0-5.sql
> +share/postgresql/extension/citus--7.0-6--7.0-7.sql
> +share/postgresql/extension/citus--7.0-6.sql
> +share/postgresql/extension/citus--7.0-7--7.0-8.sql
> +share/postgresql/extension/citus--7.0-7.sql
> +share/postgresql/extension/citus--7.0-8--7.0-9.sql
> +share/postgresql/extension/citus--7.0-8.sql
> +share/postgresql/extension/citus--7.0-9--7.0-10.sql
> +share/postgresql/extension/citus--7.0-9.sql
> share/postgresql/extension/citus.control
