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"
