PostgreSQL 13.1 Upgrade

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
19 messages Options
Reply | Threaded
Open this post in threaded view
|

PostgreSQL 13.1 Upgrade

Jeremy Evans-5
Now that PostgreSQL 13.1 is out, I think we can consider upgrading to
it.  The diff below was tested on amd64 on a partial bulk of the ports
depending on PostgreSQL.  Thankfully, the changes were less extensive
than in previous PostgreSQL major updates.

Briefly, the changes:

citus 9.0.1 -> 9.5.0
postgresql 12.5 -> 13.1
postgresql-pllua 2.0.4 -> 2.0.6
postgresql-previous 11.6 -> 12.5
skytools patch to fix build (dead upstream for about 3 years)

Could we please have this tested in a bulk?  Assuming there are no
problems in a bulk, OKs?

Thanks,
Jeremy

Index: databases/citus/Makefile
===================================================================
RCS file: /cvs/ports/databases/citus/Makefile,v
retrieving revision 1.7
diff -u -p -r1.7 Makefile
--- databases/citus/Makefile 6 Feb 2020 00:37:13 -0000 1.7
+++ databases/citus/Makefile 20 Nov 2020 23:39:40 -0000
@@ -3,7 +3,7 @@
 COMMENT = extension to horizontally scale PostgreSQL
 GH_ACCOUNT = citusdata
 GH_PROJECT = citus
-GH_TAGNAME = v9.0.1
+GH_TAGNAME = v9.5.0
 
 CATEGORIES = databases
 HOMEPAGE = https://www.citusdata.com/
Index: databases/citus/distinfo
===================================================================
RCS file: /cvs/ports/databases/citus/distinfo,v
retrieving revision 1.5
diff -u -p -r1.5 distinfo
--- databases/citus/distinfo 6 Feb 2020 00:37:13 -0000 1.5
+++ databases/citus/distinfo 20 Nov 2020 23:39:47 -0000
@@ -1,2 +1,2 @@
-SHA256 (citus-9.0.1.tar.gz) = u2mD9nDg9Ww3JQvvMgzVpq8hpfF3KLM0LmYISqMwfE8=
-SIZE (citus-9.0.1.tar.gz) = 4232025
+SHA256 (citus-9.5.0.tar.gz) = nZ0AaFh3EfXDSTGzSzHOnINOKHB5D7DxPQ1Ug7s8i+I=
+SIZE (citus-9.5.0.tar.gz) = 4703871
Index: databases/citus/pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/citus/pkg/PLIST,v
retrieving revision 1.4
diff -u -p -r1.4 PLIST
--- databases/citus/pkg/PLIST 6 Feb 2020 00:37:13 -0000 1.4
+++ databases/citus/pkg/PLIST 20 Nov 2020 23:41:29 -0000
@@ -1,22 +1,32 @@
 @comment $OpenBSD: PLIST,v 1.4 2020/02/06 00:37:13 jeremy Exp $
 include/postgresql/server/citus_version.h
 include/postgresql/server/distributed/
+include/postgresql/server/distributed/adaptive_executor.h
+include/postgresql/server/distributed/argutils.h
 include/postgresql/server/distributed/backend_data.h
+include/postgresql/server/distributed/cancel_utils.h
 include/postgresql/server/distributed/citus_acquire_lock.h
 include/postgresql/server/distributed/citus_clauses.h
 include/postgresql/server/distributed/citus_custom_scan.h
 include/postgresql/server/distributed/citus_nodefuncs.h
 include/postgresql/server/distributed/citus_nodes.h
 include/postgresql/server/distributed/citus_ruleutils.h
+include/postgresql/server/distributed/citus_safe_lib.h
 include/postgresql/server/distributed/colocation_utils.h
+include/postgresql/server/distributed/combine_query_planner.h
 include/postgresql/server/distributed/commands.h
 include/postgresql/server/distributed/connection_management.h
+include/postgresql/server/distributed/coordinator_protocol.h
+include/postgresql/server/distributed/cte_inline.h
 include/postgresql/server/distributed/deparse_shard_query.h
 include/postgresql/server/distributed/deparser.h
+include/postgresql/server/distributed/directed_acyclic_graph_execution.h
 include/postgresql/server/distributed/distributed_deadlock_detection.h
+include/postgresql/server/distributed/distributed_execution_locks.h
 include/postgresql/server/distributed/distributed_planner.h
 include/postgresql/server/distributed/distribution_column.h
 include/postgresql/server/distributed/enterprise.h
+include/postgresql/server/distributed/error_codes.h
 include/postgresql/server/distributed/errormessage.h
 include/postgresql/server/distributed/extended_op_node_utils.h
 include/postgresql/server/distributed/foreign_key_relationship.h
@@ -25,43 +35,48 @@ include/postgresql/server/distributed/fu
 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/intermediate_result_pruning.h
 include/postgresql/server/distributed/intermediate_results.h
 include/postgresql/server/distributed/listutils.h
 include/postgresql/server/distributed/local_executor.h
+include/postgresql/server/distributed/local_multi_copy.h
+include/postgresql/server/distributed/local_plan_cache.h
+include/postgresql/server/distributed/locally_reserved_shared_connections.h
 include/postgresql/server/distributed/lock_graph.h
+include/postgresql/server/distributed/log_utils.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/memutils.h
 include/postgresql/server/distributed/metadata_cache.h
 include/postgresql/server/distributed/metadata_sync.h
+include/postgresql/server/distributed/metadata_utility.h
 include/postgresql/server/distributed/multi_client_executor.h
 include/postgresql/server/distributed/multi_executor.h
 include/postgresql/server/distributed/multi_explain.h
 include/postgresql/server/distributed/multi_join_order.h
 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_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
 include/postgresql/server/distributed/multi_server_executor.h
-include/postgresql/server/distributed/multi_shard_transaction.h
+include/postgresql/server/distributed/namespace_utils.h
 include/postgresql/server/distributed/pg_dist_colocation.h
 include/postgresql/server/distributed/pg_dist_local_group.h
 include/postgresql/server/distributed/pg_dist_node.h
 include/postgresql/server/distributed/pg_dist_node_metadata.h
 include/postgresql/server/distributed/pg_dist_partition.h
 include/postgresql/server/distributed/pg_dist_placement.h
+include/postgresql/server/distributed/pg_dist_rebalance_strategy.h
 include/postgresql/server/distributed/pg_dist_shard.h
 include/postgresql/server/distributed/pg_dist_transaction.h
+include/postgresql/server/distributed/pg_version_constants.h
+include/postgresql/server/distributed/placement_access.h
 include/postgresql/server/distributed/placement_connection.h
 include/postgresql/server/distributed/query_colocation_checker.h
 include/postgresql/server/distributed/query_pushdown_planning.h
 include/postgresql/server/distributed/query_stats.h
+include/postgresql/server/distributed/query_utils.h
 include/postgresql/server/distributed/recursive_planning.h
 include/postgresql/server/distributed/reference_table_utils.h
 include/postgresql/server/distributed/relation_access_tracking.h
@@ -69,26 +84,34 @@ include/postgresql/server/distributed/re
 include/postgresql/server/distributed/relay_utility.h
 include/postgresql/server/distributed/remote_commands.h
 include/postgresql/server/distributed/remote_transaction.h
+include/postgresql/server/distributed/repartition_join_execution.h
 include/postgresql/server/distributed/resource_lock.h
 include/postgresql/server/distributed/run_from_same_connection.h
 include/postgresql/server/distributed/shard_pruning.h
+include/postgresql/server/distributed/shard_utils.h
 include/postgresql/server/distributed/shardinterval_utils.h
+include/postgresql/server/distributed/shared_connection_stats.h
 include/postgresql/server/distributed/shared_library_init.h
 include/postgresql/server/distributed/statistics_collection.h
+include/postgresql/server/distributed/string_utils.h
 include/postgresql/server/distributed/subplan_execution.h
-include/postgresql/server/distributed/task_tracker.h
-include/postgresql/server/distributed/task_tracker_protocol.h
+include/postgresql/server/distributed/task_execution_utils.h
+include/postgresql/server/distributed/tdigest_extension.h
+include/postgresql/server/distributed/time_constants.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
+include/postgresql/server/distributed/tuple_destination.h
 include/postgresql/server/distributed/tuplestore.h
 include/postgresql/server/distributed/version_compat.h
+include/postgresql/server/distributed/worker_create_or_replace.h
+include/postgresql/server/distributed/worker_log_messages.h
 include/postgresql/server/distributed/worker_manager.h
 include/postgresql/server/distributed/worker_protocol.h
 include/postgresql/server/distributed/worker_shard_visibility.h
 include/postgresql/server/distributed/worker_transaction.h
-lib/postgresql/citus.so
+@so lib/postgresql/citus.so
 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
@@ -145,4 +168,12 @@ share/postgresql/extension/citus--8.2-3-
 share/postgresql/extension/citus--8.2-4--8.3-1.sql
 share/postgresql/extension/citus--8.3-1--9.0-1.sql
 share/postgresql/extension/citus--9.0-1--9.0-2.sql
+share/postgresql/extension/citus--9.0-2--9.1-1.sql
+share/postgresql/extension/citus--9.1-1--9.2-1.sql
+share/postgresql/extension/citus--9.2-1--9.2-2.sql
+share/postgresql/extension/citus--9.2-2--9.2-4.sql
+share/postgresql/extension/citus--9.2-4--9.3-2.sql
+share/postgresql/extension/citus--9.3-1--9.2-4.sql
+share/postgresql/extension/citus--9.3-2--9.4-1.sql
+share/postgresql/extension/citus--9.4-1--9.5-1.sql
 share/postgresql/extension/citus.control
Index: databases/postgresql/Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
retrieving revision 1.266
diff -u -p -r1.266 Makefile
--- databases/postgresql/Makefile 14 Nov 2020 13:03:49 -0000 1.266
+++ databases/postgresql/Makefile 17 Nov 2020 04:32:09 -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,14 +16,13 @@ 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
 
 
 CATEGORIES= databases
-SHARED_LIBS= ecpg 7.10 \
- ecpg_compat 4.10 \
- pgtypes 4.9 \
- pq 6.11
+SHARED_LIBS= ecpg 7.11 \
+ ecpg_compat 4.11 \
+ pgtypes 4.10 \
+ pq 6.12
 
 HOMEPAGE= http://www.postgresql.org/
 
Index: databases/postgresql/distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql/distinfo,v
retrieving revision 1.86
diff -u -p -r1.86 distinfo
--- databases/postgresql/distinfo 13 Nov 2020 19:00:10 -0000 1.86
+++ databases/postgresql/distinfo 17 Nov 2020 03:43:08 -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: databases/postgresql/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
--- databases/postgresql/patches/patch-src_Makefile_shlib 3 Dec 2018 16:22:08 -0000 1.12
+++ databases/postgresql/patches/patch-src_Makefile_shlib 21 Aug 2020 19:39:40 -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: databases/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.3
diff -u -p -r1.3 patch-src_bin_scripts_vacuumdb_c
--- databases/postgresql/patches/patch-src_bin_scripts_vacuumdb_c 6 Feb 2020 00:36:12 -0000 1.3
+++ databases/postgresql/patches/patch-src_bin_scripts_vacuumdb_c 21 Aug 2020 19:39:40 -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: databases/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.6
diff -u -p -r1.6 patch-src_include_storage_s_lock_h
--- databases/postgresql/patches/patch-src_include_storage_s_lock_h 6 Feb 2020 00:36:12 -0000 1.6
+++ databases/postgresql/patches/patch-src_include_storage_s_lock_h 21 Aug 2020 19:39:40 -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: databases/postgresql/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
--- databases/postgresql/patches/patch-src_interfaces_libpq_Makefile 30 Nov 2017 16:13:12 -0000 1.14
+++ databases/postgresql/patches/patch-src_interfaces_libpq_Makefile 21 Aug 2020 19:39:40 -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: databases/postgresql/pkg/PLIST-contrib
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v
retrieving revision 1.21
diff -u -p -r1.21 PLIST-contrib
--- databases/postgresql/pkg/PLIST-contrib 6 Feb 2020 00:36:12 -0000 1.21
+++ databases/postgresql/pkg/PLIST-contrib 21 Aug 2020 20:06:02 -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: databases/postgresql/pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
retrieving revision 1.98
diff -u -p -r1.98 PLIST-docs
--- databases/postgresql/pkg/PLIST-docs 13 Nov 2020 19:00:10 -0000 1.98
+++ databases/postgresql/pkg/PLIST-docs 17 Nov 2020 04:31:47 -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: databases/postgresql/pkg/PLIST-main
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-main,v
retrieving revision 1.31
diff -u -p -r1.31 PLIST-main
--- databases/postgresql/pkg/PLIST-main 6 Feb 2020 00:36:12 -0000 1.31
+++ databases/postgresql/pkg/PLIST-main 21 Aug 2020 19:55:42 -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: databases/postgresql/pkg/PLIST-plpython
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-plpython,v
retrieving revision 1.9
diff -u -p -r1.9 PLIST-plpython
--- databases/postgresql/pkg/PLIST-plpython 6 Feb 2020 00:36:12 -0000 1.9
+++ databases/postgresql/pkg/PLIST-plpython 21 Aug 2020 19:55:43 -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: databases/postgresql/pkg/PLIST-server
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v
retrieving revision 1.40
diff -u -p -r1.40 PLIST-server
--- databases/postgresql/pkg/PLIST-server 24 Sep 2020 13:11:46 -0000 1.40
+++ databases/postgresql/pkg/PLIST-server 24 Sep 2020 22:23:02 -0000
@@ -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
Index: databases/postgresql-pllua/Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql-pllua/Makefile,v
retrieving revision 1.15
diff -u -p -r1.15 Makefile
--- databases/postgresql-pllua/Makefile 6 Feb 2020 00:36:47 -0000 1.15
+++ databases/postgresql-pllua/Makefile 19 Nov 2020 03:31:56 -0000
@@ -2,8 +2,8 @@
 
 COMMENT = Lua procedural language support for PostgreSQL
 
-VERSION = 2.0.4
-DISTNAME = REL_2_0_4
+VERSION = 2.0.6
+DISTNAME = REL_2_0_6
 PKGNAME = postgresql-pllua-${VERSION}
 
 CATEGORIES = databases
@@ -23,12 +23,12 @@ MODULES = lang/lua
 MODLUA_VERSION = 5.3
 
 BUILD_DEPENDS = ${RUN_DEPENDS} \
- postgresql-client->=12,<13:databases/postgresql,-main
-RUN_DEPENDS = postgresql-server->=12,<13:databases/postgresql,-server
+ postgresql-client->=13,<14:databases/postgresql,-main
+RUN_DEPENDS = postgresql-server->=13,<14:databases/postgresql,-server
 
 USE_GMAKE = Yes
 
-WRKDIST = ${WRKDIR}/pllua-ng-REL_2_0_4
+WRKDIST = ${WRKDIR}/pllua-ng-${DISTNAME}
 SUBST_VARS = MODLUA_INCL_DIR MODLUA_WANTLIB MODLUA_BIN LLD_EMUL
 
 pre-configure:
Index: databases/postgresql-pllua/distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql-pllua/distinfo,v
retrieving revision 1.4
diff -u -p -r1.4 distinfo
--- databases/postgresql-pllua/distinfo 6 Feb 2020 00:36:47 -0000 1.4
+++ databases/postgresql-pllua/distinfo 19 Nov 2020 03:30:18 -0000
@@ -1,2 +1,2 @@
-SHA256 (REL_2_0_4.tar.gz) = mjuku/1dCfeLka5N4/Wnu7QS+F4r8fc8j6EOiIVzXrE=
-SIZE (REL_2_0_4.tar.gz) = 211568
+SHA256 (REL_2_0_6.tar.gz) = sevmCaGL8k1dJM4xiNZq8jXhKoXVChsMO9zM48MtAjs=
+SIZE (REL_2_0_6.tar.gz) = 212810
Index: databases/postgresql-pllua/pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/postgresql-pllua/pkg/PLIST,v
retrieving revision 1.4
diff -u -p -r1.4 PLIST
--- databases/postgresql-pllua/pkg/PLIST 6 Feb 2020 00:36:47 -0000 1.4
+++ databases/postgresql-pllua/pkg/PLIST 19 Nov 2020 03:32:16 -0000
@@ -4,7 +4,7 @@ include/postgresql/server/extension/pllu
 include/postgresql/server/extension/pllua/pllua_luajit.h
 include/postgresql/server/extension/pllua/pllua_luaver.h
 include/postgresql/server/extension/pllua/pllua_pgver.h
-lib/postgresql/pllua.so
+@so lib/postgresql/pllua.so
 share/doc/pkg-readmes/${PKGSTEM}
 share/postgresql/extension/pllua--1.0--2.0.sql
 share/postgresql/extension/pllua--2.0.sql
Index: databases/postgresql-previous/Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/Makefile,v
retrieving revision 1.11
diff -u -p -r1.11 Makefile
--- databases/postgresql-previous/Makefile 6 Feb 2020 00:36:28 -0000 1.11
+++ databases/postgresql-previous/Makefile 21 Nov 2020 00:13:41 -0000
@@ -2,15 +2,15 @@
 
 COMMENT= PostgreSQL RDBMS (previous version, for pg_upgrade)
 
-VERSION= 11.6
+VERSION= 12.5
 DISTNAME= postgresql-${VERSION}
 PKGNAME= postgresql-previous-${VERSION}
 
 CATEGORIES= databases
-SHARED_LIBS= ecpg 7.9 \
- ecpg_compat 4.9 \
- pgtypes 4.8 \
- pq 6.10
+SHARED_LIBS= ecpg 7.10 \
+ ecpg_compat 4.10 \
+ pgtypes 4.9 \
+ pq 6.11
 
 HOMEPAGE= http://www.postgresql.org/
 
Index: databases/postgresql-previous/distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/distinfo,v
retrieving revision 1.4
diff -u -p -r1.4 distinfo
--- databases/postgresql-previous/distinfo 6 Feb 2020 00:36:28 -0000 1.4
+++ databases/postgresql-previous/distinfo 21 Nov 2020 00:14:29 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-11.6.tar.gz) = VkStP3W8mHPoDj1WnICtdYY0OLQmC/5MgvBWSG26kwg=
-SIZE (postgresql-11.6.tar.gz) = 26001678
+SHA256 (postgresql-12.5.tar.gz) = 2IPpfP0ss7OrqUkVQdtrMM/jO7akAxzbCOxQFNBNbpY=
+SIZE (postgresql-12.5.tar.gz) = 27137095
Index: databases/postgresql-previous/patches/patch-src_bin_scripts_vacuumdb_c
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_bin_scripts_vacuumdb_c,v
retrieving revision 1.3
diff -u -p -r1.3 patch-src_bin_scripts_vacuumdb_c
--- databases/postgresql-previous/patches/patch-src_bin_scripts_vacuumdb_c 19 Feb 2019 05:09:58 -0000 1.3
+++ databases/postgresql-previous/patches/patch-src_bin_scripts_vacuumdb_c 21 Aug 2020 20:09:58 -0000
@@ -2,9 +2,9 @@ $OpenBSD: patch-src_bin_scripts_vacuumdb
 Index: src/bin/scripts/vacuumdb.c
 --- src/bin/scripts/vacuumdb.c.orig
 +++ src/bin/scripts/vacuumdb.c
-@@ -10,6 +10,8 @@
-  *-------------------------------------------------------------------------
-  */
+@@ -14,6 +14,8 @@
+ #define FD_SETSIZE 1024 /* must set before winsock2.h is included */
+ #endif
 
 +#include <sys/select.h> /* FD_SETSIZE */
 +
Index: databases/postgresql-previous/patches/patch-src_include_storage_s_lock_h
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_include_storage_s_lock_h,v
retrieving revision 1.3
diff -u -p -r1.3 patch-src_include_storage_s_lock_h
--- databases/postgresql-previous/patches/patch-src_include_storage_s_lock_h 19 Feb 2019 05:09:58 -0000 1.3
+++ databases/postgresql-previous/patches/patch-src_include_storage_s_lock_h 21 Aug 2020 20:09:58 -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
-@@ -717,6 +717,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: databases/postgresql-previous/pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/postgresql-previous/pkg/PLIST,v
retrieving revision 1.4
diff -u -p -r1.4 PLIST
--- databases/postgresql-previous/pkg/PLIST 6 Feb 2020 00:36:28 -0000 1.4
+++ databases/postgresql-previous/pkg/PLIST 21 Aug 2020 20:24:08 -0000
@@ -10,6 +10,7 @@ bin/${POSTGRESQL_DIR}/
 @bin bin/${POSTGRESQL_DIR}/oid2name
 @bin bin/${POSTGRESQL_DIR}/pg_archivecleanup
 @bin bin/${POSTGRESQL_DIR}/pg_basebackup
+@bin bin/${POSTGRESQL_DIR}/pg_checksums
 @bin bin/${POSTGRESQL_DIR}/pg_config
 @bin bin/${POSTGRESQL_DIR}/pg_controldata
 @bin bin/${POSTGRESQL_DIR}/pg_ctl
@@ -25,7 +26,6 @@ bin/${POSTGRESQL_DIR}/
 @bin bin/${POSTGRESQL_DIR}/pg_test_fsync
 @bin bin/${POSTGRESQL_DIR}/pg_test_timing
 @bin bin/${POSTGRESQL_DIR}/pg_upgrade
-@bin bin/${POSTGRESQL_DIR}/pg_verify_checksums
 @bin bin/${POSTGRESQL_DIR}/pg_waldump
 @bin bin/${POSTGRESQL_DIR}/pgbench
 @bin bin/${POSTGRESQL_DIR}/postgres
@@ -107,6 +107,7 @@ include/${POSTGRESQL_DIR}/server/access/
 include/${POSTGRESQL_DIR}/server/access/parallel.h
 include/${POSTGRESQL_DIR}/server/access/printsimple.h
 include/${POSTGRESQL_DIR}/server/access/printtup.h
+include/${POSTGRESQL_DIR}/server/access/relation.h
 include/${POSTGRESQL_DIR}/server/access/reloptions.h
 include/${POSTGRESQL_DIR}/server/access/relscan.h
 include/${POSTGRESQL_DIR}/server/access/rewriteheap.h
@@ -122,6 +123,8 @@ include/${POSTGRESQL_DIR}/server/access/
 include/${POSTGRESQL_DIR}/server/access/stratnum.h
 include/${POSTGRESQL_DIR}/server/access/subtrans.h
 include/${POSTGRESQL_DIR}/server/access/sysattr.h
+include/${POSTGRESQL_DIR}/server/access/table.h
+include/${POSTGRESQL_DIR}/server/access/tableam.h
 include/${POSTGRESQL_DIR}/server/access/timeline.h
 include/${POSTGRESQL_DIR}/server/access/transam.h
 include/${POSTGRESQL_DIR}/server/access/tsmapi.h
@@ -260,6 +263,8 @@ include/${POSTGRESQL_DIR}/server/catalog
 include/${POSTGRESQL_DIR}/server/catalog/pg_statistic_d.h
 include/${POSTGRESQL_DIR}/server/catalog/pg_statistic_ext.h
 include/${POSTGRESQL_DIR}/server/catalog/pg_statistic_ext_d.h
+include/${POSTGRESQL_DIR}/server/catalog/pg_statistic_ext_data.h
+include/${POSTGRESQL_DIR}/server/catalog/pg_statistic_ext_data_d.h
 include/${POSTGRESQL_DIR}/server/catalog/pg_subscription.h
 include/${POSTGRESQL_DIR}/server/catalog/pg_subscription_d.h
 include/${POSTGRESQL_DIR}/server/catalog/pg_subscription_rel.h
@@ -327,6 +332,7 @@ include/${POSTGRESQL_DIR}/server/command
 include/${POSTGRESQL_DIR}/server/common/
 include/${POSTGRESQL_DIR}/server/common/base64.h
 include/${POSTGRESQL_DIR}/server/common/config_info.h
+include/${POSTGRESQL_DIR}/server/common/connect.h
 include/${POSTGRESQL_DIR}/server/common/controldata_utils.h
 include/${POSTGRESQL_DIR}/server/common/fe_memutils.h
 include/${POSTGRESQL_DIR}/server/common/file_perm.h
@@ -335,6 +341,9 @@ include/${POSTGRESQL_DIR}/server/common/
 include/${POSTGRESQL_DIR}/server/common/int128.h
 include/${POSTGRESQL_DIR}/server/common/ip.h
 include/${POSTGRESQL_DIR}/server/common/keywords.h
+include/${POSTGRESQL_DIR}/server/common/kwlookup.h
+include/${POSTGRESQL_DIR}/server/common/link-canary.h
+include/${POSTGRESQL_DIR}/server/common/logging.h
 include/${POSTGRESQL_DIR}/server/common/md5.h
 include/${POSTGRESQL_DIR}/server/common/pg_lzcompress.h
 include/${POSTGRESQL_DIR}/server/common/relpath.h
@@ -342,13 +351,13 @@ include/${POSTGRESQL_DIR}/server/common/
 include/${POSTGRESQL_DIR}/server/common/saslprep.h
 include/${POSTGRESQL_DIR}/server/common/scram-common.h
 include/${POSTGRESQL_DIR}/server/common/sha2.h
+include/${POSTGRESQL_DIR}/server/common/shortest_dec.h
 include/${POSTGRESQL_DIR}/server/common/string.h
 include/${POSTGRESQL_DIR}/server/common/unicode_norm.h
 include/${POSTGRESQL_DIR}/server/common/unicode_norm_table.h
 include/${POSTGRESQL_DIR}/server/common/username.h
 include/${POSTGRESQL_DIR}/server/datatype/
 include/${POSTGRESQL_DIR}/server/datatype/timestamp.h
-include/${POSTGRESQL_DIR}/server/dynloader.h
 include/${POSTGRESQL_DIR}/server/executor/
 include/${POSTGRESQL_DIR}/server/executor/execExpr.h
 include/${POSTGRESQL_DIR}/server/executor/execParallel.h
@@ -443,6 +452,7 @@ include/${POSTGRESQL_DIR}/server/lib/blo
 include/${POSTGRESQL_DIR}/server/lib/dshash.h
 include/${POSTGRESQL_DIR}/server/lib/hyperloglog.h
 include/${POSTGRESQL_DIR}/server/lib/ilist.h
+include/${POSTGRESQL_DIR}/server/lib/integerset.h
 include/${POSTGRESQL_DIR}/server/lib/knapsack.h
 include/${POSTGRESQL_DIR}/server/lib/pairingheap.h
 include/${POSTGRESQL_DIR}/server/lib/rbtree.h
@@ -451,6 +461,7 @@ include/${POSTGRESQL_DIR}/server/lib/str
 include/${POSTGRESQL_DIR}/server/libpq/
 include/${POSTGRESQL_DIR}/server/libpq/auth.h
 include/${POSTGRESQL_DIR}/server/libpq/be-fsstubs.h
+include/${POSTGRESQL_DIR}/server/libpq/be-gssapi-common.h
 include/${POSTGRESQL_DIR}/server/libpq/crypt.h
 include/${POSTGRESQL_DIR}/server/libpq/hba.h
 include/${POSTGRESQL_DIR}/server/libpq/ifaddr.h
@@ -476,16 +487,18 @@ include/${POSTGRESQL_DIR}/server/nodes/n
 include/${POSTGRESQL_DIR}/server/nodes/nodes.h
 include/${POSTGRESQL_DIR}/server/nodes/params.h
 include/${POSTGRESQL_DIR}/server/nodes/parsenodes.h
+include/${POSTGRESQL_DIR}/server/nodes/pathnodes.h
 include/${POSTGRESQL_DIR}/server/nodes/pg_list.h
 include/${POSTGRESQL_DIR}/server/nodes/plannodes.h
 include/${POSTGRESQL_DIR}/server/nodes/primnodes.h
 include/${POSTGRESQL_DIR}/server/nodes/print.h
 include/${POSTGRESQL_DIR}/server/nodes/readfuncs.h
-include/${POSTGRESQL_DIR}/server/nodes/relation.h
 include/${POSTGRESQL_DIR}/server/nodes/replnodes.h
+include/${POSTGRESQL_DIR}/server/nodes/supportnodes.h
 include/${POSTGRESQL_DIR}/server/nodes/tidbitmap.h
 include/${POSTGRESQL_DIR}/server/nodes/value.h
 include/${POSTGRESQL_DIR}/server/optimizer/
+include/${POSTGRESQL_DIR}/server/optimizer/appendinfo.h
 include/${POSTGRESQL_DIR}/server/optimizer/clauses.h
 include/${POSTGRESQL_DIR}/server/optimizer/cost.h
 include/${POSTGRESQL_DIR}/server/optimizer/geqo.h
@@ -497,7 +510,9 @@ include/${POSTGRESQL_DIR}/server/optimiz
 include/${POSTGRESQL_DIR}/server/optimizer/geqo_random.h
 include/${POSTGRESQL_DIR}/server/optimizer/geqo_recombination.h
 include/${POSTGRESQL_DIR}/server/optimizer/geqo_selection.h
+include/${POSTGRESQL_DIR}/server/optimizer/inherit.h
 include/${POSTGRESQL_DIR}/server/optimizer/joininfo.h
+include/${POSTGRESQL_DIR}/server/optimizer/optimizer.h
 include/${POSTGRESQL_DIR}/server/optimizer/orclauses.h
 include/${POSTGRESQL_DIR}/server/optimizer/paramassign.h
 include/${POSTGRESQL_DIR}/server/optimizer/pathnode.h
@@ -506,12 +521,10 @@ include/${POSTGRESQL_DIR}/server/optimiz
 include/${POSTGRESQL_DIR}/server/optimizer/plancat.h
 include/${POSTGRESQL_DIR}/server/optimizer/planmain.h
 include/${POSTGRESQL_DIR}/server/optimizer/planner.h
-include/${POSTGRESQL_DIR}/server/optimizer/predtest.h
 include/${POSTGRESQL_DIR}/server/optimizer/prep.h
 include/${POSTGRESQL_DIR}/server/optimizer/restrictinfo.h
 include/${POSTGRESQL_DIR}/server/optimizer/subselect.h
 include/${POSTGRESQL_DIR}/server/optimizer/tlist.h
-include/${POSTGRESQL_DIR}/server/optimizer/var.h
 include/${POSTGRESQL_DIR}/server/parser/
 include/${POSTGRESQL_DIR}/server/parser/analyze.h
 include/${POSTGRESQL_DIR}/server/parser/gram.h
@@ -539,6 +552,7 @@ include/${POSTGRESQL_DIR}/server/parser/
 include/${POSTGRESQL_DIR}/server/partitioning/
 include/${POSTGRESQL_DIR}/server/partitioning/partbounds.h
 include/${POSTGRESQL_DIR}/server/partitioning/partdefs.h
+include/${POSTGRESQL_DIR}/server/partitioning/partdesc.h
 include/${POSTGRESQL_DIR}/server/partitioning/partprune.h
 include/${POSTGRESQL_DIR}/server/pg_config.h
 include/${POSTGRESQL_DIR}/server/pg_config_ext.h
@@ -576,6 +590,7 @@ 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_bitutils.h
 include/${POSTGRESQL_DIR}/server/port/pg_bswap.h
 include/${POSTGRESQL_DIR}/server/port/pg_crc32c.h
 include/${POSTGRESQL_DIR}/server/port/solaris.h
@@ -666,15 +681,18 @@ include/${POSTGRESQL_DIR}/server/snowbal
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_finnish.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_french.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_german.h
-include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_hungarian.h
+include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_indonesian.h
+include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_irish.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_italian.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_norwegian.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_porter.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_portuguese.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_spanish.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_swedish.h
+include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_2_hungarian.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_2_romanian.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_KOI8_R_russian.h
+include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_arabic.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_danish.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_dutch.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_english.h
@@ -682,7 +700,11 @@ include/${POSTGRESQL_DIR}/server/snowbal
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_french.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_german.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_hungarian.h
+include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_indonesian.h
+include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_irish.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_italian.h
+include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_lithuanian.h
+include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_nepali.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_norwegian.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_porter.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_portuguese.h
@@ -690,6 +712,7 @@ include/${POSTGRESQL_DIR}/server/snowbal
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_russian.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_spanish.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_swedish.h
+include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_tamil.h
 include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_turkish.h
 include/${POSTGRESQL_DIR}/server/statistics/
 include/${POSTGRESQL_DIR}/server/statistics/extended_stats_internal.h
@@ -724,6 +747,7 @@ include/${POSTGRESQL_DIR}/server/storage
 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/md.h
 include/${POSTGRESQL_DIR}/server/storage/off.h
 include/${POSTGRESQL_DIR}/server/storage/pg_sema.h
 include/${POSTGRESQL_DIR}/server/storage/pg_shmem.h
@@ -748,6 +772,7 @@ include/${POSTGRESQL_DIR}/server/storage
 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/storage/sync.h
 include/${POSTGRESQL_DIR}/server/tcop/
 include/${POSTGRESQL_DIR}/server/tcop/deparse_utility.h
 include/${POSTGRESQL_DIR}/server/tcop/dest.h
@@ -771,7 +796,6 @@ include/${POSTGRESQL_DIR}/server/utils/a
 include/${POSTGRESQL_DIR}/server/utils/arrayaccess.h
 include/${POSTGRESQL_DIR}/server/utils/ascii.h
 include/${POSTGRESQL_DIR}/server/utils/attoptcache.h
-include/${POSTGRESQL_DIR}/server/utils/backend_random.h
 include/${POSTGRESQL_DIR}/server/utils/builtins.h
 include/${POSTGRESQL_DIR}/server/utils/bytea.h
 include/${POSTGRESQL_DIR}/server/utils/cash.h
@@ -782,12 +806,12 @@ include/${POSTGRESQL_DIR}/server/utils/d
 include/${POSTGRESQL_DIR}/server/utils/datum.h
 include/${POSTGRESQL_DIR}/server/utils/dsa.h
 include/${POSTGRESQL_DIR}/server/utils/dynahash.h
-include/${POSTGRESQL_DIR}/server/utils/dynamic_loader.h
 include/${POSTGRESQL_DIR}/server/utils/elog.h
 include/${POSTGRESQL_DIR}/server/utils/errcodes.h
 include/${POSTGRESQL_DIR}/server/utils/evtcache.h
 include/${POSTGRESQL_DIR}/server/utils/expandeddatum.h
 include/${POSTGRESQL_DIR}/server/utils/expandedrecord.h
+include/${POSTGRESQL_DIR}/server/utils/float.h
 include/${POSTGRESQL_DIR}/server/utils/fmgroids.h
 include/${POSTGRESQL_DIR}/server/utils/fmgrprotos.h
 include/${POSTGRESQL_DIR}/server/utils/fmgrtab.h
@@ -806,11 +830,11 @@ include/${POSTGRESQL_DIR}/server/utils/i
 include/${POSTGRESQL_DIR}/server/utils/json.h
 include/${POSTGRESQL_DIR}/server/utils/jsonapi.h
 include/${POSTGRESQL_DIR}/server/utils/jsonb.h
+include/${POSTGRESQL_DIR}/server/utils/jsonpath.h
 include/${POSTGRESQL_DIR}/server/utils/logtape.h
 include/${POSTGRESQL_DIR}/server/utils/lsyscache.h
 include/${POSTGRESQL_DIR}/server/utils/memdebug.h
 include/${POSTGRESQL_DIR}/server/utils/memutils.h
-include/${POSTGRESQL_DIR}/server/utils/nabstime.h
 include/${POSTGRESQL_DIR}/server/utils/numeric.h
 include/${POSTGRESQL_DIR}/server/utils/palloc.h
 include/${POSTGRESQL_DIR}/server/utils/partcache.h
@@ -846,7 +870,6 @@ include/${POSTGRESQL_DIR}/server/utils/s
 include/${POSTGRESQL_DIR}/server/utils/syscache.h
 include/${POSTGRESQL_DIR}/server/utils/timeout.h
 include/${POSTGRESQL_DIR}/server/utils/timestamp.h
-include/${POSTGRESQL_DIR}/server/utils/tqual.h
 include/${POSTGRESQL_DIR}/server/utils/tuplesort.h
 include/${POSTGRESQL_DIR}/server/utils/tuplestore.h
 include/${POSTGRESQL_DIR}/server/utils/typcache.h
@@ -903,8 +926,10 @@ lib/${POSTGRESQL_DIR}/libecpg.so.7
 lib/${POSTGRESQL_DIR}/libecpg_compat.so.4
 @lib lib/${POSTGRESQL_DIR}/libecpg_compat.so.${LIBecpg_compat_VERSION}
 @static-lib lib/${POSTGRESQL_DIR}/libpgcommon.a
+@static-lib lib/${POSTGRESQL_DIR}/libpgcommon_shlib.a
 @static-lib lib/${POSTGRESQL_DIR}/libpgfeutils.a
 @static-lib lib/${POSTGRESQL_DIR}/libpgport.a
+@static-lib lib/${POSTGRESQL_DIR}/libpgport_shlib.a
 @static-lib lib/${POSTGRESQL_DIR}/libpgtypes.a
 @so lib/${POSTGRESQL_DIR}/libpgtypes.so
 lib/${POSTGRESQL_DIR}/libpgtypes.so.4
@@ -958,7 +983,6 @@ lib/${POSTGRESQL_DIR}/pkgconfig/libpq.pc
 @so lib/${POSTGRESQL_DIR}/tablefunc.so
 @so lib/${POSTGRESQL_DIR}/tcn.so
 @so lib/${POSTGRESQL_DIR}/test_decoding.so
-@so lib/${POSTGRESQL_DIR}/timetravel.so
 @so lib/${POSTGRESQL_DIR}/tsm_system_rows.so
 @so lib/${POSTGRESQL_DIR}/tsm_system_time.so
 @so lib/${POSTGRESQL_DIR}/unaccent.so
@@ -986,9 +1010,7 @@ share/doc/postgresql/extension/autoinc.e
 share/doc/postgresql/extension/insert_username.example
 share/doc/postgresql/extension/moddatetime.example
 share/doc/postgresql/extension/refint.example
-share/doc/postgresql/extension/timetravel.example
 share/${POSTGRESQL_DIR}/
-share/${POSTGRESQL_DIR}/conversion_create.sql
 share/${POSTGRESQL_DIR}/errcodes.txt
 share/${POSTGRESQL_DIR}/extension/
 share/${POSTGRESQL_DIR}/extension/adminpack--1.0--1.1.sql
@@ -997,6 +1019,7 @@ share/${POSTGRESQL_DIR}/extension/adminp
 share/${POSTGRESQL_DIR}/extension/adminpack.control
 share/${POSTGRESQL_DIR}/extension/amcheck--1.0--1.1.sql
 share/${POSTGRESQL_DIR}/extension/amcheck--1.0.sql
+share/${POSTGRESQL_DIR}/extension/amcheck--1.1--1.2.sql
 share/${POSTGRESQL_DIR}/extension/amcheck.control
 share/${POSTGRESQL_DIR}/extension/autoinc--1.0.sql
 share/${POSTGRESQL_DIR}/extension/autoinc--unpackaged--1.0.sql
@@ -1023,6 +1046,7 @@ share/${POSTGRESQL_DIR}/extension/citext
 share/${POSTGRESQL_DIR}/extension/citext--1.3--1.4.sql
 share/${POSTGRESQL_DIR}/extension/citext--1.4--1.5.sql
 share/${POSTGRESQL_DIR}/extension/citext--1.4.sql
+share/${POSTGRESQL_DIR}/extension/citext--1.5--1.6.sql
 share/${POSTGRESQL_DIR}/extension/citext--unpackaged--1.0.sql
 share/${POSTGRESQL_DIR}/extension/citext.control
 share/${POSTGRESQL_DIR}/extension/cube--1.0--1.1.sql
@@ -1059,6 +1083,7 @@ share/${POSTGRESQL_DIR}/extension/hstore
 share/${POSTGRESQL_DIR}/extension/hstore--1.3--1.4.sql
 share/${POSTGRESQL_DIR}/extension/hstore--1.4--1.5.sql
 share/${POSTGRESQL_DIR}/extension/hstore--1.4.sql
+share/${POSTGRESQL_DIR}/extension/hstore--1.5--1.6.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
@@ -1129,6 +1154,7 @@ share/${POSTGRESQL_DIR}/extension/pg_sta
 share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.4--1.5.sql
 share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.4.sql
 share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.5--1.6.sql
+share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.6--1.7.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
@@ -1191,9 +1217,6 @@ share/${POSTGRESQL_DIR}/extension/tablef
 share/${POSTGRESQL_DIR}/extension/tablefunc.control
 share/${POSTGRESQL_DIR}/extension/tcn--1.0.sql
 share/${POSTGRESQL_DIR}/extension/tcn.control
-share/${POSTGRESQL_DIR}/extension/timetravel--1.0.sql
-share/${POSTGRESQL_DIR}/extension/timetravel--unpackaged--1.0.sql
-share/${POSTGRESQL_DIR}/extension/timetravel.control
 share/${POSTGRESQL_DIR}/extension/tsm_system_rows--1.0.sql
 share/${POSTGRESQL_DIR}/extension/tsm_system_rows.control
 share/${POSTGRESQL_DIR}/extension/tsm_system_time--1.0.sql
@@ -1219,7 +1242,6 @@ share/${POSTGRESQL_DIR}/postgres.descrip
 share/${POSTGRESQL_DIR}/postgres.shdescription
 share/${POSTGRESQL_DIR}/postgresql.conf.sample
 share/${POSTGRESQL_DIR}/psqlrc.sample
-share/${POSTGRESQL_DIR}/recovery.conf.sample
 share/${POSTGRESQL_DIR}/snowball_create.sql
 share/${POSTGRESQL_DIR}/sql_features.txt
 share/${POSTGRESQL_DIR}/system_views.sql
@@ -1253,6 +1275,7 @@ share/${POSTGRESQL_DIR}/tsearch_data/hun
 share/${POSTGRESQL_DIR}/tsearch_data/ispell_sample.affix
 share/${POSTGRESQL_DIR}/tsearch_data/ispell_sample.dict
 share/${POSTGRESQL_DIR}/tsearch_data/italian.stop
+share/${POSTGRESQL_DIR}/tsearch_data/nepali.stop
 share/${POSTGRESQL_DIR}/tsearch_data/norwegian.stop
 share/${POSTGRESQL_DIR}/tsearch_data/portuguese.stop
 share/${POSTGRESQL_DIR}/tsearch_data/russian.stop
Index: databases/skytools/Makefile
===================================================================
RCS file: /cvs/ports/databases/skytools/Makefile,v
retrieving revision 1.32
diff -u -p -r1.32 Makefile
--- databases/skytools/Makefile 20 Mar 2020 16:44:22 -0000 1.32
+++ databases/skytools/Makefile 21 Nov 2020 00:01:09 -0000
@@ -5,7 +5,7 @@ COMMENT= PostgreSQL tools from Skype
 # XXX outdated; http://pgfoundry.org/frs/download.php/3622/skytools-3.2.tar.gz
 MODPY_EGG_VERSION= 3.1.1
 DISTNAME= skytools-${MODPY_EGG_VERSION}
-REVISION= 6
+REVISION= 7
 
 CATEGORIES= databases
 
Index: databases/skytools/patches/patch-sql_pgq_triggers_common_c
===================================================================
RCS file: /cvs/ports/databases/skytools/patches/patch-sql_pgq_triggers_common_c,v
retrieving revision 1.1
diff -u -p -r1.1 patch-sql_pgq_triggers_common_c
--- databases/skytools/patches/patch-sql_pgq_triggers_common_c 19 Feb 2019 05:11:57 -0000 1.1
+++ databases/skytools/patches/patch-sql_pgq_triggers_common_c 21 Nov 2020 00:00:20 -0000
@@ -5,15 +5,17 @@ Support PostgreSQL 11.
 Index: sql/pgq/triggers/common.c
 --- sql/pgq/triggers/common.c.orig
 +++ sql/pgq/triggers/common.c
-@@ -18,6 +18,7 @@
+@@ -18,7 +18,9 @@
 
  #include <postgres.h>
 
 +#include <access/htup_details.h>
  #include <commands/trigger.h>
++#include <common/hashfn.h>
  #include <catalog/pg_type.h>
  #include <catalog/pg_namespace.h>
-@@ -121,9 +122,9 @@ static void fill_magic_columns(PgqTriggerEvent *ev)
+ #include <executor/spi.h>
+@@ -121,9 +123,9 @@ static void fill_magic_columns(PgqTriggerEvent *ev)
 
  for (i = 0; i < tupdesc->natts; i++) {
  /* Skip dropped columns */
@@ -25,7 +27,7 @@ Index: sql/pgq/triggers/common.c
  if (!is_magic_field(col_name))
  continue;
  if (strcmp(col_name, "_pgq_ev_type") == 0)
-@@ -477,7 +478,7 @@ static void parse_oldstyle_args(PgqTriggerEvent *ev, T
+@@ -477,7 +479,7 @@ static void parse_oldstyle_args(PgqTriggerEvent *ev, T
  */
  tupdesc = tg->tg_relation->rd_att;
  for (i = 0, attcnt = 0; i < tupdesc->natts; i++) {
@@ -34,7 +36,7 @@ Index: sql/pgq/triggers/common.c
  attcnt++;
  }
 
-@@ -594,9 +595,9 @@ bool pgqtriga_skip_col(PgqTriggerEvent *ev, int i, int
+@@ -594,9 +596,9 @@ bool pgqtriga_skip_col(PgqTriggerEvent *ev, int i, int
  const char *name;
 
  tupdesc = tg->tg_relation->rd_att;
@@ -46,7 +48,7 @@ Index: sql/pgq/triggers/common.c
 
  if (is_magic_field(name)) {
  ev->tgargs->custom_fields = 1;
-@@ -628,9 +629,9 @@ bool pgqtriga_is_pkey(PgqTriggerEvent *ev, int i, int
+@@ -628,9 +630,9 @@ bool pgqtriga_is_pkey(PgqTriggerEvent *ev, int i, int
  return ev->attkind[attkind_idx] == 'k';
  } else if (ev->pkey_list) {
  tupdesc = tg->tg_relation->rd_att;
Index: databases/skytools/patches/patch-sql_pgq_lowlevel_insert_event_c
===================================================================
RCS file: databases/skytools/patches/patch-sql_pgq_lowlevel_insert_event_c
diff -N databases/skytools/patches/patch-sql_pgq_lowlevel_insert_event_c
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ databases/skytools/patches/patch-sql_pgq_lowlevel_insert_event_c 21 Nov 2020 00:00:59 -0000
@@ -0,0 +1,15 @@
+$OpenBSD$
+
+Work with PostgreSQL 13+.
+
+Index: sql/pgq/lowlevel/insert_event.c
+--- sql/pgq/lowlevel/insert_event.c.orig
++++ sql/pgq/lowlevel/insert_event.c
+@@ -21,6 +21,7 @@
+
+ #include "catalog/pg_type.h"
+ #include "commands/trigger.h"
++#include "common/hashfn.h"
+ #include "executor/spi.h"
+ #include "lib/stringinfo.h"
+ #include "utils/builtins.h"

Reply | Threaded
Open this post in threaded view
|

skytools [was Re: PostgreSQL 13.1 Upgrade]

Stuart Henderson
On 2020/11/20 17:06, Jeremy Evans wrote:
> skytools patch to fix build (dead upstream for about 3 years)

it's still actively developed, but has been reorganized into separate
projects (py-skytools, pgq, londiste, walmgr etc).

Since the current distfile is no longer available here's an update to
the most recent skytools-legacy version (the patches will still be
needed for 13.x though).. is anyone still using this that can test?

Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/skytools/Makefile,v
retrieving revision 1.32
diff -u -p -r1.32 Makefile
--- Makefile 20 Mar 2020 16:44:22 -0000 1.32
+++ Makefile 21 Nov 2020 14:06:55 -0000
@@ -2,44 +2,52 @@
 
 COMMENT= PostgreSQL tools from Skype
 
-# XXX outdated; http://pgfoundry.org/frs/download.php/3622/skytools-3.2.tar.gz
-MODPY_EGG_VERSION= 3.1.1
-DISTNAME= skytools-${MODPY_EGG_VERSION}
-REVISION= 6
+MODPY_EGG_VERSION= 3.2.6
+GH_ACCOUNT= pgq
+GH_PROJECT= skytools-legacy
+GH_TAGNAME= ${MODPY_EGG_VERSION}
+PKGNAME= skytools-${MODPY_EGG_VERSION}
 
 CATEGORIES= databases
 
-HOMEPAGE= http://pgfoundry.org/projects/skytools
+HOMEPAGE= https://wiki.postgresql.org/wiki/SkyTools
 
 MAINTAINER= Pierre-Emmanuel Andre <[hidden email]>
 
 # BSD
 PERMIT_PACKAGE= Yes
 
-WANTLIB= c pq pthread ${MODPY_WANTLIB}
-
-MASTER_SITES= https://github.com/downloads/markokr/skytools/
+WANTLIB= c pq pthread ${MODPY_WANTLIB}
 
 MODULES= lang/python
 
+MASTER_SITES0= https://github.com/markokr/libusual/archive/
+DISTFILES= ${DISTNAME}.tar.gz libusual-{}2c1cb7f9bfa0a2a183354eb2630a3e4136d0f96b.tar.gz:0
+
 BUILD_DEPENDS= databases/postgresql,-server>=12 \
- databases/postgresql,-main>=12
+ databases/postgresql,-main>=12 \
+ textproc/asciidoc \
+ textproc/xmlto
 LIB_DEPENDS= databases/postgresql,-main>=12
-RUN_DEPENDS=    databases/py-psycopg2
+RUN_DEPENDS= databases/py-psycopg2
 
 NO_TEST= Yes
 USE_GMAKE= Yes
 
-CONFIGURE_STYLE=gnu
-CONFIGURE_ARGS= --with-python=${MODPY_BIN}
+CONFIGURE_STYLE= autoreconf
+AUTOCONF_VERSION= 2.69
+AUTOMAKE_VERSION= 1.16
+AUTORECONF= ./autogen.sh
+CONFIGURE_ARGS= --with-python=${MODPY_BIN} \
+ --with-asciidoc
+
+MAKE_ENV= PYTHON=${MODPY_BIN}
+MAKE_FLAGS= V=1
 
-BINFILES= bulk_loader.py cube_dispatcher.py londiste.py \
- pgqadm.py queue_mover.py queue_splitter.py \
- scriptmgr.py skytools_upgrade.py table_dispatcher.py \
- walmgr.py
+post-extract:
+ mv ${WRKDIR}/libusual-*/* ${WRKSRC}/lib/
 
 pre-configure:
- ${SUBST_CMD} ${WRKSRC}/doc/Makefile
  find ${WRKSRC} -name '*.py' \
  -exec sed -i 's,/usr/bin/env python,${MODPY_BIN},' {} +
 
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/skytools/distinfo,v
retrieving revision 1.9
diff -u -p -r1.9 distinfo
--- distinfo 17 Oct 2012 20:22:46 -0000 1.9
+++ distinfo 21 Nov 2020 14:06:55 -0000
@@ -1,2 +1,4 @@
-SHA256 (skytools-3.1.1.tar.gz) = Elpb0XPfYKFPqtHGQ8RtJoVMv3UWwAWoc0GiDdQivA0=
-SIZE (skytools-3.1.1.tar.gz) = 651345
+SHA256 (libusual-2c1cb7f9bfa0a2a183354eb2630a3e4136d0f96b.tar.gz) = Kd+d00RJyiefLINSu9eBQc++igtASgPfGp9ERG6kXE8=
+SHA256 (skytools-legacy-3.2.6.tar.gz) = XmMDNbzxJlKtqtyNcNofqWW0teq/YofNTnr0CXX7YtY=
+SIZE (libusual-2c1cb7f9bfa0a2a183354eb2630a3e4136d0f96b.tar.gz) = 236130
+SIZE (skytools-legacy-3.2.6.tar.gz) = 513553
Index: patches/patch-doc_Makefile
===================================================================
RCS file: patches/patch-doc_Makefile
diff -N patches/patch-doc_Makefile
--- patches/patch-doc_Makefile 17 Oct 2012 20:22:46 -0000 1.4
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,14 +0,0 @@
-$OpenBSD: patch-doc_Makefile,v 1.4 2012/10/17 20:22:46 pea Exp $
---- doc/Makefile.orig Tue Oct  9 12:36:51 2012
-+++ doc/Makefile Wed Oct 17 16:00:07 2012
-@@ -35,8 +35,8 @@ FQMAN = $(FQMAN1) $(FQMAN1_SFX) $(FQMAN5)
-
- COMMON = common.switches.txt common.config.txt
-
--GETATTRS = $(PYTHON) ../misc/getattrs.py
--FIXMAN = $(PYTHON) ../misc/fixman.py
-+GETATTRS = ${MODPY_BIN} ../misc/getattrs.py
-+FIXMAN = ${MODPY_BIN} ../misc/fixman.py
-
- #AFLAGS = -a linkcss
- #AFLAGS = -a stylesheet=extra.css
Index: patches/patch-sql_pgq_triggers_common_c
===================================================================
RCS file: /cvs/ports/databases/skytools/patches/patch-sql_pgq_triggers_common_c,v
retrieving revision 1.1
diff -u -p -r1.1 patch-sql_pgq_triggers_common_c
--- patches/patch-sql_pgq_triggers_common_c 19 Feb 2019 05:11:57 -0000 1.1
+++ patches/patch-sql_pgq_triggers_common_c 21 Nov 2020 14:06:55 -0000
@@ -13,7 +13,7 @@ Index: sql/pgq/triggers/common.c
  #include <commands/trigger.h>
  #include <catalog/pg_type.h>
  #include <catalog/pg_namespace.h>
-@@ -121,9 +122,9 @@ static void fill_magic_columns(PgqTriggerEvent *ev)
+@@ -125,9 +126,9 @@ static void fill_magic_columns(PgqTriggerEvent *ev)
 
  for (i = 0; i < tupdesc->natts; i++) {
  /* Skip dropped columns */
@@ -25,7 +25,7 @@ Index: sql/pgq/triggers/common.c
  if (!is_magic_field(col_name))
  continue;
  if (strcmp(col_name, "_pgq_ev_type") == 0)
-@@ -477,7 +478,7 @@ static void parse_oldstyle_args(PgqTriggerEvent *ev, T
+@@ -481,7 +482,7 @@ static void parse_oldstyle_args(PgqTriggerEvent *ev, T
  */
  tupdesc = tg->tg_relation->rd_att;
  for (i = 0, attcnt = 0; i < tupdesc->natts; i++) {
@@ -34,7 +34,7 @@ Index: sql/pgq/triggers/common.c
  attcnt++;
  }
 
-@@ -594,9 +595,9 @@ bool pgqtriga_skip_col(PgqTriggerEvent *ev, int i, int
+@@ -598,9 +599,9 @@ bool pgqtriga_skip_col(PgqTriggerEvent *ev, int i, int
  const char *name;
 
  tupdesc = tg->tg_relation->rd_att;
@@ -46,7 +46,7 @@ Index: sql/pgq/triggers/common.c
 
  if (is_magic_field(name)) {
  ev->tgargs->custom_fields = 1;
-@@ -628,9 +629,9 @@ bool pgqtriga_is_pkey(PgqTriggerEvent *ev, int i, int
+@@ -632,9 +633,9 @@ bool pgqtriga_is_pkey(PgqTriggerEvent *ev, int i, int
  return ev->attkind[attkind_idx] == 'k';
  } else if (ev->pkey_list) {
  tupdesc = tg->tg_relation->rd_att;
Index: pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/skytools/pkg/PLIST,v
retrieving revision 1.6
diff -u -p -r1.6 PLIST
--- pkg/PLIST 17 Oct 2012 20:22:46 -0000 1.6
+++ pkg/PLIST 21 Nov 2020 14:06:55 -0000
@@ -1,4 +1,5 @@
 @comment $OpenBSD: PLIST,v 1.6 2012/10/17 20:22:46 pea Exp $
+bin/data_maintainer3
 bin/londiste3
 @bin bin/pgqd
 bin/qadmin
@@ -9,8 +10,8 @@ bin/simple_consumer3
 bin/simple_local_consumer3
 bin/skytools_upgrade3
 bin/walmgr3
-lib/postgresql/pgq_lowlevel.so
-lib/postgresql/pgq_triggers.so
+@so lib/postgresql/pgq_lowlevel.so
+@so lib/postgresql/pgq_triggers.so
 lib/python${MODPY_VERSION}/site-packages/londiste/
 lib/python${MODPY_VERSION}/site-packages/londiste/__init__.py
 lib/python${MODPY_VERSION}/site-packages/londiste/__init__.pyc
@@ -31,10 +32,10 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/londiste/handlers/dispatch.pyc
 lib/python${MODPY_VERSION}/site-packages/londiste/handlers/multimaster.py
 lib/python${MODPY_VERSION}/site-packages/londiste/handlers/multimaster.pyc
-lib/python${MODPY_VERSION}/site-packages/londiste/handlers/part.py
-lib/python${MODPY_VERSION}/site-packages/londiste/handlers/part.pyc
 lib/python${MODPY_VERSION}/site-packages/londiste/handlers/qtable.py
 lib/python${MODPY_VERSION}/site-packages/londiste/handlers/qtable.pyc
+lib/python${MODPY_VERSION}/site-packages/londiste/handlers/shard.py
+lib/python${MODPY_VERSION}/site-packages/londiste/handlers/shard.pyc
 lib/python${MODPY_VERSION}/site-packages/londiste/handlers/vtable.py
 lib/python${MODPY_VERSION}/site-packages/londiste/handlers/vtable.pyc
 lib/python${MODPY_VERSION}/site-packages/londiste/playback.py
@@ -52,6 +53,8 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/pgq/
 lib/python${MODPY_VERSION}/site-packages/pgq/__init__.py
 lib/python${MODPY_VERSION}/site-packages/pgq/__init__.pyc
+lib/python${MODPY_VERSION}/site-packages/pgq/baseconsumer.py
+lib/python${MODPY_VERSION}/site-packages/pgq/baseconsumer.pyc
 lib/python${MODPY_VERSION}/site-packages/pgq/cascade/
 lib/python${MODPY_VERSION}/site-packages/pgq/cascade/__init__.py
 lib/python${MODPY_VERSION}/site-packages/pgq/cascade/__init__.pyc
@@ -71,16 +74,12 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/pgq/event.pyc
 lib/python${MODPY_VERSION}/site-packages/pgq/localconsumer.py
 lib/python${MODPY_VERSION}/site-packages/pgq/localconsumer.pyc
-lib/python${MODPY_VERSION}/site-packages/pgq/maint.py
-lib/python${MODPY_VERSION}/site-packages/pgq/maint.pyc
 lib/python${MODPY_VERSION}/site-packages/pgq/producer.py
 lib/python${MODPY_VERSION}/site-packages/pgq/producer.pyc
 lib/python${MODPY_VERSION}/site-packages/pgq/remoteconsumer.py
 lib/python${MODPY_VERSION}/site-packages/pgq/remoteconsumer.pyc
 lib/python${MODPY_VERSION}/site-packages/pgq/status.py
 lib/python${MODPY_VERSION}/site-packages/pgq/status.pyc
-lib/python${MODPY_VERSION}/site-packages/pgq/ticker.py
-lib/python${MODPY_VERSION}/site-packages/pgq/ticker.pyc
 lib/python${MODPY_VERSION}/site-packages/pkgloader-1.0-py${MODPY_VERSION}.egg-info
 lib/python${MODPY_VERSION}/site-packages/pkgloader.py
 lib/python${MODPY_VERSION}/site-packages/pkgloader.pyc
@@ -88,7 +87,8 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/skytools-${MODPY_EGG_VERSION}-py${MODPY_VERSION}.egg-info
 lib/python${MODPY_VERSION}/site-packages/skytools/__init__.py
 lib/python${MODPY_VERSION}/site-packages/skytools/__init__.pyc
-lib/python${MODPY_VERSION}/site-packages/skytools/_cquoting.so
+@so lib/python${MODPY_VERSION}/site-packages/skytools/_chashtext.so
+@so lib/python${MODPY_VERSION}/site-packages/skytools/_cquoting.so
 lib/python${MODPY_VERSION}/site-packages/skytools/_pyquoting.py
 lib/python${MODPY_VERSION}/site-packages/skytools/_pyquoting.pyc
 lib/python${MODPY_VERSION}/site-packages/skytools/adminscript.py
@@ -107,7 +107,8 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/skytools/fileutil.pyc
 lib/python${MODPY_VERSION}/site-packages/skytools/gzlog.py
 lib/python${MODPY_VERSION}/site-packages/skytools/gzlog.pyc
-lib/python${MODPY_VERSION}/site-packages/skytools/hashtext.so
+lib/python${MODPY_VERSION}/site-packages/skytools/hashtext.py
+lib/python${MODPY_VERSION}/site-packages/skytools/hashtext.pyc
 lib/python${MODPY_VERSION}/site-packages/skytools/installer_config.py
 lib/python${MODPY_VERSION}/site-packages/skytools/installer_config.pyc
 lib/python${MODPY_VERSION}/site-packages/skytools/natsort.py
@@ -132,6 +133,8 @@ lib/python${MODPY_VERSION}/site-packages
 lib/python${MODPY_VERSION}/site-packages/skytools/sqltools.pyc
 lib/python${MODPY_VERSION}/site-packages/skytools/timeutil.py
 lib/python${MODPY_VERSION}/site-packages/skytools/timeutil.pyc
+lib/python${MODPY_VERSION}/site-packages/skytools/tnetstrings.py
+lib/python${MODPY_VERSION}/site-packages/skytools/tnetstrings.pyc
 lib/python${MODPY_VERSION}/site-packages/skytools/utf8.py
 lib/python${MODPY_VERSION}/site-packages/skytools/utf8.pyc
 @man man/man1/londiste3.1
@@ -179,31 +182,47 @@ share/postgresql/contrib/pgq_triggers.sq
 share/postgresql/contrib/txid.sql
 share/postgresql/contrib/uninstall_pgq.sql
 share/postgresql/extension/
-share/postgresql/extension/londiste--3.1--${MODPY_EGG_VERSION}.sql
-share/postgresql/extension/londiste--${MODPY_EGG_VERSION}.sql
-share/postgresql/extension/londiste--unpackaged--${MODPY_EGG_VERSION}.sql
+share/postgresql/extension/londiste--3.1--3.2.4.sql
+share/postgresql/extension/londiste--3.1.1--3.2.4.sql
+share/postgresql/extension/londiste--3.1.3--3.2.4.sql
+share/postgresql/extension/londiste--3.1.4--3.2.4.sql
+share/postgresql/extension/londiste--3.1.6--3.2.4.sql
+share/postgresql/extension/londiste--3.2--3.2.4.sql
+share/postgresql/extension/londiste--3.2.3--3.2.4.sql
+share/postgresql/extension/londiste--3.2.4.sql
+share/postgresql/extension/londiste--unpackaged--3.2.4.sql
 share/postgresql/extension/londiste.control
 share/postgresql/extension/pgq--3.1--${MODPY_EGG_VERSION}.sql
+share/postgresql/extension/pgq--3.1.1--${MODPY_EGG_VERSION}.sql
+share/postgresql/extension/pgq--3.1.2--${MODPY_EGG_VERSION}.sql
+share/postgresql/extension/pgq--3.1.3--${MODPY_EGG_VERSION}.sql
+share/postgresql/extension/pgq--3.1.6--${MODPY_EGG_VERSION}.sql
+share/postgresql/extension/pgq--3.2--${MODPY_EGG_VERSION}.sql
+share/postgresql/extension/pgq--3.2.3--${MODPY_EGG_VERSION}.sql
 share/postgresql/extension/pgq--${MODPY_EGG_VERSION}.sql
 share/postgresql/extension/pgq--unpackaged--${MODPY_EGG_VERSION}.sql
 share/postgresql/extension/pgq.control
-share/postgresql/extension/pgq_coop--3.1--${MODPY_EGG_VERSION}.sql
-share/postgresql/extension/pgq_coop--${MODPY_EGG_VERSION}.sql
-share/postgresql/extension/pgq_coop--unpackaged--${MODPY_EGG_VERSION}.sql
+share/postgresql/extension/pgq_coop--3.1--3.1.1.sql
+share/postgresql/extension/pgq_coop--3.1.1.sql
+share/postgresql/extension/pgq_coop--unpackaged--3.1.1.sql
 share/postgresql/extension/pgq_coop.control
 share/postgresql/extension/pgq_ext--3.1.sql
 share/postgresql/extension/pgq_ext--unpackaged--3.1.sql
 share/postgresql/extension/pgq_ext.control
-share/postgresql/extension/pgq_node--3.1.sql
-share/postgresql/extension/pgq_node--unpackaged--3.1.sql
+share/postgresql/extension/pgq_node--3.1--3.2.5.sql
+share/postgresql/extension/pgq_node--3.1.3--3.2.5.sql
+share/postgresql/extension/pgq_node--3.1.6--3.2.5.sql
+share/postgresql/extension/pgq_node--3.2--3.2.5.sql
+share/postgresql/extension/pgq_node--3.2.5.sql
+share/postgresql/extension/pgq_node--unpackaged--3.2.5.sql
 share/postgresql/extension/pgq_node.control
 share/skytools3/
-share/skytools3/extra/
-share/skytools3/extra/v3.0_pgq_core.sql
 share/skytools3/londiste.sql
 share/skytools3/londiste.upgrade.sql
+share/skytools3/londiste.upgrade_2.1_to_3.1.sql
 share/skytools3/pgq.sql
 share/skytools3/pgq.upgrade.sql
+share/skytools3/pgq.upgrade_2.1_to_3.0.sql
 share/skytools3/pgq_coop.sql
 share/skytools3/pgq_coop.upgrade.sql
 share/skytools3/pgq_ext.sql

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Christian Weisgerber
In reply to this post by Jeremy Evans-5
Jeremy Evans:

> Now that PostgreSQL 13.1 is out, I think we can consider upgrading to
> it.  The diff below was tested on amd64 on a partial bulk of the ports
> depending on PostgreSQL.
>
> Could we please have this tested in a bulk?

I ran this through a bulk build on amd64.  Two build failures were
attributable to it:

===> databases/postgresql-plr
pg_backend_support.c:120:13: error: use of undeclared identifier 'tag_hash'; did
 you mean 'time_hash'?
        ctl.hash = tag_hash;
                   ^~~~~~~~

===> databases/timescaledb
-- Compiling against PostgreSQL version 13.1
-- Configuring incomplete, errors occurred!
See also "/usr/obj/ports/timescaledb-1.7.4/build-amd64/CMakeFiles/CMakeOutput.log".
CMake Error at CMakeLists.txt:209 (message):
  TimescaleDB only supports PostgreSQL 9.6.3+, 10.2+, 11 or 12

--
Christian "naddy" Weisgerber                          [hidden email]

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Jeremy Evans-5
On 12/02 09:39, Christian Weisgerber wrote:

> Jeremy Evans:
>
> > Now that PostgreSQL 13.1 is out, I think we can consider upgrading to
> > it.  The diff below was tested on amd64 on a partial bulk of the ports
> > depending on PostgreSQL.
> >
> > Could we please have this tested in a bulk?
>
> I ran this through a bulk build on amd64.  Two build failures were
> attributable to it:

Thank you very much for you testing.  I'll try to make sure I catch
these issues next time.

> ===> databases/postgresql-plr
> pg_backend_support.c:120:13: error: use of undeclared identifier 'tag_hash'; did
>  you mean 'time_hash'?
>         ctl.hash = tag_hash;
>                    ^~~~~~~~

This is fixed by upgrading from plr 8.4 to 8.4.1.

> ===> databases/timescaledb
> -- Compiling against PostgreSQL version 13.1
> -- Configuring incomplete, errors occurred!
> See also "/usr/obj/ports/timescaledb-1.7.4/build-amd64/CMakeFiles/CMakeOutput.log".
> CMake Error at CMakeLists.txt:209 (message):
>   TimescaleDB only supports PostgreSQL 9.6.3+, 10.2+, 11 or 12

TimescaleDB's master branch still doesn't support PostgreSQL 13 (they
also dropped support for <11):
https://github.com/timescale/timescaledb/blob/master/CMakeLists.txt#L197

There is a work in progress pull request to add support, but it is
fairly large:
https://github.com/timescale/timescaledb/pull/2498

I think it's best if we mark TimescaleDB BROKEN, as I don't think it
should hold back the PostgreSQL upgrade.

Patch below with both fixes.  OKs for committing the PostgreSQL 13
update?

Thanks,
Jeremy

Index: databases/timescaledb/Makefile
===================================================================
RCS file: /cvs/ports/databases/timescaledb/Makefile,v
retrieving revision 1.1.1.1
diff -u -p -r1.1.1.1 Makefile
--- databases/timescaledb/Makefile 15 Nov 2020 09:12:13 -0000 1.1.1.1
+++ databases/timescaledb/Makefile 2 Dec 2020 20:53:33 -0000
@@ -1,5 +1,6 @@
 # $OpenBSD: Makefile,v 1.1.1.1 2020/11/15 09:12:13 denis Exp $
 
+BROKEN = Does not yet support PostgreSQL 13
 COMMENT = database designed to make SQL scalable for time-series data
 
 GH_ACCOUNT = timescale
Index: databases/postgresql-plr/Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql-plr/Makefile,v
retrieving revision 1.6
diff -u -p -r1.6 Makefile
--- databases/postgresql-plr/Makefile 6 Feb 2020 00:36:58 -0000 1.6
+++ databases/postgresql-plr/Makefile 2 Dec 2020 20:46:39 -0000
@@ -2,8 +2,8 @@
 
 COMMENT = R procedural language for PostgreSQL
 
-VERSION = 8.4
-DISTNAME = REL8_4
+VERSION = 8.4.1
+DISTNAME = REL8_4_1
 PKGNAME = postgresql-plr-${VERSION}
 
 CATEGORIES = databases
Index: databases/postgresql-plr/distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql-plr/distinfo,v
retrieving revision 1.3
diff -u -p -r1.3 distinfo
--- databases/postgresql-plr/distinfo 6 Feb 2020 00:36:58 -0000 1.3
+++ databases/postgresql-plr/distinfo 2 Dec 2020 20:46:44 -0000
@@ -1,2 +1,2 @@
-SHA256 (REL8_4.tar.gz) = v5w4IeY+IDsl8vrlzbdhBBb0q8y8ZSu3jp5oAHE4FjA=
-SIZE (REL8_4.tar.gz) = 264511
+SHA256 (REL8_4_1.tar.gz) = 3bbyA3EFtZ+d2mkw1Kme14kJXYll7G8PftW5Y6wCLgc=
+SIZE (REL8_4_1.tar.gz) = 265142
Index: databases/postgresql-plr/pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/postgresql-plr/pkg/PLIST,v
retrieving revision 1.3
diff -u -p -r1.3 PLIST
--- databases/postgresql-plr/pkg/PLIST 6 Feb 2020 00:36:59 -0000 1.3
+++ databases/postgresql-plr/pkg/PLIST 2 Dec 2020 20:47:56 -0000
@@ -1,6 +1,6 @@
 @comment $OpenBSD: PLIST,v 1.3 2020/02/06 00:36:59 jeremy Exp $
-lib/postgresql/plr.so
-share/postgresql/extension/plr--8.3.0.18--8.4.sql
-share/postgresql/extension/plr--8.4.sql
-share/postgresql/extension/plr--unpackaged--8.4.sql
+@so lib/postgresql/plr.so
+share/postgresql/extension/plr--8.4--8.4.1.sql
+share/postgresql/extension/plr--8.4.1.sql
+share/postgresql/extension/plr--unpackaged--8.4.1.sql
 share/postgresql/extension/plr.control

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Denis Fondras-3
On Wed, Dec 02, 2020 at 01:02:46PM -0800, Jeremy Evans wrote:

> On 12/02 09:39, Christian Weisgerber wrote:
> > Jeremy Evans:
> >
> > > Now that PostgreSQL 13.1 is out, I think we can consider upgrading to
> > > it.  The diff below was tested on amd64 on a partial bulk of the ports
> > > depending on PostgreSQL.
> > >
> > > Could we please have this tested in a bulk?
> >
> > I ran this through a bulk build on amd64.  Two build failures were
> > attributable to it:
>
> Thank you very much for you testing.  I'll try to make sure I catch
> these issues next time.
>
> > ===> databases/postgresql-plr
> > pg_backend_support.c:120:13: error: use of undeclared identifier 'tag_hash'; did
> >  you mean 'time_hash'?
> >         ctl.hash = tag_hash;
> >                    ^~~~~~~~
>
> This is fixed by upgrading from plr 8.4 to 8.4.1.
>
> > ===> databases/timescaledb
> > -- Compiling against PostgreSQL version 13.1
> > -- Configuring incomplete, errors occurred!
> > See also "/usr/obj/ports/timescaledb-1.7.4/build-amd64/CMakeFiles/CMakeOutput.log".
> > CMake Error at CMakeLists.txt:209 (message):
> >   TimescaleDB only supports PostgreSQL 9.6.3+, 10.2+, 11 or 12
>
> TimescaleDB's master branch still doesn't support PostgreSQL 13 (they
> also dropped support for <11):
> https://github.com/timescale/timescaledb/blob/master/CMakeLists.txt#L197
>
> There is a work in progress pull request to add support, but it is
> fairly large:
> https://github.com/timescale/timescaledb/pull/2498
>
> I think it's best if we mark TimescaleDB BROKEN, as I don't think it
> should hold back the PostgreSQL upgrade.
>

Fine with me.


> Patch below with both fixes.  OKs for committing the PostgreSQL 13
> update?
>
> Thanks,
> Jeremy
>
> Index: databases/timescaledb/Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/timescaledb/Makefile,v
> retrieving revision 1.1.1.1
> diff -u -p -r1.1.1.1 Makefile
> --- databases/timescaledb/Makefile 15 Nov 2020 09:12:13 -0000 1.1.1.1
> +++ databases/timescaledb/Makefile 2 Dec 2020 20:53:33 -0000
> @@ -1,5 +1,6 @@
>  # $OpenBSD: Makefile,v 1.1.1.1 2020/11/15 09:12:13 denis Exp $
>  
> +BROKEN = Does not yet support PostgreSQL 13
>  COMMENT = database designed to make SQL scalable for time-series data
>  
>  GH_ACCOUNT = timescale
> Index: databases/postgresql-plr/Makefile
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql-plr/Makefile,v
> retrieving revision 1.6
> diff -u -p -r1.6 Makefile
> --- databases/postgresql-plr/Makefile 6 Feb 2020 00:36:58 -0000 1.6
> +++ databases/postgresql-plr/Makefile 2 Dec 2020 20:46:39 -0000
> @@ -2,8 +2,8 @@
>  
>  COMMENT = R procedural language for PostgreSQL
>  
> -VERSION = 8.4
> -DISTNAME = REL8_4
> +VERSION = 8.4.1
> +DISTNAME = REL8_4_1
>  PKGNAME = postgresql-plr-${VERSION}
>  
>  CATEGORIES = databases
> Index: databases/postgresql-plr/distinfo
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql-plr/distinfo,v
> retrieving revision 1.3
> diff -u -p -r1.3 distinfo
> --- databases/postgresql-plr/distinfo 6 Feb 2020 00:36:58 -0000 1.3
> +++ databases/postgresql-plr/distinfo 2 Dec 2020 20:46:44 -0000
> @@ -1,2 +1,2 @@
> -SHA256 (REL8_4.tar.gz) = v5w4IeY+IDsl8vrlzbdhBBb0q8y8ZSu3jp5oAHE4FjA=
> -SIZE (REL8_4.tar.gz) = 264511
> +SHA256 (REL8_4_1.tar.gz) = 3bbyA3EFtZ+d2mkw1Kme14kJXYll7G8PftW5Y6wCLgc=
> +SIZE (REL8_4_1.tar.gz) = 265142
> Index: databases/postgresql-plr/pkg/PLIST
> ===================================================================
> RCS file: /cvs/ports/databases/postgresql-plr/pkg/PLIST,v
> retrieving revision 1.3
> diff -u -p -r1.3 PLIST
> --- databases/postgresql-plr/pkg/PLIST 6 Feb 2020 00:36:59 -0000 1.3
> +++ databases/postgresql-plr/pkg/PLIST 2 Dec 2020 20:47:56 -0000
> @@ -1,6 +1,6 @@
>  @comment $OpenBSD: PLIST,v 1.3 2020/02/06 00:36:59 jeremy Exp $
> -lib/postgresql/plr.so
> -share/postgresql/extension/plr--8.3.0.18--8.4.sql
> -share/postgresql/extension/plr--8.4.sql
> -share/postgresql/extension/plr--unpackaged--8.4.sql
> +@so lib/postgresql/plr.so
> +share/postgresql/extension/plr--8.4--8.4.1.sql
> +share/postgresql/extension/plr--8.4.1.sql
> +share/postgresql/extension/plr--unpackaged--8.4.1.sql
>  share/postgresql/extension/plr.control

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade / update to TimescaleDB 2.0.0

Denis Fondras
Le Wed, Dec 02, 2020 at 10:15:48PM +0100, Denis Fondras a écrit :

> > TimescaleDB's master branch still doesn't support PostgreSQL 13 (they
> > also dropped support for <11):
> > https://github.com/timescale/timescaledb/blob/master/CMakeLists.txt#L197
> >
> > There is a work in progress pull request to add support, but it is
> > fairly large:
> > https://github.com/timescale/timescaledb/pull/2498
> >
> > I think it's best if we mark TimescaleDB BROKEN, as I don't think it
> > should hold back the PostgreSQL upgrade.
> >
>

Here is the update to TimescaleDB 2.0.0 which supports PG13.

Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/timescaledb/Makefile,v
retrieving revision 1.1.1.1
diff -u -p -r1.1.1.1 Makefile
--- Makefile 15 Nov 2020 09:12:13 -0000 1.1.1.1
+++ Makefile 21 Dec 2020 19:09:30 -0000
@@ -4,7 +4,7 @@ COMMENT = database designed to make SQL
 
 GH_ACCOUNT = timescale
 GH_PROJECT = timescaledb
-GH_TAGNAME = 1.7.4
+GH_TAGNAME = 2.0.0
 
 CATEGORIES = databases
 HOMEPAGE = https://www.timescale.com/
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/timescaledb/distinfo,v
retrieving revision 1.1.1.1
diff -u -p -r1.1.1.1 distinfo
--- distinfo 15 Nov 2020 09:12:13 -0000 1.1.1.1
+++ distinfo 21 Dec 2020 19:09:30 -0000
@@ -1,2 +1,2 @@
-SHA256 (timescaledb-1.7.4.tar.gz) = 0LehU/8+AuzwM6hp7N9ChvhhDqdhQLqoSSj8OoAiPpk=
-SIZE (timescaledb-1.7.4.tar.gz) = 1974350
+SHA256 (timescaledb-2.0.0.tar.gz) = 906+u0Rh5Odyc2FVUcz5JQ+sC973vaz1yS7jpohNd4I=
+SIZE (timescaledb-2.0.0.tar.gz) = 2210230
Index: pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/timescaledb/pkg/PLIST,v
retrieving revision 1.1.1.1
diff -u -p -r1.1.1.1 PLIST
--- pkg/PLIST 15 Nov 2020 09:12:13 -0000 1.1.1.1
+++ pkg/PLIST 21 Dec 2020 19:09:30 -0000
@@ -1,50 +1,30 @@
 @comment $OpenBSD: PLIST,v 1.1.1.1 2020/11/15 09:12:13 denis Exp $
-@so lib/postgresql/timescaledb-1.7.4.so
+@so lib/postgresql/timescaledb-2.0.0.so
 @so lib/postgresql/timescaledb.so
 share/doc/pkg-readmes/${PKGSTEM}
-share/postgresql/extension/timescaledb--0.1.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.10.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.10.1--1.7.4.sql
-share/postgresql/extension/timescaledb--0.11.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.12.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.12.1--1.7.4.sql
-share/postgresql/extension/timescaledb--0.2.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.3.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.4.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.4.1--1.7.4.sql
-share/postgresql/extension/timescaledb--0.4.2--1.7.4.sql
-share/postgresql/extension/timescaledb--0.5.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.6.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.6.1--1.7.4.sql
-share/postgresql/extension/timescaledb--0.7.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.7.1--1.7.4.sql
-share/postgresql/extension/timescaledb--0.8.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.9.0--1.7.4.sql
-share/postgresql/extension/timescaledb--0.9.1--1.7.4.sql
-share/postgresql/extension/timescaledb--0.9.2--1.7.4.sql
-share/postgresql/extension/timescaledb--1.0.0--1.7.4.sql
-share/postgresql/extension/timescaledb--1.0.0-rc1--1.7.4.sql
-share/postgresql/extension/timescaledb--1.0.0-rc2--1.7.4.sql
-share/postgresql/extension/timescaledb--1.0.0-rc3--1.7.4.sql
-share/postgresql/extension/timescaledb--1.0.1--1.7.4.sql
-share/postgresql/extension/timescaledb--1.1.0--1.7.4.sql
-share/postgresql/extension/timescaledb--1.1.1--1.7.4.sql
-share/postgresql/extension/timescaledb--1.2.0--1.7.4.sql
-share/postgresql/extension/timescaledb--1.2.1--1.7.4.sql
-share/postgresql/extension/timescaledb--1.2.2--1.7.4.sql
-share/postgresql/extension/timescaledb--1.3.0--1.7.4.sql
-share/postgresql/extension/timescaledb--1.3.1--1.7.4.sql
-share/postgresql/extension/timescaledb--1.3.2--1.7.4.sql
-share/postgresql/extension/timescaledb--1.4.0--1.7.4.sql
-share/postgresql/extension/timescaledb--1.4.1--1.7.4.sql
-share/postgresql/extension/timescaledb--1.4.2--1.7.4.sql
-share/postgresql/extension/timescaledb--1.5.0--1.7.4.sql
-share/postgresql/extension/timescaledb--1.5.1--1.7.4.sql
-share/postgresql/extension/timescaledb--1.6.0--1.7.4.sql
-share/postgresql/extension/timescaledb--1.6.1--1.7.4.sql
-share/postgresql/extension/timescaledb--1.7.0--1.7.4.sql
-share/postgresql/extension/timescaledb--1.7.1--1.7.4.sql
-share/postgresql/extension/timescaledb--1.7.2--1.7.4.sql
-share/postgresql/extension/timescaledb--1.7.3--1.7.4.sql
-share/postgresql/extension/timescaledb--1.7.4.sql
+share/postgresql/extension/timescaledb--1.1.0--2.0.0.sql
+share/postgresql/extension/timescaledb--1.1.1--2.0.0.sql
+share/postgresql/extension/timescaledb--1.2.0--2.0.0.sql
+share/postgresql/extension/timescaledb--1.2.1--2.0.0.sql
+share/postgresql/extension/timescaledb--1.2.2--2.0.0.sql
+share/postgresql/extension/timescaledb--1.3.0--2.0.0.sql
+share/postgresql/extension/timescaledb--1.3.1--2.0.0.sql
+share/postgresql/extension/timescaledb--1.3.2--2.0.0.sql
+share/postgresql/extension/timescaledb--1.4.0--2.0.0.sql
+share/postgresql/extension/timescaledb--1.4.1--2.0.0.sql
+share/postgresql/extension/timescaledb--1.4.2--2.0.0.sql
+share/postgresql/extension/timescaledb--1.5.0--2.0.0.sql
+share/postgresql/extension/timescaledb--1.5.1--2.0.0.sql
+share/postgresql/extension/timescaledb--1.6.0--2.0.0.sql
+share/postgresql/extension/timescaledb--1.6.1--2.0.0.sql
+share/postgresql/extension/timescaledb--1.7.0--2.0.0.sql
+share/postgresql/extension/timescaledb--1.7.1--2.0.0.sql
+share/postgresql/extension/timescaledb--1.7.2--2.0.0.sql
+share/postgresql/extension/timescaledb--1.7.3--2.0.0.sql
+share/postgresql/extension/timescaledb--1.7.4--2.0.0.sql
+share/postgresql/extension/timescaledb--2.0.0-rc1--2.0.0.sql
+share/postgresql/extension/timescaledb--2.0.0-rc2--2.0.0.sql
+share/postgresql/extension/timescaledb--2.0.0-rc3--2.0.0.sql
+share/postgresql/extension/timescaledb--2.0.0-rc4--2.0.0.sql
+share/postgresql/extension/timescaledb--2.0.0.sql
 share/postgresql/extension/timescaledb.control

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Daniel Jakots-6
In reply to this post by Jeremy Evans-5
On Fri, 20 Nov 2020 17:06:13 -0800, Jeremy Evans <[hidden email]>
wrote:

> Could we please have this tested in a bulk?  Assuming there are no
> problems in a bulk, OKs?

Thanks for the diff!
I updated my server to it. It works fine for me.

There is:
/usr/ports/databases/postgresql$ make port-lib-depends-check

postgresql-client-13.1(databases/postgresql,-main):
Extra:  iconv.7 lzma.2

postgresql-server-13.1(databases/postgresql,-server):
Extra:  iconv.7 lzma.2

postgresql-contrib-13.1(databases/postgresql,-contrib):
Extra:  iconv.7 lzma.2

postgresql-pg_upgrade-13.1(databases/postgresql,-pg_upgrade):
Extra:  iconv.7 lzma.2

postgresql-plpython-13.1(databases/postgresql,-plpython):
Missing: intl.7 from gettext-runtime-0.21p0
(/usr/local/lib/postgresql/plpython2.so) WANTLIB +=       intl
*** Error 1 in target 'port-lib-depends-check' (ignored)


I haven't checked if the current 12.5 does the same or not, and I'm too
lazy to move my ports tree back to it to check (when do we switch to
got(1)?? :P).


Also it seems the current maintainer is very busy/unresponsive so
maybe it would make sense if you took maintainership?


Cheers,
Daniel

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Pierre-Emmanuel André-2
On Mon, Jan 25, 2021 at 08:43:26PM -0500, Daniel Jakots wrote:

> On Fri, 20 Nov 2020 17:06:13 -0800, Jeremy Evans <[hidden email]>
> wrote:
>
> > Could we please have this tested in a bulk?  Assuming there are no
> > problems in a bulk, OKs?
>
> Thanks for the diff!
> I updated my server to it. It works fine for me.
>
> There is:
> /usr/ports/databases/postgresql$ make port-lib-depends-check
>
> postgresql-client-13.1(databases/postgresql,-main):
> Extra:  iconv.7 lzma.2
>
> postgresql-server-13.1(databases/postgresql,-server):
> Extra:  iconv.7 lzma.2
>
> postgresql-contrib-13.1(databases/postgresql,-contrib):
> Extra:  iconv.7 lzma.2
>
> postgresql-pg_upgrade-13.1(databases/postgresql,-pg_upgrade):
> Extra:  iconv.7 lzma.2
>
> postgresql-plpython-13.1(databases/postgresql,-plpython):
> Missing: intl.7 from gettext-runtime-0.21p0
> (/usr/local/lib/postgresql/plpython2.so) WANTLIB +=       intl
> *** Error 1 in target 'port-lib-depends-check' (ignored)
>
>
> I haven't checked if the current 12.5 does the same or not, and I'm too
> lazy to move my ports tree back to it to check (when do we switch to
> got(1)?? :P).
>
>
> Also it seems the current maintainer is very busy/unresponsive so
> maybe it would make sense if you took maintainership?
>
>
> Cheers,
> Daniel



Hello,

Sorry for the late answer. It took me a long time to upgrade my biggest system to pg13.
The diff looks good for me but i have some random failures on regress tests.
Sometimes on regproc or another times on prepared_xacts.
You never saw that ?

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Pierre-Emmanuel André-2
On Tue, Jan 26, 2021 at 09:20:55AM +0100, Pierre-Emmanuel André wrote:

> On Mon, Jan 25, 2021 at 08:43:26PM -0500, Daniel Jakots wrote:
> > On Fri, 20 Nov 2020 17:06:13 -0800, Jeremy Evans <[hidden email]>
> > wrote:
> >
> > > Could we please have this tested in a bulk?  Assuming there are no
> > > problems in a bulk, OKs?
> >
> > Thanks for the diff!
> > I updated my server to it. It works fine for me.
> >
> > There is:
> > /usr/ports/databases/postgresql$ make port-lib-depends-check
> >
> > postgresql-client-13.1(databases/postgresql,-main):
> > Extra:  iconv.7 lzma.2
> >
> > postgresql-server-13.1(databases/postgresql,-server):
> > Extra:  iconv.7 lzma.2
> >
> > postgresql-contrib-13.1(databases/postgresql,-contrib):
> > Extra:  iconv.7 lzma.2
> >
> > postgresql-pg_upgrade-13.1(databases/postgresql,-pg_upgrade):
> > Extra:  iconv.7 lzma.2
> >
> > postgresql-plpython-13.1(databases/postgresql,-plpython):
> > Missing: intl.7 from gettext-runtime-0.21p0
> > (/usr/local/lib/postgresql/plpython2.so) WANTLIB +=       intl
> > *** Error 1 in target 'port-lib-depends-check' (ignored)
> >
> >
> > I haven't checked if the current 12.5 does the same or not, and I'm too
> > lazy to move my ports tree back to it to check (when do we switch to
> > got(1)?? :P).
> >
> >
> > Also it seems the current maintainer is very busy/unresponsive so
> > maybe it would make sense if you took maintainership?
> >
> >
> > Cheers,
> > Daniel
>
>
>
> Hello,
>
> Sorry for the late answer. It took me a long time to upgrade my biggest system to pg13.
> The diff looks good for me but i have some random failures on regress tests.
> Sometimes on regproc or another times on prepared_xacts.
> You never saw that ?
>


Nevermind it was a local issue.
I made this small change to database/postgresql/Makefile to fix WANTLIB:

@@ -99,7 +98,7 @@ INSTALL_TARGET=       install-world
 LIB_DEPENDS-main=      archivers/xz \
                        converters/libiconv \
                        textproc/libxml
-WANTLIB-main = ${WANTLIB} iconv lzma xml2
+WANTLIB-main = ${WANTLIB} xml2
 
 
 LIB_DEPENDS-server= databases/postgresql=${VERSION} \
@@ -119,7 +118,7 @@ LIB_DEPENDS-pg_upgrade= databases/postgr
 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}
 

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Daniel Jakots-6
On Tue, 26 Jan 2021 11:03:25 +0100, Pierre-Emmanuel André
<[hidden email]> wrote:

> I made this small change to database/postgresql/Makefile to fix
> WANTLIB:
>
> @@ -99,7 +98,7 @@ INSTALL_TARGET=       install-world
>  LIB_DEPENDS-main=      archivers/xz \
>                         converters/libiconv \
>                         textproc/libxml
> -WANTLIB-main = ${WANTLIB} iconv lzma xml2
> +WANTLIB-main = ${WANTLIB} xml2
>  
>  
>  LIB_DEPENDS-server= databases/postgresql=${VERSION} \
> @@ -119,7 +118,7 @@ LIB_DEPENDS-pg_upgrade= databases/postgr
>  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}

That solves it, thanks!

ok danj@ for the whole thing.

Cheers,
Daniel

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Daniel Jakots-6
Hi Pierre-Emmanuel and Jeremy,

Is there anything blocking the update?

Cheers,
Daniel

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Jeremy Evans-5
On 02/01 07:24, Daniel Jakots wrote:
> Hi Pierre-Emmanuel and Jeremy,
>
> Is there anything blocking the update?

Nothing for me.  pea@ can handle the commits whenever he sees fit, or if
he gives his OK, I can handle the commits.

Thanks,
Jeremy

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Pierre-Emmanuel André-2
On Mon, Feb 01, 2021 at 05:00:41PM -0800, Jeremy Evans wrote:
> On 02/01 07:24, Daniel Jakots wrote:
> > Hi Pierre-Emmanuel and Jeremy,
> >
> > Is there anything blocking the update?
>
> Nothing for me.  pea@ can handle the commits whenever he sees fit, or if
> he gives his OK, I can handle the commits.
>

I will not be able to commit before this week end. If you can do it before, go ahead.
ok pea@

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Stuart Henderson
On 2021/02/03 21:22, Pierre-Emmanuel Andr?? wrote:

> On Mon, Feb 01, 2021 at 05:00:41PM -0800, Jeremy Evans wrote:
> > On 02/01 07:24, Daniel Jakots wrote:
> > > Hi Pierre-Emmanuel and Jeremy,
> > >
> > > Is there anything blocking the update?
> >
> > Nothing for me.  pea@ can handle the commits whenever he sees fit, or if
> > he gives his OK, I can handle the commits.
> >
>
> I will not be able to commit before this week end. If you can do it before, go ahead.
> ok pea@
>

What do you think about adding this to it?


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 09:31:59 -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

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Pierre-Emmanuel André-2
On Thu, Feb 04, 2021 at 09:33:48AM +0000, Stuart Henderson wrote:

> On 2021/02/03 21:22, Pierre-Emmanuel Andr?? wrote:
> > On Mon, Feb 01, 2021 at 05:00:41PM -0800, Jeremy Evans wrote:
> > > On 02/01 07:24, Daniel Jakots wrote:
> > > > Hi Pierre-Emmanuel and Jeremy,
> > > >
> > > > Is there anything blocking the update?
> > >
> > > Nothing for me.  pea@ can handle the commits whenever he sees fit, or if
> > > he gives his OK, I can handle the commits.
> > >
> >
> > I will not be able to commit before this week end. If you can do it before, go ahead.
> > ok pea@
> >
>
> What do you think about adding this to it?
>
>
> 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 09:31:59 -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


yes ok pea@

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Stuart Henderson
> >  @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 <[hidden email]>
 
@@ -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

Reply | Threaded
Open this post in threaded view
|

Re: PostgreSQL 13.1 Upgrade

Pierre-Emmanuel André-2
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 <[hidden email]>
>  
> @@ -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
>

Reply | Threaded
Open this post in threaded view
|

Update to TimescaleDB 2.1.0

Denis Fondras
In reply to this post by Denis Fondras-3
Here is the update to TimescaleDB 2.1.0 which supports PG13.2

Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/timescaledb/Makefile,v
retrieving revision 1.2
diff -u -p -r1.2 Makefile
--- Makefile 9 Feb 2021 20:05:15 -0000 1.2
+++ Makefile 5 Apr 2021 13:48:15 -0000
@@ -1,11 +1,10 @@
 # $OpenBSD: Makefile,v 1.2 2021/02/09 20:05:15 jeremy Exp $
 
-BROKEN = doesn't yet work with PostgreSQL 13
 COMMENT = database designed to make SQL scalable for time-series data
 
 GH_ACCOUNT = timescale
 GH_PROJECT = timescaledb
-GH_TAGNAME = 2.0.0
+GH_TAGNAME = 2.1.0
 
 CATEGORIES = databases
 HOMEPAGE = https://www.timescale.com/
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/timescaledb/distinfo,v
retrieving revision 1.2
diff -u -p -r1.2 distinfo
--- distinfo 9 Feb 2021 20:05:15 -0000 1.2
+++ distinfo 5 Apr 2021 13:48:15 -0000
@@ -1,2 +1,2 @@
-SHA256 (timescaledb-2.0.0.tar.gz) = 906+u0Rh5Odyc2FVUcz5JQ+sC973vaz1yS7jpohNd4I=
-SIZE (timescaledb-2.0.0.tar.gz) = 2210230
+SHA256 (timescaledb-2.1.0.tar.gz) = beKvLs/Xv/mzY0tsXCmyCbJeFHhY1GBGno64jm0ZhpI=
+SIZE (timescaledb-2.1.0.tar.gz) = 2527250
Index: pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/timescaledb/pkg/PLIST,v
retrieving revision 1.2
diff -u -p -r1.2 PLIST
--- pkg/PLIST 9 Feb 2021 20:05:15 -0000 1.2
+++ pkg/PLIST 5 Apr 2021 13:48:15 -0000
@@ -1,30 +1,34 @@
 @comment $OpenBSD: PLIST,v 1.2 2021/02/09 20:05:15 jeremy Exp $
-@so lib/postgresql/timescaledb-2.0.0.so
+@so lib/postgresql/timescaledb-2.1.0.so
 @so lib/postgresql/timescaledb.so
 share/doc/pkg-readmes/${PKGSTEM}
-share/postgresql/extension/timescaledb--1.1.0--2.0.0.sql
-share/postgresql/extension/timescaledb--1.1.1--2.0.0.sql
-share/postgresql/extension/timescaledb--1.2.0--2.0.0.sql
-share/postgresql/extension/timescaledb--1.2.1--2.0.0.sql
-share/postgresql/extension/timescaledb--1.2.2--2.0.0.sql
-share/postgresql/extension/timescaledb--1.3.0--2.0.0.sql
-share/postgresql/extension/timescaledb--1.3.1--2.0.0.sql
-share/postgresql/extension/timescaledb--1.3.2--2.0.0.sql
-share/postgresql/extension/timescaledb--1.4.0--2.0.0.sql
-share/postgresql/extension/timescaledb--1.4.1--2.0.0.sql
-share/postgresql/extension/timescaledb--1.4.2--2.0.0.sql
-share/postgresql/extension/timescaledb--1.5.0--2.0.0.sql
-share/postgresql/extension/timescaledb--1.5.1--2.0.0.sql
-share/postgresql/extension/timescaledb--1.6.0--2.0.0.sql
-share/postgresql/extension/timescaledb--1.6.1--2.0.0.sql
-share/postgresql/extension/timescaledb--1.7.0--2.0.0.sql
-share/postgresql/extension/timescaledb--1.7.1--2.0.0.sql
-share/postgresql/extension/timescaledb--1.7.2--2.0.0.sql
-share/postgresql/extension/timescaledb--1.7.3--2.0.0.sql
-share/postgresql/extension/timescaledb--1.7.4--2.0.0.sql
-share/postgresql/extension/timescaledb--2.0.0-rc1--2.0.0.sql
-share/postgresql/extension/timescaledb--2.0.0-rc2--2.0.0.sql
-share/postgresql/extension/timescaledb--2.0.0-rc3--2.0.0.sql
-share/postgresql/extension/timescaledb--2.0.0-rc4--2.0.0.sql
-share/postgresql/extension/timescaledb--2.0.0.sql
+share/postgresql/extension/timescaledb--1.1.0--2.1.0.sql
+share/postgresql/extension/timescaledb--1.1.1--2.1.0.sql
+share/postgresql/extension/timescaledb--1.2.0--2.1.0.sql
+share/postgresql/extension/timescaledb--1.2.1--2.1.0.sql
+share/postgresql/extension/timescaledb--1.2.2--2.1.0.sql
+share/postgresql/extension/timescaledb--1.3.0--2.1.0.sql
+share/postgresql/extension/timescaledb--1.3.1--2.1.0.sql
+share/postgresql/extension/timescaledb--1.3.2--2.1.0.sql
+share/postgresql/extension/timescaledb--1.4.0--2.1.0.sql
+share/postgresql/extension/timescaledb--1.4.1--2.1.0.sql
+share/postgresql/extension/timescaledb--1.4.2--2.1.0.sql
+share/postgresql/extension/timescaledb--1.5.0--2.1.0.sql
+share/postgresql/extension/timescaledb--1.5.1--2.1.0.sql
+share/postgresql/extension/timescaledb--1.6.0--2.1.0.sql
+share/postgresql/extension/timescaledb--1.6.1--2.1.0.sql
+share/postgresql/extension/timescaledb--1.7.0--2.1.0.sql
+share/postgresql/extension/timescaledb--1.7.1--2.1.0.sql
+share/postgresql/extension/timescaledb--1.7.2--2.1.0.sql
+share/postgresql/extension/timescaledb--1.7.3--2.1.0.sql
+share/postgresql/extension/timescaledb--1.7.4--2.1.0.sql
+share/postgresql/extension/timescaledb--1.7.5--2.1.0.sql
+share/postgresql/extension/timescaledb--2.0.0--2.1.0.sql
+share/postgresql/extension/timescaledb--2.0.0-rc1--2.1.0.sql
+share/postgresql/extension/timescaledb--2.0.0-rc2--2.1.0.sql
+share/postgresql/extension/timescaledb--2.0.0-rc3--2.1.0.sql
+share/postgresql/extension/timescaledb--2.0.0-rc4--2.1.0.sql
+share/postgresql/extension/timescaledb--2.0.1--2.1.0.sql
+share/postgresql/extension/timescaledb--2.0.2--2.1.0.sql
+share/postgresql/extension/timescaledb--2.1.0.sql
 share/postgresql/extension/timescaledb.control

Reply | Threaded
Open this post in threaded view
|

databases/timescaledb: update to 2.2.0

Denis Fondras
In reply to this post by Denis Fondras-3
Update to TimescaleDB 2.2.0

https://github.com/timescale/timescaledb/compare/2.1.1...2.2.0

Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/timescaledb/Makefile,v
retrieving revision 1.3
diff -u -p -r1.3 Makefile
--- Makefile 6 Apr 2021 07:22:39 -0000 1.3
+++ Makefile 13 Apr 2021 14:48:34 -0000
@@ -4,7 +4,7 @@ COMMENT = database designed to make SQL
 
 GH_ACCOUNT = timescale
 GH_PROJECT = timescaledb
-GH_TAGNAME = 2.1.0
+GH_TAGNAME = 2.2.0
 
 CATEGORIES = databases
 HOMEPAGE = https://www.timescale.com/
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/timescaledb/distinfo,v
retrieving revision 1.3
diff -u -p -r1.3 distinfo
--- distinfo 6 Apr 2021 07:22:39 -0000 1.3
+++ distinfo 13 Apr 2021 14:48:34 -0000
@@ -1,2 +1,2 @@
-SHA256 (timescaledb-2.1.0.tar.gz) = beKvLs/Xv/mzY0tsXCmyCbJeFHhY1GBGno64jm0ZhpI=
-SIZE (timescaledb-2.1.0.tar.gz) = 2527250
+SHA256 (timescaledb-2.2.0.tar.gz) = I5oING/vHoZ00Glm0NaWN6kHLKMajW/de4rW8YTlSjk=
+SIZE (timescaledb-2.2.0.tar.gz) = 2614359
Index: pkg/PLIST
===================================================================
RCS file: /cvs/ports/databases/timescaledb/pkg/PLIST,v
retrieving revision 1.3
diff -u -p -r1.3 PLIST
--- pkg/PLIST 6 Apr 2021 07:22:39 -0000 1.3
+++ pkg/PLIST 13 Apr 2021 14:48:34 -0000
@@ -30,5 +30,7 @@ share/postgresql/extension/timescaledb--
 share/postgresql/extension/timescaledb--2.0.0-rc4--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.0.1--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--2.0.2--${GH_TAGNAME}.sql
+share/postgresql/extension/timescaledb--2.1.0--${GH_TAGNAME}.sql
+share/postgresql/extension/timescaledb--2.1.1--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb--${GH_TAGNAME}.sql
 share/postgresql/extension/timescaledb.control