> > @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
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
