On Thu, Feb 04, 2021 at 01:32:31PM +0000, Stuart Henderson wrote:
> > > @conflict postgresql-*
> > > -@ask-update postgresql-server-<${V_MAJOR} Make sure your existing
> > > database is backed up
> > > +@ask-update postgresql-server-<${PREV_MAJOR} Old version too old for
> > > pg_upgrade, make sure your database is backed up
> >
> >
> > yes ok pea@
>
> Here is an updated version of the pgsql 13.1 update, based on
> https://marc.info/?l=openbsd-ports&m=160592088315669&w=2 with the
> above and the following other changes (some of which were mentioned
> in the thread but I didn't find another full diff):
>
> - don't bump libraries unnecessarily; only pq has a minor bump
> - https homepage
> - sync WANTLIB/LIB_DEPENDS
> - knock out backtrace_symbols/libexecinfo (found by Mark Patruck ;)
> - line up some tabs
>
> this one is OK with me
ok pea@ too
>
>
> Index: Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/Makefile,v
> retrieving revision 1.266
> diff -u -p -r1.266 Makefile
> --- Makefile 14 Nov 2020 13:03:49 -0000 1.266
> +++ Makefile 4 Feb 2021 13:28:44 -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= 12.5
> -PREV_MAJOR= 11
> +VERSION= 13.1
> +PREV_MAJOR= 12
> DISTNAME= postgresql-${VERSION}
> PKGNAME-main= postgresql-client-${VERSION}
> PKGNAME-server= postgresql-server-${VERSION}
> @@ -16,16 +16,16 @@ PKGNAME-docs= postgresql-docs-${VERSION}
> PKGNAME-contrib=postgresql-contrib-${VERSION}
> PKGNAME-plpython=postgresql-plpython-${VERSION}
> PKGNAME-pg_upgrade=postgresql-pg_upgrade-${VERSION}
> -REVISION-server= 0
>
> +DPB_PROPERTIES= parallel
>
> CATEGORIES= databases
> SHARED_LIBS= ecpg 7.10 \
> ecpg_compat 4.10 \
> pgtypes 4.9 \
> - pq 6.11
> + pq 6.12
>
> -HOMEPAGE= http://www.postgresql.org/
> +HOMEPAGE= https://www.postgresql.org/
>
> MAINTAINER= Pierre-Emmanuel Andre <[email protected]>
>
> @@ -51,10 +51,12 @@ MODULES= lang/python
> MODPY_RUNDEP= No
>
> CONFIGURE_ENV= ac_cv_path_PYTHON=${MODPY_BIN} \
> + ac_cv_search_backtrace_symbols=no \
> CPPFLAGS="-I${LOCALBASE}/include" \
> LDFLAGS="-L${LOCALBASE}/lib"
>
> -CONFIGURE_ARGS= --disable-rpath --with-openssl=/usr \
> +CONFIGURE_ARGS= --disable-rpath \
> + --with-openssl=/usr \
> --with-bsd-auth \
> --with-perl \
> --with-python \
> @@ -76,7 +78,7 @@ CONFIGURE_ARGS= --disable-rpath --with-o
> # (apparently) a serious performance hit doing this.
>
> .if ${MACHINE_ARCH} == "alpha" || ${MACHINE_ARCH} == "hppa"
> -CONFIGURE_ARGS+=--disable-spinlocks
> +CONFIGURE_ARGS+= --disable-spinlocks
> .endif
>
> # To avoid problems with missed floating point overflow checks.
> @@ -96,30 +98,27 @@ MODGNU_CONFIG_GUESS_DIRS= ${WRKSRC}/conf
> ALL_TARGET= world
> INSTALL_TARGET= install-world
>
> -LIB_DEPENDS-main= archivers/xz \
> - converters/libiconv \
> - textproc/libxml
> -WANTLIB-main = ${WANTLIB} iconv lzma xml2
> +LIB_DEPENDS-main= textproc/libxml
> +WANTLIB-main= ${WANTLIB} xml2
>
> -
> -LIB_DEPENDS-server= databases/postgresql=${VERSION} \
> - ${LIB_DEPENDS-main}
> -WANTLIB-server= ${WANTLIB-main} perl pq
> -
> -RUN_DEPENDS-contrib= databases/postgresql,-server=${VERSION}
> -LIB_DEPENDS-contrib= databases/postgresql=${VERSION} \
> - ${LIB_DEPENDS-main}
> +LIB_DEPENDS-server= databases/postgresql=${VERSION} \
> + ${LIB_DEPENDS-main}
> +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} perl pq
>
> RUN_DEPENDS-pg_upgrade= databases/postgresql,-server=${VERSION} \
> databases/postgresql-previous>=${PREV_MAJOR}
> LIB_DEPENDS-pg_upgrade= databases/postgresql=${VERSION} \
> - ${LIB_DEPENDS-main}
> + ${LIB_DEPENDS-main}
>
> -WANTLIB-pg_upgrade = ${WANTLIB-main} pq
> +WANTLIB-pg_upgrade= ${WANTLIB-main} pq
>
> LIB_DEPENDS-plpython= ${MODPY_LIB_DEPENDS}
> -WANTLIB-plpython = c m pthread util \
> +WANTLIB-plpython= c intl m pthread util \
> ${MODPY_WANTLIB}
> RUN_DEPENDS-plpython= databases/postgresql,-server=${VERSION}
>
> Index: distinfo
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/distinfo,v
> retrieving revision 1.86
> diff -u -p -r1.86 distinfo
> --- distinfo 13 Nov 2020 19:00:10 -0000 1.86
> +++ distinfo 4 Feb 2021 13:28:44 -0000
> @@ -1,2 +1,2 @@
> -SHA256 (postgresql-12.5.tar.gz) =
> 2IPpfP0ss7OrqUkVQdtrMM/jO7akAxzbCOxQFNBNbpY=
> -SIZE (postgresql-12.5.tar.gz) = 27137095
> +SHA256 (postgresql-13.1.tar.gz) =
> xHSnD9rLSeWEHpibR/EWCAwsIf90MxL3P00soy/x190=
> +SIZE (postgresql-13.1.tar.gz) = 27483946
> Index: patches/patch-src_Makefile_shlib
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/patches/patch-src_Makefile_shlib,v
> retrieving revision 1.12
> diff -u -p -r1.12 patch-src_Makefile_shlib
> --- patches/patch-src_Makefile_shlib 3 Dec 2018 16:22:08 -0000 1.12
> +++ patches/patch-src_Makefile_shlib 4 Feb 2021 13:28:44 -0000
> @@ -3,7 +3,7 @@ $OpenBSD: patch-src_Makefile_shlib,v 1.1
> Index: src/Makefile.shlib
> --- src/Makefile.shlib.orig
> +++ src/Makefile.shlib
> -@@ -80,7 +80,7 @@ shlib_major =
> lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION
> +@@ -79,7 +79,7 @@ shlib_major =
> lib$(NAME)$(DLSUFFIX).$(SO_MAJOR_VERSION
> shlib_bare = lib$(NAME)$(DLSUFFIX)
> # Testing the soname variable is a reliable way to determine whether a
> # linkable library is being built.
> Index: patches/patch-src_bin_scripts_vacuumdb_c
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql/patches/patch-src_bin_scripts_vacuumdb_c,v
> retrieving revision 1.3
> diff -u -p -r1.3 patch-src_bin_scripts_vacuumdb_c
> --- patches/patch-src_bin_scripts_vacuumdb_c 6 Feb 2020 00:36:12 -0000
> 1.3
> +++ patches/patch-src_bin_scripts_vacuumdb_c 4 Feb 2021 13:28:44 -0000
> @@ -2,12 +2,12 @@ $OpenBSD: patch-src_bin_scripts_vacuumdb
> Index: src/bin/scripts/vacuumdb.c
> --- src/bin/scripts/vacuumdb.c.orig
> +++ src/bin/scripts/vacuumdb.c
> -@@ -14,6 +14,8 @@
> - #define FD_SETSIZE 1024 /* must set before winsock2.h
> is included */
> - #endif
> +@@ -10,6 +10,8 @@
> + *-------------------------------------------------------------------------
> + */
>
> +#include <sys/select.h> /* FD_SETSIZE */
> +
> #include "postgres_fe.h"
>
> - #ifdef HAVE_SYS_SELECT_H
> + #include "catalog/pg_class_d.h"
> Index: 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.6
> diff -u -p -r1.6 patch-src_include_storage_s_lock_h
> --- patches/patch-src_include_storage_s_lock_h 6 Feb 2020 00:36:12
> -0000 1.6
> +++ patches/patch-src_include_storage_s_lock_h 4 Feb 2021 13:28:44
> -0000
> @@ -2,7 +2,7 @@ $OpenBSD: patch-src_include_storage_s_lo
> Index: src/include/storage/s_lock.h
> --- src/include/storage/s_lock.h.orig
> +++ src/include/storage/s_lock.h
> -@@ -734,6 +734,29 @@ typedef unsigned char slock_t;
> +@@ -739,6 +739,29 @@ typedef unsigned char slock_t;
> do { __asm__ __volatile__("" : : : "memory"); *(lock) = 0; } while (0)
> #endif
>
> Index: patches/patch-src_interfaces_libpq_Makefile
> ===================================================================
> RCS file:
> /cvs/ports/databases/postgresql/patches/patch-src_interfaces_libpq_Makefile,v
> retrieving revision 1.14
> diff -u -p -r1.14 patch-src_interfaces_libpq_Makefile
> --- patches/patch-src_interfaces_libpq_Makefile 30 Nov 2017 16:13:12
> -0000 1.14
> +++ patches/patch-src_interfaces_libpq_Makefile 4 Feb 2021 13:28:44
> -0000
> @@ -2,7 +2,7 @@ $OpenBSD: patch-src_interfaces_libpq_Mak
> Index: src/interfaces/libpq/Makefile
> --- src/interfaces/libpq/Makefile.orig
> +++ src/interfaces/libpq/Makefile
> -@@ -16,8 +16,8 @@ include $(top_builddir)/src/Makefile.global
> +@@ -18,8 +18,8 @@ PGFILEDESC = "PostgreSQL Access Library"
>
> # shared library parameters
> NAME= pq
> Index: pkg/PLIST-contrib
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v
> retrieving revision 1.21
> diff -u -p -r1.21 PLIST-contrib
> --- pkg/PLIST-contrib 6 Feb 2020 00:36:12 -0000 1.21
> +++ pkg/PLIST-contrib 4 Feb 2021 13:28:44 -0000
> @@ -16,6 +16,7 @@
> @so lib/postgresql/auto_explain.so
> @so lib/postgresql/autoinc.so
> @so lib/postgresql/bloom.so
> +@so lib/postgresql/bool_plperl.so
> @so lib/postgresql/btree_gin.so
> @so lib/postgresql/btree_gist.so
> @so lib/postgresql/citext.so
> @@ -63,20 +64,24 @@
> share/postgresql/extension/adminpack--1.0--1.1.sql
> share/postgresql/extension/adminpack--1.0.sql
> share/postgresql/extension/adminpack--1.1--2.0.sql
> +share/postgresql/extension/adminpack--2.0--2.1.sql
> share/postgresql/extension/adminpack.control
> share/postgresql/extension/amcheck--1.0--1.1.sql
> share/postgresql/extension/amcheck--1.0.sql
> +share/postgresql/extension/amcheck--1.1--1.2.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/bool_plperl--1.0.sql
> +share/postgresql/extension/bool_plperl.control
> +share/postgresql/extension/bool_plperlu--1.0.sql
> +share/postgresql/extension/bool_plperlu.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--1.2--1.3.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
> @@ -84,7 +89,6 @@ share/postgresql/extension/btree_gist--1
> 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/citext--1.0--1.1.sql
> share/postgresql/extension/citext--1.1--1.2.sql
> @@ -92,35 +96,29 @@ share/postgresql/extension/citext--1.2--
> share/postgresql/extension/citext--1.3--1.4.sql
> share/postgresql/extension/citext--1.4--1.5.sql
> share/postgresql/extension/citext--1.4.sql
> -share/postgresql/extension/citext--unpackaged--1.0.sql
> +share/postgresql/extension/citext--1.5--1.6.sql
> share/postgresql/extension/citext.control
> share/postgresql/extension/cube--1.0--1.1.sql
> share/postgresql/extension/cube--1.1--1.2.sql
> share/postgresql/extension/cube--1.2--1.3.sql
> share/postgresql/extension/cube--1.2.sql
> share/postgresql/extension/cube--1.3--1.4.sql
> -share/postgresql/extension/cube--unpackaged--1.0.sql
> share/postgresql/extension/cube.control
> share/postgresql/extension/dblink--1.0--1.1.sql
> share/postgresql/extension/dblink--1.1--1.2.sql
> share/postgresql/extension/dblink--1.2.sql
> -share/postgresql/extension/dblink--unpackaged--1.0.sql
> share/postgresql/extension/dblink.control
> share/postgresql/extension/dict_int--1.0.sql
> -share/postgresql/extension/dict_int--unpackaged--1.0.sql
> share/postgresql/extension/dict_int.control
> share/postgresql/extension/dict_xsyn--1.0.sql
> -share/postgresql/extension/dict_xsyn--unpackaged--1.0.sql
> share/postgresql/extension/dict_xsyn.control
> share/postgresql/extension/earthdistance--1.0--1.1.sql
> share/postgresql/extension/earthdistance--1.1.sql
> -share/postgresql/extension/earthdistance--unpackaged--1.0.sql
> share/postgresql/extension/earthdistance.control
> share/postgresql/extension/file_fdw--1.0.sql
> share/postgresql/extension/file_fdw.control
> share/postgresql/extension/fuzzystrmatch--1.0--1.1.sql
> share/postgresql/extension/fuzzystrmatch--1.1.sql
> -share/postgresql/extension/fuzzystrmatch--unpackaged--1.0.sql
> share/postgresql/extension/fuzzystrmatch.control
> share/postgresql/extension/hstore--1.0--1.1.sql
> share/postgresql/extension/hstore--1.1--1.2.sql
> @@ -128,28 +126,26 @@ share/postgresql/extension/hstore--1.2--
> share/postgresql/extension/hstore--1.3--1.4.sql
> share/postgresql/extension/hstore--1.4--1.5.sql
> share/postgresql/extension/hstore--1.4.sql
> -share/postgresql/extension/hstore--unpackaged--1.0.sql
> +share/postgresql/extension/hstore--1.5--1.6.sql
> +share/postgresql/extension/hstore--1.6--1.7.sql
> share/postgresql/extension/hstore.control
> share/postgresql/extension/hstore_plperl--1.0.sql
> share/postgresql/extension/hstore_plperl.control
> share/postgresql/extension/hstore_plperlu--1.0.sql
> share/postgresql/extension/hstore_plperlu.control
> share/postgresql/extension/insert_username--1.0.sql
> -share/postgresql/extension/insert_username--unpackaged--1.0.sql
> share/postgresql/extension/insert_username.control
> share/postgresql/extension/intagg--1.0--1.1.sql
> share/postgresql/extension/intagg--1.1.sql
> -share/postgresql/extension/intagg--unpackaged--1.0.sql
> share/postgresql/extension/intagg.control
> share/postgresql/extension/intarray--1.0--1.1.sql
> share/postgresql/extension/intarray--1.1--1.2.sql
> +share/postgresql/extension/intarray--1.2--1.3.sql
> share/postgresql/extension/intarray--1.2.sql
> -share/postgresql/extension/intarray--unpackaged--1.0.sql
> share/postgresql/extension/intarray.control
> share/postgresql/extension/isn--1.0--1.1.sql
> share/postgresql/extension/isn--1.1--1.2.sql
> share/postgresql/extension/isn--1.1.sql
> -share/postgresql/extension/isn--unpackaged--1.0.sql
> share/postgresql/extension/isn.control
> share/postgresql/extension/jsonb_plperl--1.0.sql
> share/postgresql/extension/jsonb_plperl.control
> @@ -157,14 +153,12 @@ share/postgresql/extension/jsonb_plperlu
> share/postgresql/extension/jsonb_plperlu.control
> share/postgresql/extension/lo--1.0--1.1.sql
> share/postgresql/extension/lo--1.1.sql
> -share/postgresql/extension/lo--unpackaged--1.0.sql
> share/postgresql/extension/lo.control
> share/postgresql/extension/ltree--1.0--1.1.sql
> +share/postgresql/extension/ltree--1.1--1.2.sql
> share/postgresql/extension/ltree--1.1.sql
> -share/postgresql/extension/ltree--unpackaged--1.0.sql
> share/postgresql/extension/ltree.control
> share/postgresql/extension/moddatetime--1.0.sql
> -share/postgresql/extension/moddatetime--unpackaged--1.0.sql
> share/postgresql/extension/moddatetime.control
> share/postgresql/extension/pageinspect--1.0--1.1.sql
> share/postgresql/extension/pageinspect--1.1--1.2.sql
> @@ -174,18 +168,16 @@ share/postgresql/extension/pageinspect--
> share/postgresql/extension/pageinspect--1.5--1.6.sql
> share/postgresql/extension/pageinspect--1.5.sql
> share/postgresql/extension/pageinspect--1.6--1.7.sql
> -share/postgresql/extension/pageinspect--unpackaged--1.0.sql
> +share/postgresql/extension/pageinspect--1.7--1.8.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
> share/postgresql/extension/pg_prewarm--1.0--1.1.sql
> share/postgresql/extension/pg_prewarm--1.1--1.2.sql
> @@ -198,14 +190,15 @@ share/postgresql/extension/pg_stat_state
> 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--1.5--1.6.sql
> -share/postgresql/extension/pg_stat_statements--unpackaged--1.0.sql
> +share/postgresql/extension/pg_stat_statements--1.6--1.7.sql
> +share/postgresql/extension/pg_stat_statements--1.7--1.8.sql
> share/postgresql/extension/pg_stat_statements.control
> share/postgresql/extension/pg_trgm--1.0--1.1.sql
> share/postgresql/extension/pg_trgm--1.1--1.2.sql
> share/postgresql/extension/pg_trgm--1.2--1.3.sql
> share/postgresql/extension/pg_trgm--1.3--1.4.sql
> share/postgresql/extension/pg_trgm--1.3.sql
> -share/postgresql/extension/pg_trgm--unpackaged--1.0.sql
> +share/postgresql/extension/pg_trgm--1.4--1.5.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
> @@ -215,12 +208,10 @@ share/postgresql/extension/pgcrypto--1.0
> share/postgresql/extension/pgcrypto--1.1--1.2.sql
> share/postgresql/extension/pgcrypto--1.2--1.3.sql
> share/postgresql/extension/pgcrypto--1.3.sql
> -share/postgresql/extension/pgcrypto--unpackaged--1.0.sql
> share/postgresql/extension/pgcrypto.control
> share/postgresql/extension/pgrowlocks--1.0--1.1.sql
> share/postgresql/extension/pgrowlocks--1.1--1.2.sql
> share/postgresql/extension/pgrowlocks--1.2.sql
> -share/postgresql/extension/pgrowlocks--unpackaged--1.0.sql
> share/postgresql/extension/pgrowlocks.control
> share/postgresql/extension/pgstattuple--1.0--1.1.sql
> share/postgresql/extension/pgstattuple--1.1--1.2.sql
> @@ -228,26 +219,21 @@ share/postgresql/extension/pgstattuple--
> 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
> share/postgresql/extension/postgres_fdw--1.0.sql
> share/postgresql/extension/postgres_fdw.control
> share/postgresql/extension/refint--1.0.sql
> -share/postgresql/extension/refint--unpackaged--1.0.sql
> share/postgresql/extension/refint.control
> share/postgresql/extension/seg--1.0--1.1.sql
> share/postgresql/extension/seg--1.1--1.2.sql
> share/postgresql/extension/seg--1.1.sql
> share/postgresql/extension/seg--1.2--1.3.sql
> -share/postgresql/extension/seg--unpackaged--1.0.sql
> share/postgresql/extension/seg.control
> share/postgresql/extension/sslinfo--1.0--1.1.sql
> share/postgresql/extension/sslinfo--1.1--1.2.sql
> share/postgresql/extension/sslinfo--1.2.sql
> -share/postgresql/extension/sslinfo--unpackaged--1.0.sql
> share/postgresql/extension/sslinfo.control
> share/postgresql/extension/tablefunc--1.0.sql
> -share/postgresql/extension/tablefunc--unpackaged--1.0.sql
> share/postgresql/extension/tablefunc.control
> share/postgresql/extension/tcn--1.0.sql
> share/postgresql/extension/tcn.control
> @@ -257,13 +243,10 @@ share/postgresql/extension/tsm_system_ti
> share/postgresql/extension/tsm_system_time.control
> share/postgresql/extension/unaccent--1.0--1.1.sql
> share/postgresql/extension/unaccent--1.1.sql
> -share/postgresql/extension/unaccent--unpackaged--1.0.sql
> share/postgresql/extension/unaccent.control
> share/postgresql/extension/uuid-ossp--1.0--1.1.sql
> share/postgresql/extension/uuid-ossp--1.1.sql
> -share/postgresql/extension/uuid-ossp--unpackaged--1.0.sql
> share/postgresql/extension/uuid-ossp.control
> share/postgresql/extension/xml2--1.0--1.1.sql
> share/postgresql/extension/xml2--1.1.sql
> -share/postgresql/extension/xml2--unpackaged--1.0.sql
> share/postgresql/extension/xml2.control
> Index: pkg/PLIST-docs
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
> retrieving revision 1.98
> diff -u -p -r1.98 PLIST-docs
> --- pkg/PLIST-docs 13 Nov 2020 19:00:10 -0000 1.98
> +++ pkg/PLIST-docs 4 Feb 2021 13:28:44 -0000
> @@ -35,6 +35,7 @@ share/doc/postgresql/html/app-pgrecvlogi
> 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-pgverifybackup.html
> share/doc/postgresql/html/app-postgres.html
> share/doc/postgresql/html/app-postmaster.html
> share/doc/postgresql/html/app-psql.html
> @@ -59,6 +60,10 @@ share/doc/postgresql/html/auth-username-
> share/doc/postgresql/html/auto-explain.html
> share/doc/postgresql/html/backup-dump.html
> share/doc/postgresql/html/backup-file.html
> +share/doc/postgresql/html/backup-manifest-files.html
> +share/doc/postgresql/html/backup-manifest-format.html
> +share/doc/postgresql/html/backup-manifest-toplevel.html
> +share/doc/postgresql/html/backup-manifest-wal-ranges.html
> share/doc/postgresql/html/backup.html
> share/doc/postgresql/html/bgworker.html
> share/doc/postgresql/html/biblio.html
> @@ -116,7 +121,6 @@ share/doc/postgresql/html/catalog-pg-opc
> 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
> @@ -152,6 +156,9 @@ share/doc/postgresql/html/client-authent
> share/doc/postgresql/html/client-authentication.html
> share/doc/postgresql/html/client-interfaces.html
> share/doc/postgresql/html/collation.html
> +share/doc/postgresql/html/color-when.html
> +share/doc/postgresql/html/color-which.html
> +share/doc/postgresql/html/color.html
> share/doc/postgresql/html/config-setting.html
> share/doc/postgresql/html/connect-estab.html
> share/doc/postgresql/html/continuous-archiving.html
> @@ -341,11 +348,13 @@ share/doc/postgresql/html/functions-stri
> share/doc/postgresql/html/functions-subquery.html
> share/doc/postgresql/html/functions-textsearch.html
> share/doc/postgresql/html/functions-trigger.html
> +share/doc/postgresql/html/functions-uuid.html
> share/doc/postgresql/html/functions-window.html
> share/doc/postgresql/html/functions-xml.html
> share/doc/postgresql/html/functions.html
> share/doc/postgresql/html/fuzzystrmatch.html
> share/doc/postgresql/html/generic-wal.html
> +share/doc/postgresql/html/genetic-algorithm.svg
> share/doc/postgresql/html/geqo-biblio.html
> share/doc/postgresql/html/geqo-intro.html
> share/doc/postgresql/html/geqo-intro2.html
> @@ -367,6 +376,7 @@ share/doc/postgresql/html/gist-implement
> share/doc/postgresql/html/gist-intro.html
> share/doc/postgresql/html/gist.html
> share/doc/postgresql/html/git.html
> +share/doc/postgresql/html/glossary.html
> share/doc/postgresql/html/gssapi-auth.html
> share/doc/postgresql/html/gssapi-enc.html
> share/doc/postgresql/html/high-availability.html
> @@ -441,10 +451,7 @@ share/doc/postgresql/html/infoschema-sch
> share/doc/postgresql/html/infoschema-sequences.html
> share/doc/postgresql/html/infoschema-sql-features.html
> share/doc/postgresql/html/infoschema-sql-implementation-info.html
> -share/doc/postgresql/html/infoschema-sql-languages.html
> -share/doc/postgresql/html/infoschema-sql-packages.html
> share/doc/postgresql/html/infoschema-sql-parts.html
> -share/doc/postgresql/html/infoschema-sql-sizing-profiles.html
> share/doc/postgresql/html/infoschema-sql-sizing.html
> share/doc/postgresql/html/infoschema-table-constraints.html
> share/doc/postgresql/html/infoschema-table-privileges.html
> @@ -675,12 +682,8 @@ share/doc/postgresql/html/regress-run.ht
> share/doc/postgresql/html/regress-tap.html
> share/doc/postgresql/html/regress-variant.html
> share/doc/postgresql/html/regress.html
> -share/doc/postgresql/html/release-12-1.html
> -share/doc/postgresql/html/release-12-2.html
> -share/doc/postgresql/html/release-12-3.html
> -share/doc/postgresql/html/release-12-4.html
> -share/doc/postgresql/html/release-12-5.html
> -share/doc/postgresql/html/release-12.html
> +share/doc/postgresql/html/release-13.html
> +share/doc/postgresql/html/release-13-1.html
> share/doc/postgresql/html/release-prior.html
> share/doc/postgresql/html/release.html
> share/doc/postgresql/html/replication-origins.html
> @@ -1081,6 +1084,7 @@ share/doc/postgresql/html/view-pg-seclab
> 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-shmem-allocations.html
> share/doc/postgresql/html/view-pg-stats-ext.html
> share/doc/postgresql/html/view-pg-stats.html
> share/doc/postgresql/html/view-pg-tables.html
> Index: pkg/PLIST-main
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-main,v
> retrieving revision 1.31
> diff -u -p -r1.31 PLIST-main
> --- pkg/PLIST-main 6 Feb 2020 00:36:12 -0000 1.31
> +++ pkg/PLIST-main 4 Feb 2021 13:28:44 -0000
> @@ -367,7 +367,6 @@ lib/postgresql/pgxs/src/test/regress/
> share/postgresql/
> share/postgresql/errcodes.txt
> share/postgresql/information_schema.sql
> -share/postgresql/postgres.description
> share/postgresql/psqlrc.sample
> share/postgresql/snowball_create.sql
> share/postgresql/sql_features.txt
> Index: pkg/PLIST-plpython
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-plpython,v
> retrieving revision 1.9
> diff -u -p -r1.9 PLIST-plpython
> --- pkg/PLIST-plpython 6 Feb 2020 00:36:12 -0000 1.9
> +++ pkg/PLIST-plpython 4 Feb 2021 13:28:44 -0000
> @@ -24,8 +24,6 @@ share/postgresql/extension/ltree_plpytho
> 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
> share/postgresql/extension/plpythonu--1.0.sql
> -share/postgresql/extension/plpythonu--unpackaged--1.0.sql
> share/postgresql/extension/plpythonu.control
> Index: pkg/PLIST-server
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v
> retrieving revision 1.40
> diff -u -p -r1.40 PLIST-server
> --- pkg/PLIST-server 24 Sep 2020 13:11:46 -0000 1.40
> +++ pkg/PLIST-server 4 Feb 2021 13:28:44 -0000
> @@ -4,7 +4,7 @@
> @conflict postgresql-clients-*
> @conflict postgresql-server-*
> @conflict postgresql-*
> -@ask-update postgresql-server-<${V_MAJOR} Make sure your existing database
> is backed up
> +@ask-update postgresql-server-<${PREV_MAJOR} Old version too old for
> pg_upgrade, make sure your database is backed up
> @newgroup _postgresql:503
> @newuser _postgresql:503:_postgresql:daemon:PostgreSQL
> Manager:/var/postgresql:/bin/sh
> @bin bin/initdb
> @@ -17,6 +17,7 @@
> @bin bin/pg_recvlogical
> @bin bin/pg_resetwal
> @bin bin/pg_rewind
> +@bin bin/pg_verifybackup
> @bin bin/pg_waldump
> @bin bin/postgres
> bin/postmaster
> @@ -24,6 +25,7 @@ include/postgresql/server/
> include/postgresql/server/access/
> include/postgresql/server/access/amapi.h
> include/postgresql/server/access/amvalidate.h
> +include/postgresql/server/access/attmap.h
> include/postgresql/server/access/attnum.h
> include/postgresql/server/access/brin.h
> include/postgresql/server/access/brin_internal.h
> @@ -35,6 +37,7 @@ include/postgresql/server/access/brin_xl
> include/postgresql/server/access/bufmask.h
> include/postgresql/server/access/clog.h
> include/postgresql/server/access/commit_ts.h
> +include/postgresql/server/access/detoast.h
> include/postgresql/server/access/genam.h
> include/postgresql/server/access/generic_xlog.h
> include/postgresql/server/access/gin.h
> @@ -49,6 +52,7 @@ 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/heaptoast.h
> include/postgresql/server/access/hio.h
> include/postgresql/server/access/htup.h
> include/postgresql/server/access/htup_details.h
> @@ -78,13 +82,14 @@ include/postgresql/server/access/sysattr
> include/postgresql/server/access/table.h
> include/postgresql/server/access/tableam.h
> include/postgresql/server/access/timeline.h
> +include/postgresql/server/access/toast_helper.h
> +include/postgresql/server/access/toast_internals.h
> include/postgresql/server/access/transam.h
> include/postgresql/server/access/tsmapi.h
> include/postgresql/server/access/tupconvert.h
> include/postgresql/server/access/tupdesc.h
> include/postgresql/server/access/tupdesc_details.h
> include/postgresql/server/access/tupmacs.h
> -include/postgresql/server/access/tuptoaster.h
> include/postgresql/server/access/twophase.h
> include/postgresql/server/access/twophase_rmgr.h
> include/postgresql/server/access/valid.h
> @@ -92,6 +97,7 @@ include/postgresql/server/access/visibil
> include/postgresql/server/access/xact.h
> include/postgresql/server/access/xlog.h
> include/postgresql/server/access/xlog_internal.h
> +include/postgresql/server/access/xlogarchive.h
> include/postgresql/server/access/xlogdefs.h
> include/postgresql/server/access/xloginsert.h
> include/postgresql/server/access/xlogreader.h
> @@ -185,8 +191,6 @@ include/postgresql/server/catalog/pg_opf
> include/postgresql/server/catalog/pg_opfamily_d.h
> include/postgresql/server/catalog/pg_partitioned_table.h
> include/postgresql/server/catalog/pg_partitioned_table_d.h
> -include/postgresql/server/catalog/pg_pltemplate.h
> -include/postgresql/server/catalog/pg_pltemplate_d.h
> include/postgresql/server/catalog/pg_policy.h
> include/postgresql/server/catalog/pg_policy_d.h
> include/postgresql/server/catalog/pg_proc.h
> @@ -282,21 +286,26 @@ 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/archive.h
> include/postgresql/server/common/base64.h
> +include/postgresql/server/common/checksum_helper.h
> include/postgresql/server/common/config_info.h
> include/postgresql/server/common/connect.h
> include/postgresql/server/common/controldata_utils.h
> include/postgresql/server/common/fe_memutils.h
> include/postgresql/server/common/file_perm.h
> include/postgresql/server/common/file_utils.h
> +include/postgresql/server/common/hashfn.h
> include/postgresql/server/common/int.h
> include/postgresql/server/common/int128.h
> include/postgresql/server/common/ip.h
> +include/postgresql/server/common/jsonapi.h
> include/postgresql/server/common/keywords.h
> include/postgresql/server/common/kwlookup.h
> include/postgresql/server/common/link-canary.h
> include/postgresql/server/common/logging.h
> include/postgresql/server/common/md5.h
> +include/postgresql/server/common/openssl.h
> include/postgresql/server/common/pg_lzcompress.h
> include/postgresql/server/common/relpath.h
> include/postgresql/server/common/restricted_token.h
> @@ -305,8 +314,10 @@ include/postgresql/server/common/scram-c
> include/postgresql/server/common/sha2.h
> include/postgresql/server/common/shortest_dec.h
> include/postgresql/server/common/string.h
> +include/postgresql/server/common/unicode_combining_table.h
> include/postgresql/server/common/unicode_norm.h
> include/postgresql/server/common/unicode_norm_table.h
> +include/postgresql/server/common/unicode_normprops_table.h
> include/postgresql/server/common/username.h
> include/postgresql/server/datatype/
> include/postgresql/server/datatype/timestamp.h
> @@ -335,6 +346,7 @@ include/postgresql/server/executor/nodeG
> include/postgresql/server/executor/nodeGroup.h
> include/postgresql/server/executor/nodeHash.h
> include/postgresql/server/executor/nodeHashjoin.h
> +include/postgresql/server/executor/nodeIncrementalSort.h
> include/postgresql/server/executor/nodeIndexonlyscan.h
> include/postgresql/server/executor/nodeIndexscan.h
> include/postgresql/server/executor/nodeLimit.h
> @@ -378,12 +390,14 @@ include/postgresql/server/extension/ltre
> include/postgresql/server/extension/seg/
> include/postgresql/server/extension/seg/segdata.h
> include/postgresql/server/fe_utils/
> +include/postgresql/server/fe_utils/archive.h
> +include/postgresql/server/fe_utils/cancel.h
> include/postgresql/server/fe_utils/conditional.h
> -include/postgresql/server/fe_utils/connect.h
> include/postgresql/server/fe_utils/mbprint.h
> include/postgresql/server/fe_utils/print.h
> include/postgresql/server/fe_utils/psqlscan.h
> include/postgresql/server/fe_utils/psqlscan_int.h
> +include/postgresql/server/fe_utils/recovery_gen.h
> include/postgresql/server/fe_utils/simple_list.h
> include/postgresql/server/fe_utils/string_utils.h
> include/postgresql/server/fmgr.h
> @@ -407,6 +421,7 @@ include/postgresql/server/lib/ilist.h
> include/postgresql/server/lib/integerset.h
> include/postgresql/server/lib/knapsack.h
> include/postgresql/server/lib/pairingheap.h
> +include/postgresql/server/lib/qunique.h
> include/postgresql/server/lib/rbtree.h
> include/postgresql/server/lib/simplehash.h
> include/postgresql/server/lib/stringinfo.h
> @@ -427,6 +442,7 @@ include/postgresql/server/libpq/pqsignal
> include/postgresql/server/libpq/scram.h
> include/postgresql/server/mb/
> include/postgresql/server/mb/pg_wchar.h
> +include/postgresql/server/mb/stringinfo_mb.h
> include/postgresql/server/miscadmin.h
> include/postgresql/server/nodes/
> include/postgresql/server/nodes/bitmapset.h
> @@ -544,7 +560,6 @@ include/postgresql/server/port/atomics/g
> include/postgresql/server/port/atomics/generic-gcc.h
> include/postgresql/server/port/atomics/generic-msvc.h
> include/postgresql/server/port/atomics/generic-sunpro.h
> -include/postgresql/server/port/atomics/generic-xlc.h
> include/postgresql/server/port/atomics/generic.h
> include/postgresql/server/port/cygwin.h
> include/postgresql/server/port/darwin.h
> @@ -591,6 +606,7 @@ include/postgresql/server/postmaster/bgw
> include/postgresql/server/postmaster/bgworker_internals.h
> include/postgresql/server/postmaster/bgwriter.h
> include/postgresql/server/postmaster/fork_process.h
> +include/postgresql/server/postmaster/interrupt.h
> include/postgresql/server/postmaster/pgarch.h
> include/postgresql/server/postmaster/postmaster.h
> include/postgresql/server/postmaster/startup.h
> @@ -604,10 +620,10 @@ include/postgresql/server/regex/regex.h
> include/postgresql/server/regex/regexport.h
> include/postgresql/server/regex/regguts.h
> include/postgresql/server/replication/
> +include/postgresql/server/replication/backup_manifest.h
> include/postgresql/server/replication/basebackup.h
> 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
> @@ -662,6 +678,7 @@ include/postgresql/server/snowball/libst
> include/postgresql/server/snowball/libstemmer/stem_UTF_8_finnish.h
> include/postgresql/server/snowball/libstemmer/stem_UTF_8_french.h
> include/postgresql/server/snowball/libstemmer/stem_UTF_8_german.h
> +include/postgresql/server/snowball/libstemmer/stem_UTF_8_greek.h
> include/postgresql/server/snowball/libstemmer/stem_UTF_8_hungarian.h
> include/postgresql/server/snowball/libstemmer/stem_UTF_8_indonesian.h
> include/postgresql/server/snowball/libstemmer/stem_UTF_8_irish.h
> @@ -737,6 +754,8 @@ include/postgresql/server/storage/standb
> include/postgresql/server/storage/standbydefs.h
> include/postgresql/server/storage/sync.h
> include/postgresql/server/tcop/
> +include/postgresql/server/tcop/cmdtag.h
> +include/postgresql/server/tcop/cmdtaglist.h
> include/postgresql/server/tcop/deparse_utility.h
> include/postgresql/server/tcop/dest.h
> include/postgresql/server/tcop/fastpath.h
> @@ -783,7 +802,6 @@ include/postgresql/server/utils/freepage
> include/postgresql/server/utils/geo_decls.h
> include/postgresql/server/utils/guc.h
> include/postgresql/server/utils/guc_tables.h
> -include/postgresql/server/utils/hashutils.h
> include/postgresql/server/utils/help_config.h
> include/postgresql/server/utils/hsearch.h
> include/postgresql/server/utils/index_selfuncs.h
> @@ -791,8 +809,8 @@ include/postgresql/server/utils/inet.h
> include/postgresql/server/utils/int8.h
> include/postgresql/server/utils/inval.h
> include/postgresql/server/utils/json.h
> -include/postgresql/server/utils/jsonapi.h
> include/postgresql/server/utils/jsonb.h
> +include/postgresql/server/utils/jsonfuncs.h
> include/postgresql/server/utils/jsonpath.h
> include/postgresql/server/utils/logtape.h
> include/postgresql/server/utils/lsyscache.h
> @@ -840,9 +858,9 @@ include/postgresql/server/utils/tzparser
> include/postgresql/server/utils/uuid.h
> include/postgresql/server/utils/varbit.h
> include/postgresql/server/utils/varlena.h
> +include/postgresql/server/utils/xid8.h
> include/postgresql/server/utils/xml.h
> include/postgresql/server/windowapi.h
> -@so lib/postgresql/ascii_and_mic.so
> @so lib/postgresql/cyrillic_and_mic.so
> @so lib/postgresql/dict_int.so
> @so lib/postgresql/dict_snowball.so
> @@ -863,7 +881,6 @@ lib/postgresql/pgxs/src/pl/plpython/regr
> @so lib/postgresql/plperl.so
> @so lib/postgresql/plpgsql.so
> @so lib/postgresql/test_decoding.so
> -@so lib/postgresql/utf8_and_ascii.so
> @so lib/postgresql/utf8_and_big5.so
> @so lib/postgresql/utf8_and_cyrillic.so
> @so lib/postgresql/utf8_and_euc2004.so
> @@ -889,29 +906,22 @@ lib/postgresql/pgxs/src/pl/plpython/regr
> @man man/man1/pg_recvlogical.1
> @man man/man1/pg_resetwal.1
> @man man/man1/pg_rewind.1
> +@man man/man1/pg_verifybackup.1
> @man man/man1/pg_waldump.1
> @man man/man1/postgres.1
> @man man/man1/postmaster.1
> share/doc/pkg-readmes/${PKGSTEM}
> share/postgresql/extension/
> -share/postgresql/extension/amcheck--1.1--1.2.sql
> -share/postgresql/extension/citext--1.5--1.6.sql
> -share/postgresql/extension/hstore--1.5--1.6.sql
> -share/postgresql/extension/pg_stat_statements--1.6--1.7.sql
> share/postgresql/extension/plperl--1.0.sql
> -share/postgresql/extension/plperl--unpackaged--1.0.sql
> share/postgresql/extension/plperl.control
> share/postgresql/extension/plperlu--1.0.sql
> -share/postgresql/extension/plperlu--unpackaged--1.0.sql
> share/postgresql/extension/plperlu.control
> share/postgresql/extension/plpgsql--1.0.sql
> -share/postgresql/extension/plpgsql--unpackaged--1.0.sql
> share/postgresql/extension/plpgsql.control
> share/postgresql/pg_hba.conf.sample
> share/postgresql/pg_ident.conf.sample
> share/postgresql/pg_service.conf.sample
> share/postgresql/postgres.bki
> -share/postgresql/postgres.shdescription
> share/postgresql/postgresql.conf.sample
> share/postgresql/tsearch_data/
> share/postgresql/tsearch_data/danish.stop
>
