On 10/20 11:23, Theo Buehler wrote: > On Thu, Oct 13, 2022 at 06:07:51PM +0000, Jeremy Evans wrote: > > When I have time, I'll run a partial bulk of the PostgreSQL ports and > > try to fix any breakage. Hopefully I can complete that work by the > > release of PostgreSQL 15.1. > > There were three build failures: posgresql-pllua, repmgr, timescaledb. > Details below. > > Given the non-trivial changes that are/were required in these consumers, > I would not be surprised by a variety of runtime fallout. > > > databases/postgresql-pllua > -------------------------- > > Constrains on postgresql-client->=14,<15, postgresql-server->=14,<15. > Builds fine when bumping upper bounds to 16. > > See this, however: https://github.com/pllua/pllua/issues/10 > > > databases/repmgr > ---------------- > > repmgr-client.c:185:39: error: incomplete definition of type 'struct passwd' > strncpy(runtime_options.username, pw->pw_name, MAXLEN); > ~~^ > > postgresql/server/port.h no longer pulls in pwd.h. To fix build, > patching #include <pwd.h> into repmgr-client.c is enough. > > Upstream support for PostgreSQL 15 is only available from version 5.3.3 > https://repmgr.org/docs/current/release-5.3.3.html > This includes various 15-specific fixes (some relating to shared memory). > > > databases/timescaledb > --------------------- > > CMake Error at CMakeLists.txt:362 (message): > TimescaleDB only supports PostgreSQL 12, 13 and 14 > > This is still the case with the latest timescaledb 2.8.1 and they still > seem to be sorting out fallout in the 2.9 branch.
PostgreSQL 15.1 was released recently: https://www.postgresql.org/about/news/postgresql-151-146-139-1213-1118-and-1023-released-2543/ Here's an updated diff with the following changes: * postgresql: 14.5 -> 15.1 * postgresql-previous: 13.5 -> 14.6 * postgresql-pllua: Use upstream pull request for PG 15 support and bump * repmgr: 5.2.1 -> 5.3.3 * timescaledb: Mark BROKEN until release with PostgreSQL 15 support Can someone please put this into a bulk? Assuming no build fallout, I'd like to commit this, so I'm also looking for OKs. It's a good point in the release cycle for the switch, and will give us a few months to potentially discover and fix any runtime issues. No security issues in the PostgreSQL release, so I'm not planning on updating 7.2 -stable to 14.6 unless someone requests it. Thanks, Jeremy Index: databases/postgresql/Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.290 diff -u -p -r1.290 Makefile --- databases/postgresql/Makefile 8 Nov 2022 11:14:46 -0000 1.290 +++ databases/postgresql/Makefile 12 Nov 2022 08:07:53 -0000 @@ -4,17 +4,11 @@ COMMENT-docs= PostgreSQL RDBMS documenta COMMENT-contrib=PostgreSQL RDBMS contributions COMMENT-plpython=Python procedural language for PostgreSQL COMMENT-pg_upgrade=Support for upgrading PostgreSQL data from previous version -REVISION-contrib= 0 -REVISION-docs= 0 -REVISION-pg_upgrade= 0 -REVISION-plpython= 0 -REVISION-server=0 -VERSION= 14.5 -PREV_MAJOR= 13 +VERSION= 15.1 +PREV_MAJOR= 14 DISTNAME= postgresql-${VERSION} PKGNAME-main= postgresql-client-${VERSION} -REVISION-main= 0 DPB_PROPERTIES= parallel @@ -22,7 +16,7 @@ CATEGORIES= databases SHARED_LIBS= ecpg 7.10 \ ecpg_compat 4.10 \ pgtypes 4.9 \ - pq 6.13 + pq 6.14 HOMEPAGE= https://www.postgresql.org/ Index: databases/postgresql/distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql/distinfo,v retrieving revision 1.94 diff -u -p -r1.94 distinfo --- databases/postgresql/distinfo 15 Aug 2022 18:07:16 -0000 1.94 +++ databases/postgresql/distinfo 12 Nov 2022 08:09:45 -0000 @@ -1,2 +1,2 @@ -SHA256 (postgresql-14.5.tar.gz) = kOrTk9vGVMsAdeqvDsIFjmuYZs7UeP7TzytopbwE6yQ= -SIZE (postgresql-14.5.tar.gz) = 28988974 +SHA256 (postgresql-15.1.tar.gz) = 6izwWahYgmVLmJrNB+3BIYMxZKMDQPruDTYVz3BY5mw= +SIZE (postgresql-15.1.tar.gz) = 29778341 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.5 diff -u -p -r1.5 patch-src_bin_scripts_vacuumdb_c --- databases/postgresql/patches/patch-src_bin_scripts_vacuumdb_c 11 Mar 2022 18:31:37 -0000 1.5 +++ databases/postgresql/patches/patch-src_bin_scripts_vacuumdb_c 23 May 2022 20:11:09 -0000 @@ -9,4 +9,4 @@ Index: src/bin/scripts/vacuumdb.c + #include "postgres_fe.h" - #include "catalog/pg_class_d.h" + #include <limits.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.9 diff -u -p -r1.9 patch-src_include_storage_s_lock_h --- databases/postgresql/patches/patch-src_include_storage_s_lock_h 14 May 2022 17:51:55 -0000 1.9 +++ databases/postgresql/patches/patch-src_include_storage_s_lock_h 12 Nov 2022 08:10:42 -0000 @@ -1,7 +1,7 @@ Index: src/include/storage/s_lock.h --- src/include/storage/s_lock.h.orig +++ src/include/storage/s_lock.h -@@ -763,6 +763,29 @@ typedef unsigned char slock_t; +@@ -802,6 +802,29 @@ tas(volatile slock_t *lock) 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.16 diff -u -p -r1.16 patch-src_interfaces_libpq_Makefile --- databases/postgresql/patches/patch-src_interfaces_libpq_Makefile 11 Mar 2022 18:31:37 -0000 1.16 +++ databases/postgresql/patches/patch-src_interfaces_libpq_Makefile 23 May 2022 20:11:09 -0000 @@ -1,7 +1,7 @@ Index: src/interfaces/libpq/Makefile --- src/interfaces/libpq/Makefile.orig +++ src/interfaces/libpq/Makefile -@@ -18,8 +18,8 @@ PGFILEDESC = "PostgreSQL Access Library" +@@ -19,8 +19,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.24 diff -u -p -r1.24 PLIST-contrib --- databases/postgresql/pkg/PLIST-contrib 11 Mar 2022 18:31:37 -0000 1.24 +++ databases/postgresql/pkg/PLIST-contrib 1 Jul 2022 16:31:57 -0000 @@ -14,6 +14,8 @@ @so lib/postgresql/auth_delay.so @so lib/postgresql/auto_explain.so @so lib/postgresql/autoinc.so +@so lib/postgresql/basebackup_to_shell.so +@so lib/postgresql/basic_archive.so @so lib/postgresql/bloom.so @so lib/postgresql/bool_plperl.so @so lib/postgresql/btree_gin.so @@ -41,6 +43,7 @@ @so lib/postgresql/pg_surgery.so @so lib/postgresql/pg_trgm.so @so lib/postgresql/pg_visibility.so +@so lib/postgresql/pg_walinspect.so @so lib/postgresql/pgcrypto.so @so lib/postgresql/pgrowlocks.so @so lib/postgresql/pgstattuple.so @@ -92,6 +95,7 @@ share/postgresql/extension/btree_gist--1 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--1.5--1.6.sql +share/postgresql/extension/btree_gist--1.6--1.7.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 @@ -178,6 +182,7 @@ share/postgresql/extension/pageinspect-- share/postgresql/extension/pageinspect--1.6--1.7.sql share/postgresql/extension/pageinspect--1.7--1.8.sql share/postgresql/extension/pageinspect--1.8--1.9.sql +share/postgresql/extension/pageinspect--1.9--1.10.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 @@ -202,6 +207,7 @@ share/postgresql/extension/pg_stat_state 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--1.8--1.9.sql +share/postgresql/extension/pg_stat_statements--1.9--1.10.sql share/postgresql/extension/pg_stat_statements.control share/postgresql/extension/pg_surgery--1.0.sql share/postgresql/extension/pg_surgery.control @@ -217,6 +223,8 @@ share/postgresql/extension/pg_visibility share/postgresql/extension/pg_visibility--1.1--1.2.sql share/postgresql/extension/pg_visibility--1.1.sql share/postgresql/extension/pg_visibility.control +share/postgresql/extension/pg_walinspect--1.0.sql +share/postgresql/extension/pg_walinspect.control share/postgresql/extension/pgcrypto--1.0--1.1.sql share/postgresql/extension/pgcrypto--1.1--1.2.sql share/postgresql/extension/pgcrypto--1.2--1.3.sql Index: databases/postgresql/pkg/PLIST-docs =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v retrieving revision 1.107 diff -u -p -r1.107 PLIST-docs --- databases/postgresql/pkg/PLIST-docs 15 Aug 2022 18:07:16 -0000 1.107 +++ databases/postgresql/pkg/PLIST-docs 12 Nov 2022 08:20:53 -0000 @@ -46,6 +46,9 @@ share/doc/postgresql/html/app-vacuumdb.h share/doc/postgresql/html/appendix-obsolete.html share/doc/postgresql/html/appendixes.html share/doc/postgresql/html/applevel-consistency.html +share/doc/postgresql/html/archive-module-callbacks.html +share/doc/postgresql/html/archive-module-init.html +share/doc/postgresql/html/archive-modules.html share/doc/postgresql/html/arrays.html share/doc/postgresql/html/auth-bsd.html share/doc/postgresql/html/auth-cert.html @@ -68,6 +71,8 @@ share/doc/postgresql/html/backup-manifes 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/basebackup-to-shell.html +share/doc/postgresql/html/basic-archive.html share/doc/postgresql/html/bgworker.html share/doc/postgresql/html/biblio.html share/doc/postgresql/html/bki-commands.html @@ -123,9 +128,11 @@ share/doc/postgresql/html/catalog-pg-nam share/doc/postgresql/html/catalog-pg-opclass.html share/doc/postgresql/html/catalog-pg-operator.html share/doc/postgresql/html/catalog-pg-opfamily.html +share/doc/postgresql/html/catalog-pg-parameter-acl.html share/doc/postgresql/html/catalog-pg-partitioned-table.html share/doc/postgresql/html/catalog-pg-policy.html share/doc/postgresql/html/catalog-pg-proc.html +share/doc/postgresql/html/catalog-pg-publication-namespace.html share/doc/postgresql/html/catalog-pg-publication-rel.html share/doc/postgresql/html/catalog-pg-publication.html share/doc/postgresql/html/catalog-pg-range.html @@ -192,6 +199,7 @@ share/doc/postgresql/html/contrib-spi.ht share/doc/postgresql/html/contrib.html share/doc/postgresql/html/creating-cluster.html share/doc/postgresql/html/cube.html +share/doc/postgresql/html/custom-rmgr.html share/doc/postgresql/html/custom-scan-execution.html share/doc/postgresql/html/custom-scan-path.html share/doc/postgresql/html/custom-scan-plan.html @@ -539,12 +547,14 @@ share/doc/postgresql/html/locale.html share/doc/postgresql/html/locking-indexes.html share/doc/postgresql/html/logfile-maintenance.html share/doc/postgresql/html/logical-replication-architecture.html +share/doc/postgresql/html/logical-replication-col-lists.html share/doc/postgresql/html/logical-replication-config.html share/doc/postgresql/html/logical-replication-conflicts.html share/doc/postgresql/html/logical-replication-monitoring.html share/doc/postgresql/html/logical-replication-publication.html share/doc/postgresql/html/logical-replication-quick-setup.html share/doc/postgresql/html/logical-replication-restrictions.html +share/doc/postgresql/html/logical-replication-row-filter.html share/doc/postgresql/html/logical-replication-security.html share/doc/postgresql/html/logical-replication-subscription.html share/doc/postgresql/html/logical-replication.html @@ -576,6 +586,7 @@ share/doc/postgresql/html/multibyte.html share/doc/postgresql/html/multivariate-statistics-examples.html share/doc/postgresql/html/mvcc-caveats.html share/doc/postgresql/html/mvcc-intro.html +share/doc/postgresql/html/mvcc-serialization-failure-handling.html share/doc/postgresql/html/mvcc.html share/doc/postgresql/html/nls-programmer.html share/doc/postgresql/html/nls-translator.html @@ -610,6 +621,7 @@ share/doc/postgresql/html/pgtrgm.html share/doc/postgresql/html/pgupgrade.html share/doc/postgresql/html/pgvisibility.html share/doc/postgresql/html/pgwaldump.html +share/doc/postgresql/html/pgwalinspect.html share/doc/postgresql/html/pgxlogdump.html share/doc/postgresql/html/planner-optimizer.html share/doc/postgresql/html/planner-stats-details.html @@ -703,12 +715,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-14-1.html -share/doc/postgresql/html/release-14-2.html -share/doc/postgresql/html/release-14-3.html -share/doc/postgresql/html/release-14-4.html -share/doc/postgresql/html/release-14-5.html -share/doc/postgresql/html/release-14.html +share/doc/postgresql/html/release-15.html +share/doc/postgresql/html/release-15-1.html share/doc/postgresql/html/release-prior.html share/doc/postgresql/html/release.html share/doc/postgresql/html/replication-origins.html @@ -979,6 +987,7 @@ share/doc/postgresql/html/sql-keywords-a share/doc/postgresql/html/sql-listen.html share/doc/postgresql/html/sql-load.html share/doc/postgresql/html/sql-lock.html +share/doc/postgresql/html/sql-merge.html share/doc/postgresql/html/sql-move.html share/doc/postgresql/html/sql-notify.html share/doc/postgresql/html/sql-prepare-transaction.html @@ -1018,6 +1027,7 @@ share/doc/postgresql/html/sslinfo.html share/doc/postgresql/html/sspi-auth.html share/doc/postgresql/html/storage-file-layout.html share/doc/postgresql/html/storage-fsm.html +share/doc/postgresql/html/storage-hot.html share/doc/postgresql/html/storage-init.html share/doc/postgresql/html/storage-page-layout.html share/doc/postgresql/html/storage-toast.html @@ -1099,6 +1109,7 @@ share/doc/postgresql/html/view-pg-cursor share/doc/postgresql/html/view-pg-file-settings.html share/doc/postgresql/html/view-pg-group.html share/doc/postgresql/html/view-pg-hba-file-rules.html +share/doc/postgresql/html/view-pg-ident-file-mappings.html share/doc/postgresql/html/view-pg-indexes.html share/doc/postgresql/html/view-pg-locks.html share/doc/postgresql/html/view-pg-matviews.html @@ -1125,6 +1136,7 @@ share/doc/postgresql/html/view-pg-user-m share/doc/postgresql/html/view-pg-user.html share/doc/postgresql/html/view-pg-views.html share/doc/postgresql/html/views-overview.html +share/doc/postgresql/html/views.html share/doc/postgresql/html/wal-async-commit.html share/doc/postgresql/html/wal-configuration.html share/doc/postgresql/html/wal-internals.html Index: databases/postgresql/pkg/PLIST-main =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-main,v retrieving revision 1.35 diff -u -p -r1.35 PLIST-main --- databases/postgresql/pkg/PLIST-main 11 Mar 2022 18:31:37 -0000 1.35 +++ databases/postgresql/pkg/PLIST-main 23 May 2022 23:10:49 -0000 @@ -29,6 +29,7 @@ include/postgresql/informix/esql/decimal include/postgresql/informix/esql/sqltypes.h include/postgresql/internal/ include/postgresql/internal/c.h +include/postgresql/internal/fe-auth-sasl.h include/postgresql/internal/libpq/ include/postgresql/internal/libpq-int.h include/postgresql/internal/libpq/pqcomm.h @@ -337,6 +338,7 @@ lib/postgresql/pgxs/src/test/regress/ @man man/man7/LISTEN.7 @man man/man7/LOAD.7 @man man/man7/LOCK.7 +@man man/man7/MERGE.7 @man man/man7/MOVE.7 @man man/man7/NOTIFY.7 @man man/man7/PREPARE.7 Index: databases/postgresql/pkg/PLIST-plpython =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-plpython,v retrieving revision 1.12 diff -u -p -r1.12 PLIST-plpython --- databases/postgresql/pkg/PLIST-plpython 11 Mar 2022 18:31:37 -0000 1.12 +++ databases/postgresql/pkg/PLIST-plpython 23 May 2022 20:18:03 -0000 @@ -4,23 +4,11 @@ include/postgresql/server/plpython.h @so lib/postgresql/jsonb_plpython3.so @so lib/postgresql/ltree_plpython3.so @so lib/postgresql/plpython3.so -share/postgresql/extension/hstore_plpython2u--1.0.sql -share/postgresql/extension/hstore_plpython2u.control share/postgresql/extension/hstore_plpython3u--1.0.sql share/postgresql/extension/hstore_plpython3u.control -share/postgresql/extension/hstore_plpythonu--1.0.sql -share/postgresql/extension/hstore_plpythonu.control -share/postgresql/extension/jsonb_plpython2u--1.0.sql -share/postgresql/extension/jsonb_plpython2u.control share/postgresql/extension/jsonb_plpython3u--1.0.sql share/postgresql/extension/jsonb_plpython3u.control -share/postgresql/extension/jsonb_plpythonu--1.0.sql -share/postgresql/extension/jsonb_plpythonu.control -share/postgresql/extension/ltree_plpython2u--1.0.sql -share/postgresql/extension/ltree_plpython2u.control share/postgresql/extension/ltree_plpython3u--1.0.sql share/postgresql/extension/ltree_plpython3u.control -share/postgresql/extension/ltree_plpythonu--1.0.sql -share/postgresql/extension/ltree_plpythonu.control share/postgresql/extension/plpython3u--1.0.sql share/postgresql/extension/plpython3u.control Index: databases/postgresql/pkg/PLIST-server =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v retrieving revision 1.47 diff -u -p -r1.47 PLIST-server --- databases/postgresql/pkg/PLIST-server 8 Nov 2022 11:14:46 -0000 1.47 +++ databases/postgresql/pkg/PLIST-server 11 Nov 2022 05:21:58 -0000 @@ -111,8 +111,11 @@ include/postgresql/server/access/xlog_in include/postgresql/server/access/xlogarchive.h include/postgresql/server/access/xlogdefs.h include/postgresql/server/access/xloginsert.h +include/postgresql/server/access/xlogprefetcher.h include/postgresql/server/access/xlogreader.h include/postgresql/server/access/xlogrecord.h +include/postgresql/server/access/xlogrecovery.h +include/postgresql/server/access/xlogstats.h include/postgresql/server/access/xlogutils.h include/postgresql/server/bootstrap/ include/postgresql/server/bootstrap/bootstrap.h @@ -199,6 +202,8 @@ include/postgresql/server/catalog/pg_ope include/postgresql/server/catalog/pg_operator_d.h include/postgresql/server/catalog/pg_opfamily.h include/postgresql/server/catalog/pg_opfamily_d.h +include/postgresql/server/catalog/pg_parameter_acl.h +include/postgresql/server/catalog/pg_parameter_acl_d.h include/postgresql/server/catalog/pg_partitioned_table.h include/postgresql/server/catalog/pg_partitioned_table_d.h include/postgresql/server/catalog/pg_policy.h @@ -207,6 +212,8 @@ include/postgresql/server/catalog/pg_pro include/postgresql/server/catalog/pg_proc_d.h include/postgresql/server/catalog/pg_publication.h include/postgresql/server/catalog/pg_publication_d.h +include/postgresql/server/catalog/pg_publication_namespace.h +include/postgresql/server/catalog/pg_publication_namespace_d.h include/postgresql/server/catalog/pg_publication_rel.h include/postgresql/server/catalog/pg_publication_rel_d.h include/postgresql/server/catalog/pg_range.h @@ -301,6 +308,7 @@ 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/compression.h include/postgresql/server/common/config_info.h include/postgresql/server/common/connect.h include/postgresql/server/common/controldata_utils.h @@ -321,6 +329,7 @@ include/postgresql/server/common/logging include/postgresql/server/common/md5.h include/postgresql/server/common/openssl.h include/postgresql/server/common/pg_lzcompress.h +include/postgresql/server/common/pg_prng.h include/postgresql/server/common/relpath.h include/postgresql/server/common/restricted_token.h include/postgresql/server/common/saslprep.h @@ -330,6 +339,7 @@ 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_east_asian_fw_table.h include/postgresql/server/common/unicode_norm.h include/postgresql/server/common/unicode_norm_hashfunc.h include/postgresql/server/common/unicode_norm_table.h @@ -463,6 +473,7 @@ include/postgresql/server/libpq/pqcomm.h include/postgresql/server/libpq/pqformat.h include/postgresql/server/libpq/pqmq.h include/postgresql/server/libpq/pqsignal.h +include/postgresql/server/libpq/sasl.h include/postgresql/server/libpq/scram.h include/postgresql/server/mb/ include/postgresql/server/mb/pg_wchar.h @@ -531,6 +542,7 @@ include/postgresql/server/parser/parse_c include/postgresql/server/parser/parse_enr.h include/postgresql/server/parser/parse_expr.h include/postgresql/server/parser/parse_func.h +include/postgresql/server/parser/parse_merge.h include/postgresql/server/parser/parse_node.h include/postgresql/server/parser/parse_oper.h include/postgresql/server/parser/parse_param.h @@ -621,6 +633,7 @@ include/postgresql/server/port/solaris.h @comment include/postgresql/server/port/win32_msvc/unistd.h @comment include/postgresql/server/port/win32_msvc/utime.h @comment include/postgresql/server/port/win32_port.h +include/postgresql/server/port/win32ntdll.h include/postgresql/server/portability/ include/postgresql/server/portability/instr_time.h include/postgresql/server/portability/mem.h @@ -629,6 +642,7 @@ include/postgresql/server/postgres_ext.h include/postgresql/server/postgres_fe.h include/postgresql/server/postmaster/ include/postgresql/server/postmaster/autovacuum.h +include/postgresql/server/postmaster/auxprocess.h include/postgresql/server/postmaster/bgworker.h include/postgresql/server/postmaster/bgworker_internals.h include/postgresql/server/postmaster/bgwriter.h @@ -647,8 +661,6 @@ 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/logicallauncher.h @@ -749,6 +761,7 @@ include/postgresql/server/storage/copydi include/postgresql/server/storage/dsm.h include/postgresql/server/storage/dsm_impl.h include/postgresql/server/storage/fd.h +include/postgresql/server/storage/fileset.h include/postgresql/server/storage/freespace.h include/postgresql/server/storage/fsm_internals.h include/postgresql/server/storage/indexfsm.h @@ -844,7 +857,6 @@ include/postgresql/server/utils/help_con include/postgresql/server/utils/hsearch.h include/postgresql/server/utils/index_selfuncs.h 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/jsonb.h @@ -863,6 +875,7 @@ include/postgresql/server/utils/pg_crc.h include/postgresql/server/utils/pg_locale.h include/postgresql/server/utils/pg_lsn.h include/postgresql/server/utils/pg_rusage.h +include/postgresql/server/utils/pgstat_internal.h include/postgresql/server/utils/pidfile.h include/postgresql/server/utils/plancache.h include/postgresql/server/utils/portal.h @@ -917,9 +930,6 @@ include/postgresql/server/windowapi.h @so lib/postgresql/latin_and_mic.so @so lib/postgresql/libpqwalreceiver.so @so lib/postgresql/pgoutput.so -lib/postgresql/pgxs/src/pl/ -lib/postgresql/pgxs/src/pl/plpython/ -lib/postgresql/pgxs/src/pl/plpython/regress-python3-mangle.mk lib/postgresql/pgxs/src/test/isolation/ @bin lib/postgresql/pgxs/src/test/isolation/isolationtester @bin lib/postgresql/pgxs/src/test/isolation/pg_isolation_regress Index: databases/postgresql-previous/Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql-previous/Makefile,v retrieving revision 1.20 diff -u -p -r1.20 Makefile --- databases/postgresql-previous/Makefile 27 Mar 2022 16:23:08 -0000 1.20 +++ databases/postgresql-previous/Makefile 12 Nov 2022 08:21:39 -0000 @@ -1,15 +1,14 @@ COMMENT= PostgreSQL RDBMS (previous version, for pg_upgrade) -VERSION= 13.5 +VERSION= 14.6 DISTNAME= postgresql-${VERSION} PKGNAME= postgresql-previous-${VERSION} -REVISION= 0 CATEGORIES= databases SHARED_LIBS= ecpg 7.10 \ ecpg_compat 4.10 \ pgtypes 4.9 \ - pq 6.12 + pq 6.13 HOMEPAGE= https://www.postgresql.org/ Index: databases/postgresql-previous/distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql-previous/distinfo,v retrieving revision 1.9 diff -u -p -r1.9 distinfo --- databases/postgresql-previous/distinfo 13 Jan 2022 16:00:15 -0000 1.9 +++ databases/postgresql-previous/distinfo 12 Nov 2022 08:23:30 -0000 @@ -1,2 +1,2 @@ -SHA256 (postgresql-13.5.tar.gz) = YW7Wos7NHKjvMaGHJqR3T/zsil8THsif7FYPP95F75I= -SIZE (postgresql-13.5.tar.gz) = 27767272 +SHA256 (postgresql-14.6.tar.gz) = rO2g+Qi5SkfhTLtGe7SsYZQA0DJGt7BgVoPhEVf71IA= +SIZE (postgresql-14.6.tar.gz) = 29030856 Index: databases/postgresql-previous/patches/patch-src_Makefile_shlib =================================================================== RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_Makefile_shlib,v retrieving revision 1.3 diff -u -p -r1.3 patch-src_Makefile_shlib --- databases/postgresql-previous/patches/patch-src_Makefile_shlib 11 Mar 2022 18:31:38 -0000 1.3 +++ databases/postgresql-previous/patches/patch-src_Makefile_shlib 24 May 2022 14:54:40 -0000 @@ -1,7 +1,7 @@ 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-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.5 diff -u -p -r1.5 patch-src_bin_scripts_vacuumdb_c --- databases/postgresql-previous/patches/patch-src_bin_scripts_vacuumdb_c 11 Mar 2022 18:31:38 -0000 1.5 +++ databases/postgresql-previous/patches/patch-src_bin_scripts_vacuumdb_c 24 May 2022 14:54:40 -0000 @@ -1,12 +1,12 @@ 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-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.5 diff -u -p -r1.5 patch-src_include_storage_s_lock_h --- databases/postgresql-previous/patches/patch-src_include_storage_s_lock_h 11 Mar 2022 18:31:38 -0000 1.5 +++ databases/postgresql-previous/patches/patch-src_include_storage_s_lock_h 24 May 2022 14:54:40 -0000 @@ -1,7 +1,7 @@ Index: src/include/storage/s_lock.h --- src/include/storage/s_lock.h.orig +++ src/include/storage/s_lock.h -@@ -739,6 +739,29 @@ typedef unsigned char slock_t; +@@ -763,6 +763,29 @@ typedef unsigned char slock_t; do { __asm__ __volatile__("" : : : "memory"); *(lock) = 0; } while (0) #endif Index: databases/postgresql-previous/patches/patch-src_interfaces_libpq_Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql-previous/patches/patch-src_interfaces_libpq_Makefile,v retrieving revision 1.4 diff -u -p -r1.4 patch-src_interfaces_libpq_Makefile --- databases/postgresql-previous/patches/patch-src_interfaces_libpq_Makefile 11 Mar 2022 18:31:38 -0000 1.4 +++ databases/postgresql-previous/patches/patch-src_interfaces_libpq_Makefile 24 May 2022 14:54:40 -0000 @@ -1,7 +1,7 @@ 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-previous/pkg/PLIST =================================================================== RCS file: /cvs/ports/databases/postgresql-previous/pkg/PLIST,v retrieving revision 1.8 diff -u -p -r1.8 PLIST --- databases/postgresql-previous/pkg/PLIST 11 Mar 2022 18:31:38 -0000 1.8 +++ databases/postgresql-previous/pkg/PLIST 24 May 2022 15:10:10 -0000 @@ -7,6 +7,7 @@ bin/${POSTGRESQL_DIR}/ @bin bin/${POSTGRESQL_DIR}/ecpg @bin bin/${POSTGRESQL_DIR}/initdb @bin bin/${POSTGRESQL_DIR}/oid2name +@bin bin/${POSTGRESQL_DIR}/pg_amcheck @bin bin/${POSTGRESQL_DIR}/pg_archivecleanup @bin bin/${POSTGRESQL_DIR}/pg_basebackup @bin bin/${POSTGRESQL_DIR}/pg_checksums @@ -21,7 +22,6 @@ bin/${POSTGRESQL_DIR}/ @bin bin/${POSTGRESQL_DIR}/pg_resetwal @bin bin/${POSTGRESQL_DIR}/pg_restore @bin bin/${POSTGRESQL_DIR}/pg_rewind -@bin bin/${POSTGRESQL_DIR}/pg_standby @bin bin/${POSTGRESQL_DIR}/pg_test_fsync @bin bin/${POSTGRESQL_DIR}/pg_test_timing @bin bin/${POSTGRESQL_DIR}/pg_upgrade @@ -125,10 +125,12 @@ include/${POSTGRESQL_DIR}/server/access/ include/${POSTGRESQL_DIR}/server/access/spgxlog.h include/${POSTGRESQL_DIR}/server/access/stratnum.h include/${POSTGRESQL_DIR}/server/access/subtrans.h +include/${POSTGRESQL_DIR}/server/access/syncscan.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/toast_compression.h include/${POSTGRESQL_DIR}/server/access/toast_helper.h include/${POSTGRESQL_DIR}/server/access/toast_internals.h include/${POSTGRESQL_DIR}/server/access/transam.h @@ -166,7 +168,6 @@ include/${POSTGRESQL_DIR}/server/catalog include/${POSTGRESQL_DIR}/server/catalog/namespace.h include/${POSTGRESQL_DIR}/server/catalog/objectaccess.h include/${POSTGRESQL_DIR}/server/catalog/objectaddress.h -include/${POSTGRESQL_DIR}/server/catalog/opfam_internal.h include/${POSTGRESQL_DIR}/server/catalog/partition.h include/${POSTGRESQL_DIR}/server/catalog/pg_aggregate.h include/${POSTGRESQL_DIR}/server/catalog/pg_aggregate_d.h @@ -296,6 +297,7 @@ include/${POSTGRESQL_DIR}/server/catalog include/${POSTGRESQL_DIR}/server/catalog/schemapg.h include/${POSTGRESQL_DIR}/server/catalog/storage.h include/${POSTGRESQL_DIR}/server/catalog/storage_xlog.h +include/${POSTGRESQL_DIR}/server/catalog/system_fk_info.h include/${POSTGRESQL_DIR}/server/catalog/toasting.h include/${POSTGRESQL_DIR}/server/commands/ include/${POSTGRESQL_DIR}/server/commands/alter.h @@ -305,6 +307,7 @@ include/${POSTGRESQL_DIR}/server/command include/${POSTGRESQL_DIR}/server/commands/comment.h include/${POSTGRESQL_DIR}/server/commands/conversioncmds.h include/${POSTGRESQL_DIR}/server/commands/copy.h +include/${POSTGRESQL_DIR}/server/commands/copyfrom_internal.h include/${POSTGRESQL_DIR}/server/commands/createas.h include/${POSTGRESQL_DIR}/server/commands/dbcommands.h include/${POSTGRESQL_DIR}/server/commands/dbcommands_xlog.h @@ -340,10 +343,12 @@ include/${POSTGRESQL_DIR}/server/common/ 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/cryptohash.h include/${POSTGRESQL_DIR}/server/common/fe_memutils.h include/${POSTGRESQL_DIR}/server/common/file_perm.h include/${POSTGRESQL_DIR}/server/common/file_utils.h include/${POSTGRESQL_DIR}/server/common/hashfn.h +include/${POSTGRESQL_DIR}/server/common/hmac.h include/${POSTGRESQL_DIR}/server/common/int.h include/${POSTGRESQL_DIR}/server/common/int128.h include/${POSTGRESQL_DIR}/server/common/ip.h @@ -359,17 +364,20 @@ include/${POSTGRESQL_DIR}/server/common/ include/${POSTGRESQL_DIR}/server/common/restricted_token.h include/${POSTGRESQL_DIR}/server/common/saslprep.h include/${POSTGRESQL_DIR}/server/common/scram-common.h +include/${POSTGRESQL_DIR}/server/common/sha1.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_combining_table.h include/${POSTGRESQL_DIR}/server/common/unicode_norm.h +include/${POSTGRESQL_DIR}/server/common/unicode_norm_hashfunc.h include/${POSTGRESQL_DIR}/server/common/unicode_norm_table.h include/${POSTGRESQL_DIR}/server/common/unicode_normprops_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/executor/ +include/${POSTGRESQL_DIR}/server/executor/execAsync.h include/${POSTGRESQL_DIR}/server/executor/execExpr.h include/${POSTGRESQL_DIR}/server/executor/execParallel.h include/${POSTGRESQL_DIR}/server/executor/execPartition.h @@ -400,6 +408,7 @@ include/${POSTGRESQL_DIR}/server/executo include/${POSTGRESQL_DIR}/server/executor/nodeLimit.h include/${POSTGRESQL_DIR}/server/executor/nodeLockRows.h include/${POSTGRESQL_DIR}/server/executor/nodeMaterial.h +include/${POSTGRESQL_DIR}/server/executor/nodeMemoize.h include/${POSTGRESQL_DIR}/server/executor/nodeMergeAppend.h include/${POSTGRESQL_DIR}/server/executor/nodeMergejoin.h include/${POSTGRESQL_DIR}/server/executor/nodeModifyTable.h @@ -415,6 +424,7 @@ include/${POSTGRESQL_DIR}/server/executo include/${POSTGRESQL_DIR}/server/executor/nodeSubplan.h include/${POSTGRESQL_DIR}/server/executor/nodeSubqueryscan.h include/${POSTGRESQL_DIR}/server/executor/nodeTableFuncscan.h +include/${POSTGRESQL_DIR}/server/executor/nodeTidrangescan.h include/${POSTGRESQL_DIR}/server/executor/nodeTidscan.h include/${POSTGRESQL_DIR}/server/executor/nodeUnique.h include/${POSTGRESQL_DIR}/server/executor/nodeValuesscan.h @@ -441,10 +451,14 @@ include/${POSTGRESQL_DIR}/server/fe_util include/${POSTGRESQL_DIR}/server/fe_utils/archive.h include/${POSTGRESQL_DIR}/server/fe_utils/cancel.h include/${POSTGRESQL_DIR}/server/fe_utils/conditional.h +include/${POSTGRESQL_DIR}/server/fe_utils/connect_utils.h include/${POSTGRESQL_DIR}/server/fe_utils/mbprint.h +include/${POSTGRESQL_DIR}/server/fe_utils/option_utils.h +include/${POSTGRESQL_DIR}/server/fe_utils/parallel_slot.h include/${POSTGRESQL_DIR}/server/fe_utils/print.h include/${POSTGRESQL_DIR}/server/fe_utils/psqlscan.h include/${POSTGRESQL_DIR}/server/fe_utils/psqlscan_int.h +include/${POSTGRESQL_DIR}/server/fe_utils/query_utils.h include/${POSTGRESQL_DIR}/server/fe_utils/recovery_gen.h include/${POSTGRESQL_DIR}/server/fe_utils/simple_list.h include/${POSTGRESQL_DIR}/server/fe_utils/string_utils.h @@ -472,6 +486,7 @@ include/${POSTGRESQL_DIR}/server/lib/pai include/${POSTGRESQL_DIR}/server/lib/qunique.h include/${POSTGRESQL_DIR}/server/lib/rbtree.h include/${POSTGRESQL_DIR}/server/lib/simplehash.h +include/${POSTGRESQL_DIR}/server/lib/sort_template.h include/${POSTGRESQL_DIR}/server/lib/stringinfo.h include/${POSTGRESQL_DIR}/server/libpq/ include/${POSTGRESQL_DIR}/server/libpq/auth.h @@ -510,6 +525,7 @@ include/${POSTGRESQL_DIR}/server/nodes/p include/${POSTGRESQL_DIR}/server/nodes/print.h include/${POSTGRESQL_DIR}/server/nodes/readfuncs.h include/${POSTGRESQL_DIR}/server/nodes/replnodes.h +include/${POSTGRESQL_DIR}/server/nodes/subscripting.h include/${POSTGRESQL_DIR}/server/nodes/supportnodes.h include/${POSTGRESQL_DIR}/server/nodes/tidbitmap.h include/${POSTGRESQL_DIR}/server/nodes/value.h @@ -608,6 +624,8 @@ include/${POSTGRESQL_DIR}/server/port/op 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/pg_iovec.h +include/${POSTGRESQL_DIR}/server/port/pg_pthread.h include/${POSTGRESQL_DIR}/server/port/solaris.h include/${POSTGRESQL_DIR}/server/port/win32/ include/${POSTGRESQL_DIR}/server/port/win32.h @@ -683,6 +701,7 @@ include/${POSTGRESQL_DIR}/server/rewrite include/${POSTGRESQL_DIR}/server/rewrite/rewriteHandler.h include/${POSTGRESQL_DIR}/server/rewrite/rewriteManip.h include/${POSTGRESQL_DIR}/server/rewrite/rewriteRemove.h +include/${POSTGRESQL_DIR}/server/rewrite/rewriteSearchCycle.h include/${POSTGRESQL_DIR}/server/rewrite/rewriteSupport.h include/${POSTGRESQL_DIR}/server/rewrite/rowsecurity.h include/${POSTGRESQL_DIR}/server/rusagestub.h @@ -691,6 +710,8 @@ include/${POSTGRESQL_DIR}/server/snowbal include/${POSTGRESQL_DIR}/server/snowball/libstemmer/ include/${POSTGRESQL_DIR}/server/snowball/libstemmer/api.h include/${POSTGRESQL_DIR}/server/snowball/libstemmer/header.h +include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_basque.h +include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_catalan.h include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_danish.h include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_dutch.h include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_ISO_8859_1_english.h @@ -709,6 +730,9 @@ include/${POSTGRESQL_DIR}/server/snowbal 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_armenian.h +include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_basque.h +include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_catalan.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 @@ -716,6 +740,7 @@ 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_greek.h +include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_hindi.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 @@ -727,10 +752,12 @@ include/${POSTGRESQL_DIR}/server/snowbal include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_portuguese.h include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_romanian.h include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_russian.h +include/${POSTGRESQL_DIR}/server/snowball/libstemmer/stem_UTF_8_serbian.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/snowball/libstemmer/stem_UTF_8_yiddish.h include/${POSTGRESQL_DIR}/server/statistics/ include/${POSTGRESQL_DIR}/server/statistics/extended_stats_internal.h include/${POSTGRESQL_DIR}/server/statistics/statistics.h @@ -815,6 +842,8 @@ 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_progress.h +include/${POSTGRESQL_DIR}/server/utils/backend_status.h include/${POSTGRESQL_DIR}/server/utils/builtins.h include/${POSTGRESQL_DIR}/server/utils/bytea.h include/${POSTGRESQL_DIR}/server/utils/cash.h @@ -853,7 +882,9 @@ include/${POSTGRESQL_DIR}/server/utils/l 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/multirangetypes.h include/${POSTGRESQL_DIR}/server/utils/numeric.h +include/${POSTGRESQL_DIR}/server/utils/old_snapshot.h include/${POSTGRESQL_DIR}/server/utils/palloc.h include/${POSTGRESQL_DIR}/server/utils/partcache.h include/${POSTGRESQL_DIR}/server/utils/pg_crc.h @@ -866,6 +897,7 @@ include/${POSTGRESQL_DIR}/server/utils/p include/${POSTGRESQL_DIR}/server/utils/probes.h include/${POSTGRESQL_DIR}/server/utils/ps_status.h include/${POSTGRESQL_DIR}/server/utils/queryenvironment.h +include/${POSTGRESQL_DIR}/server/utils/queryjumble.h include/${POSTGRESQL_DIR}/server/utils/rangetypes.h include/${POSTGRESQL_DIR}/server/utils/regproc.h include/${POSTGRESQL_DIR}/server/utils/rel.h @@ -895,6 +927,7 @@ include/${POSTGRESQL_DIR}/server/utils/t include/${POSTGRESQL_DIR}/server/utils/uuid.h include/${POSTGRESQL_DIR}/server/utils/varbit.h include/${POSTGRESQL_DIR}/server/utils/varlena.h +include/${POSTGRESQL_DIR}/server/utils/wait_event.h include/${POSTGRESQL_DIR}/server/utils/xid8.h include/${POSTGRESQL_DIR}/server/utils/xml.h include/${POSTGRESQL_DIR}/server/windowapi.h @@ -961,12 +994,14 @@ lib/${POSTGRESQL_DIR}/libpq.so.6 @so lib/${POSTGRESQL_DIR}/lo.so @so lib/${POSTGRESQL_DIR}/ltree.so @so lib/${POSTGRESQL_DIR}/moddatetime.so +@so lib/${POSTGRESQL_DIR}/old_snapshot.so @so lib/${POSTGRESQL_DIR}/pageinspect.so @so lib/${POSTGRESQL_DIR}/passwordcheck.so @so lib/${POSTGRESQL_DIR}/pg_buffercache.so @so lib/${POSTGRESQL_DIR}/pg_freespacemap.so @so lib/${POSTGRESQL_DIR}/pg_prewarm.so @so lib/${POSTGRESQL_DIR}/pg_stat_statements.so +@so lib/${POSTGRESQL_DIR}/pg_surgery.so @so lib/${POSTGRESQL_DIR}/pg_trgm.so @so lib/${POSTGRESQL_DIR}/pg_visibility.so @so lib/${POSTGRESQL_DIR}/pgcrypto.so @@ -986,6 +1021,9 @@ lib/${POSTGRESQL_DIR}/pgxs/src/makefiles lib/${POSTGRESQL_DIR}/pgxs/src/makefiles/pgxs.mk lib/${POSTGRESQL_DIR}/pgxs/src/nls-global.mk lib/${POSTGRESQL_DIR}/pgxs/src/test/ +lib/${POSTGRESQL_DIR}/pgxs/src/test/isolation/ +@bin lib/${POSTGRESQL_DIR}/pgxs/src/test/isolation/isolationtester +@bin lib/${POSTGRESQL_DIR}/pgxs/src/test/isolation/pg_isolation_regress lib/${POSTGRESQL_DIR}/pgxs/src/test/regress/ @bin lib/${POSTGRESQL_DIR}/pgxs/src/test/regress/pg_regress lib/${POSTGRESQL_DIR}/pkgconfig/ @@ -1033,6 +1071,7 @@ share/${POSTGRESQL_DIR}/extension/adminp 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--1.2--1.3.sql share/${POSTGRESQL_DIR}/extension/amcheck.control share/${POSTGRESQL_DIR}/extension/autoinc--1.0.sql share/${POSTGRESQL_DIR}/extension/autoinc.control @@ -1053,6 +1092,7 @@ share/${POSTGRESQL_DIR}/extension/btree_ share/${POSTGRESQL_DIR}/extension/btree_gist--1.2.sql share/${POSTGRESQL_DIR}/extension/btree_gist--1.3--1.4.sql share/${POSTGRESQL_DIR}/extension/btree_gist--1.4--1.5.sql +share/${POSTGRESQL_DIR}/extension/btree_gist--1.5--1.6.sql share/${POSTGRESQL_DIR}/extension/btree_gist.control share/${POSTGRESQL_DIR}/extension/citext--1.0--1.1.sql share/${POSTGRESQL_DIR}/extension/citext--1.1--1.2.sql @@ -1067,6 +1107,7 @@ share/${POSTGRESQL_DIR}/extension/cube-- share/${POSTGRESQL_DIR}/extension/cube--1.2--1.3.sql share/${POSTGRESQL_DIR}/extension/cube--1.2.sql share/${POSTGRESQL_DIR}/extension/cube--1.3--1.4.sql +share/${POSTGRESQL_DIR}/extension/cube--1.4--1.5.sql share/${POSTGRESQL_DIR}/extension/cube.control share/${POSTGRESQL_DIR}/extension/dblink--1.0--1.1.sql share/${POSTGRESQL_DIR}/extension/dblink--1.1--1.2.sql @@ -1084,7 +1125,6 @@ share/${POSTGRESQL_DIR}/extension/file_f share/${POSTGRESQL_DIR}/extension/fuzzystrmatch--1.0--1.1.sql share/${POSTGRESQL_DIR}/extension/fuzzystrmatch--1.1.sql share/${POSTGRESQL_DIR}/extension/fuzzystrmatch.control -share/${POSTGRESQL_DIR}/extension/hstore--1.0--1.1.sql share/${POSTGRESQL_DIR}/extension/hstore--1.1--1.2.sql share/${POSTGRESQL_DIR}/extension/hstore--1.2--1.3.sql share/${POSTGRESQL_DIR}/extension/hstore--1.3--1.4.sql @@ -1092,6 +1132,7 @@ share/${POSTGRESQL_DIR}/extension/hstore share/${POSTGRESQL_DIR}/extension/hstore--1.4.sql share/${POSTGRESQL_DIR}/extension/hstore--1.5--1.6.sql share/${POSTGRESQL_DIR}/extension/hstore--1.6--1.7.sql +share/${POSTGRESQL_DIR}/extension/hstore--1.7--1.8.sql share/${POSTGRESQL_DIR}/extension/hstore.control share/${POSTGRESQL_DIR}/extension/hstore_plperl--1.0.sql share/${POSTGRESQL_DIR}/extension/hstore_plperl.control @@ -1106,6 +1147,8 @@ share/${POSTGRESQL_DIR}/extension/intarr share/${POSTGRESQL_DIR}/extension/intarray--1.1--1.2.sql share/${POSTGRESQL_DIR}/extension/intarray--1.2--1.3.sql share/${POSTGRESQL_DIR}/extension/intarray--1.2.sql +share/${POSTGRESQL_DIR}/extension/intarray--1.3--1.4.sql +share/${POSTGRESQL_DIR}/extension/intarray--1.4--1.5.sql share/${POSTGRESQL_DIR}/extension/intarray.control share/${POSTGRESQL_DIR}/extension/isn--1.0--1.1.sql share/${POSTGRESQL_DIR}/extension/isn--1.1--1.2.sql @@ -1124,6 +1167,8 @@ share/${POSTGRESQL_DIR}/extension/ltree- share/${POSTGRESQL_DIR}/extension/ltree.control share/${POSTGRESQL_DIR}/extension/moddatetime--1.0.sql share/${POSTGRESQL_DIR}/extension/moddatetime.control +share/${POSTGRESQL_DIR}/extension/old_snapshot--1.0.sql +share/${POSTGRESQL_DIR}/extension/old_snapshot.control share/${POSTGRESQL_DIR}/extension/pageinspect--1.0--1.1.sql share/${POSTGRESQL_DIR}/extension/pageinspect--1.1--1.2.sql share/${POSTGRESQL_DIR}/extension/pageinspect--1.2--1.3.sql @@ -1133,6 +1178,7 @@ share/${POSTGRESQL_DIR}/extension/pagein share/${POSTGRESQL_DIR}/extension/pageinspect--1.5.sql share/${POSTGRESQL_DIR}/extension/pageinspect--1.6--1.7.sql share/${POSTGRESQL_DIR}/extension/pageinspect--1.7--1.8.sql +share/${POSTGRESQL_DIR}/extension/pageinspect--1.8--1.9.sql share/${POSTGRESQL_DIR}/extension/pageinspect.control share/${POSTGRESQL_DIR}/extension/pg_buffercache--1.0--1.1.sql share/${POSTGRESQL_DIR}/extension/pg_buffercache--1.1--1.2.sql @@ -1156,13 +1202,17 @@ share/${POSTGRESQL_DIR}/extension/pg_sta 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--1.7--1.8.sql +share/${POSTGRESQL_DIR}/extension/pg_stat_statements--1.8--1.9.sql share/${POSTGRESQL_DIR}/extension/pg_stat_statements.control +share/${POSTGRESQL_DIR}/extension/pg_surgery--1.0.sql +share/${POSTGRESQL_DIR}/extension/pg_surgery.control share/${POSTGRESQL_DIR}/extension/pg_trgm--1.0--1.1.sql share/${POSTGRESQL_DIR}/extension/pg_trgm--1.1--1.2.sql share/${POSTGRESQL_DIR}/extension/pg_trgm--1.2--1.3.sql share/${POSTGRESQL_DIR}/extension/pg_trgm--1.3--1.4.sql share/${POSTGRESQL_DIR}/extension/pg_trgm--1.3.sql share/${POSTGRESQL_DIR}/extension/pg_trgm--1.4--1.5.sql +share/${POSTGRESQL_DIR}/extension/pg_trgm--1.5--1.6.sql share/${POSTGRESQL_DIR}/extension/pg_trgm.control share/${POSTGRESQL_DIR}/extension/pg_visibility--1.0--1.1.sql share/${POSTGRESQL_DIR}/extension/pg_visibility--1.1--1.2.sql @@ -1190,6 +1240,7 @@ share/${POSTGRESQL_DIR}/extension/plperl share/${POSTGRESQL_DIR}/extension/plperlu.control share/${POSTGRESQL_DIR}/extension/plpgsql--1.0.sql share/${POSTGRESQL_DIR}/extension/plpgsql.control +share/${POSTGRESQL_DIR}/extension/postgres_fdw--1.0--1.1.sql share/${POSTGRESQL_DIR}/extension/postgres_fdw--1.0.sql share/${POSTGRESQL_DIR}/extension/postgres_fdw.control share/${POSTGRESQL_DIR}/extension/refint--1.0.sql @@ -1198,6 +1249,7 @@ share/${POSTGRESQL_DIR}/extension/seg--1 share/${POSTGRESQL_DIR}/extension/seg--1.1--1.2.sql share/${POSTGRESQL_DIR}/extension/seg--1.1.sql share/${POSTGRESQL_DIR}/extension/seg--1.2--1.3.sql +share/${POSTGRESQL_DIR}/extension/seg--1.3--1.4.sql share/${POSTGRESQL_DIR}/extension/seg.control share/${POSTGRESQL_DIR}/extension/sslinfo--1.0--1.1.sql share/${POSTGRESQL_DIR}/extension/sslinfo--1.1--1.2.sql @@ -1229,6 +1281,8 @@ share/${POSTGRESQL_DIR}/postgresql.conf. share/${POSTGRESQL_DIR}/psqlrc.sample share/${POSTGRESQL_DIR}/snowball_create.sql share/${POSTGRESQL_DIR}/sql_features.txt +share/${POSTGRESQL_DIR}/system_constraints.sql +share/${POSTGRESQL_DIR}/system_functions.sql share/${POSTGRESQL_DIR}/system_views.sql share/${POSTGRESQL_DIR}/timezonesets/ share/${POSTGRESQL_DIR}/timezonesets/Africa.txt Index: databases/postgresql-pllua/Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql-pllua/Makefile,v retrieving revision 1.20 diff -u -p -r1.20 Makefile --- databases/postgresql-pllua/Makefile 11 Mar 2022 18:31:37 -0000 1.20 +++ databases/postgresql-pllua/Makefile 12 Nov 2022 19:03:18 -0000 @@ -5,6 +5,12 @@ GH_ACCOUNT = pllua GH_PROJECT = pllua GH_TAGNAME = REL_${VERSION:S/./_/g} PKGNAME = postgresql-pllua-${VERSION} +REVISION = 0 + +# Use upstream pull request for PostgreSQL 15 support +MASTER_SITES0 = https://github.com/pllua/pllua/commit/ +PATCH_DIST_STRIP = -p1 +PATCHFILES = pllua-pg-15-fix{d0e014cdfd4e9ad801e7d2814584ff4b1892a08c}.patch:0 CATEGORIES = databases @@ -21,8 +27,8 @@ MODULES = lang/lua MODLUA_VERSION = 5.3 BUILD_DEPENDS = ${RUN_DEPENDS} \ - postgresql-client->=14,<15:databases/postgresql,-main -RUN_DEPENDS = postgresql-server->=14,<15:databases/postgresql,-server + postgresql-client->=15,<16:databases/postgresql,-main +RUN_DEPENDS = postgresql-server->=15,<16:databases/postgresql,-server USE_GMAKE = Yes Index: databases/postgresql-pllua/distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql-pllua/distinfo,v retrieving revision 1.8 diff -u -p -r1.8 distinfo --- databases/postgresql-pllua/distinfo 13 Jan 2022 16:02:25 -0000 1.8 +++ databases/postgresql-pllua/distinfo 12 Nov 2022 18:54:05 -0000 @@ -1,2 +1,4 @@ SHA256 (pllua-REL_2_0_10.tar.gz) = XUN5S210YOmNCEGUD/ChukHFRfzfstVx3WwsTpqRJNw= +SHA256 (pllua-pg-15-fix.patch) = P+uUdUFx2pvz7+100b1eFLpIqqWuENYV/duTbK/bThk= SIZE (pllua-REL_2_0_10.tar.gz) = 220676 +SIZE (pllua-pg-15-fix.patch) = 33575 Index: databases/repmgr/Makefile =================================================================== RCS file: /cvs/ports/databases/repmgr/Makefile,v retrieving revision 1.12 diff -u -p -r1.12 Makefile --- databases/repmgr/Makefile 11 Mar 2022 18:31:43 -0000 1.12 +++ databases/repmgr/Makefile 12 Nov 2022 18:56:14 -0000 @@ -1,6 +1,6 @@ COMMENT = HA and replication cluster management for PostgreSQL -DISTNAME = repmgr-5.2.1 +DISTNAME = repmgr-5.3.3 CATEGORIES = databases HOMEPAGE = https://repmgr.org/ Index: databases/repmgr/distinfo =================================================================== RCS file: /cvs/ports/databases/repmgr/distinfo,v retrieving revision 1.5 diff -u -p -r1.5 distinfo --- databases/repmgr/distinfo 21 Feb 2021 17:19:58 -0000 1.5 +++ databases/repmgr/distinfo 12 Nov 2022 18:56:23 -0000 @@ -1,2 +1,2 @@ -SHA256 (repmgr-5.2.1.tar.gz) = jm0QQ1KrTBK42SPfUfWBcgsjA8ROK+mNVtTPaqmGJ3I= -SIZE (repmgr-5.2.1.tar.gz) = 448164 +SHA256 (repmgr-5.3.3.tar.gz) = YL5tOacGtk3lr1rDz+f4Z1N2q2BJ+ywqm36dUL+WLgE= +SIZE (repmgr-5.3.3.tar.gz) = 456931 Index: databases/repmgr/pkg/PLIST =================================================================== RCS file: /cvs/ports/databases/repmgr/pkg/PLIST,v retrieving revision 1.4 diff -u -p -r1.4 PLIST --- databases/repmgr/pkg/PLIST 11 Mar 2022 18:31:43 -0000 1.4 +++ databases/repmgr/pkg/PLIST 12 Nov 2022 18:57:18 -0000 @@ -21,8 +21,11 @@ share/postgresql/extension/repmgr--5.0-- share/postgresql/extension/repmgr--5.0.sql share/postgresql/extension/repmgr--5.1--5.2.sql share/postgresql/extension/repmgr--5.1.sql +share/postgresql/extension/repmgr--5.2--5.3.sql share/postgresql/extension/repmgr--5.2.sql +share/postgresql/extension/repmgr--5.3.sql share/postgresql/extension/repmgr--unpackaged--4.0.sql share/postgresql/extension/repmgr--unpackaged--5.1.sql share/postgresql/extension/repmgr--unpackaged--5.2.sql +share/postgresql/extension/repmgr--unpackaged--5.3.sql share/postgresql/extension/repmgr.control Index: databases/timescaledb/Makefile =================================================================== RCS file: /cvs/ports/databases/timescaledb/Makefile,v retrieving revision 1.15 diff -u -p -r1.15 Makefile --- databases/timescaledb/Makefile 10 Jul 2022 08:44:07 -0000 1.15 +++ databases/timescaledb/Makefile 12 Nov 2022 18:58:32 -0000 @@ -1,3 +1,4 @@ +BROKEN = TimescaleDB does not yet support PostgreSQL 15 COMMENT = database designed to make SQL scalable for time-series data GH_ACCOUNT = timescale