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.

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

Reply via email to