Here's a diff to upgrade PostgreSQL from 14.5 to 15.0, not including dependent ports (except postgresql-previous). Not currently intended for commit, that won't happen until 15.1 at the earliest. Release notes at: https://www.postgresql.org/about/news/postgresql-15-released-2526/
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. The main part I want feedback on is a new patch that silently treats the dynamic_shared_memory_type = posix as dynamic_shared_memory_type = shm. Since 15beta1, I had an issue where the PostgreSQL server would stop working after a week. I traced that issue to OpenBSD deleting the shared memory files in /tmp that shm_open(3) creates, since they were more than a week old. Possibly this is only an issue on lightly loaded servers, but unless daily(8) skips deleting these files automatically, I consider the approach the patch uses necessary for reliable operation. Thanks, Jeremy Index: postgresql/Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql/Makefile,v retrieving revision 1.289 diff -u -p -r1.289 Makefile --- postgresql/Makefile 15 Aug 2022 18:07:16 -0000 1.289 +++ postgresql/Makefile 13 Oct 2022 14:46:13 -0000 @@ -5,8 +5,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= 14.5 -PREV_MAJOR= 13 +VERSION= 15.0 +PREV_MAJOR= 14 DISTNAME= postgresql-${VERSION} PKGNAME-main= postgresql-client-${VERSION} @@ -16,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: postgresql/distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql/distinfo,v retrieving revision 1.94 diff -u -p -r1.94 distinfo --- postgresql/distinfo 15 Aug 2022 18:07:16 -0000 1.94 +++ postgresql/distinfo 13 Oct 2022 14:46:34 -0000 @@ -1,2 +1,2 @@ -SHA256 (postgresql-14.5.tar.gz) = kOrTk9vGVMsAdeqvDsIFjmuYZs7UeP7TzytopbwE6yQ= -SIZE (postgresql-14.5.tar.gz) = 28988974 +SHA256 (postgresql-15.0.tar.gz) = +cfJvanZNZuxN+1RCsHPkOavofc5wGFrtrY3srwstgQ= +SIZE (postgresql-15.0.tar.gz) = 29385837 Index: postgresql/patches/patch-src_backend_storage_ipc_dsm_impl_c =================================================================== RCS file: postgresql/patches/patch-src_backend_storage_ipc_dsm_impl_c diff -N postgresql/patches/patch-src_backend_storage_ipc_dsm_impl_c --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ postgresql/patches/patch-src_backend_storage_ipc_dsm_impl_c 13 Jul 2022 19:14:13 -0000 @@ -0,0 +1,27 @@ +Use sysv shared memory instead of posix, even if posix specified. + +Without this change, with the default dynamic_shared_memory_type = posix, +shared memory files would be created in /tmp via shm_open, and the +database would stop working after a week as /etc/daily deletes files more +than a week old. + +Previous versions of PostgreSQL on OpenBSD use dynamic_shared_memory_type = posix, +but for some reason they don't have this issue. Since many users copy settings +from previous postgresql.conf when upgrading, it's likely they will copy this +setting, which will appear to work, until it fails after a week. + +This silently treats dynamic_shared_memory_type = posix as sysv, which doesn't +have this issue as it does not use temporary files. + +Index: src/backend/storage/ipc/dsm_impl.c +--- src/backend/storage/ipc/dsm_impl.c.orig ++++ src/backend/storage/ipc/dsm_impl.c +@@ -170,8 +170,6 @@ dsm_impl_op(dsm_op op, dsm_handle handle, Size request + { + #ifdef USE_DSM_POSIX + case DSM_IMPL_POSIX: +- return dsm_impl_posix(op, handle, request_size, impl_private, +- mapped_address, mapped_size, elevel); + #endif + #ifdef USE_DSM_SYSV + case DSM_IMPL_SYSV: Index: 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 --- postgresql/patches/patch-src_bin_scripts_vacuumdb_c 11 Mar 2022 18:31:37 -0000 1.5 +++ 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: 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 --- postgresql/patches/patch-src_include_storage_s_lock_h 14 May 2022 17:51:55 -0000 1.9 +++ postgresql/patches/patch-src_include_storage_s_lock_h 23 May 2022 20:11:09 -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; +@@ -780,6 +780,29 @@ typedef unsigned char slock_t; do { __asm__ __volatile__("" : : : "memory"); *(lock) = 0; } while (0) #endif Index: 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 --- postgresql/patches/patch-src_interfaces_libpq_Makefile 11 Mar 2022 18:31:37 -0000 1.16 +++ 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: 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 --- postgresql/pkg/PLIST-contrib 11 Mar 2022 18:31:37 -0000 1.24 +++ 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: 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 --- postgresql/pkg/PLIST-docs 15 Aug 2022 18:07:16 -0000 1.107 +++ postgresql/pkg/PLIST-docs 5 Oct 2022 18:24:42 -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,7 @@ 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-prior.html share/doc/postgresql/html/release.html share/doc/postgresql/html/replication-origins.html @@ -979,6 +986,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 +1026,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 +1108,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 +1135,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: 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 --- postgresql/pkg/PLIST-main 11 Mar 2022 18:31:37 -0000 1.35 +++ 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: 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 --- postgresql/pkg/PLIST-plpython 11 Mar 2022 18:31:37 -0000 1.12 +++ 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: postgresql/pkg/PLIST-server =================================================================== RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v retrieving revision 1.46 diff -u -p -r1.46 PLIST-server --- postgresql/pkg/PLIST-server 11 Mar 2022 18:31:37 -0000 1.46 +++ postgresql/pkg/PLIST-server 12 Sep 2022 21:10:40 -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: postgresql-previous/Makefile =================================================================== RCS file: /cvs/ports/databases/postgresql-previous/Makefile,v retrieving revision 1.20 diff -u -p -r1.20 Makefile --- postgresql-previous/Makefile 27 Mar 2022 16:23:08 -0000 1.20 +++ postgresql-previous/Makefile 13 Oct 2022 14:54:39 -0000 @@ -1,15 +1,14 @@ COMMENT= PostgreSQL RDBMS (previous version, for pg_upgrade) -VERSION= 13.5 +VERSION= 14.5 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: postgresql-previous/distinfo =================================================================== RCS file: /cvs/ports/databases/postgresql-previous/distinfo,v retrieving revision 1.9 diff -u -p -r1.9 distinfo --- postgresql-previous/distinfo 13 Jan 2022 16:00:15 -0000 1.9 +++ postgresql-previous/distinfo 13 Oct 2022 14:55:02 -0000 @@ -1,2 +1,2 @@ -SHA256 (postgresql-13.5.tar.gz) = YW7Wos7NHKjvMaGHJqR3T/zsil8THsif7FYPP95F75I= -SIZE (postgresql-13.5.tar.gz) = 27767272 +SHA256 (postgresql-14.5.tar.gz) = kOrTk9vGVMsAdeqvDsIFjmuYZs7UeP7TzytopbwE6yQ= +SIZE (postgresql-14.5.tar.gz) = 28988974 Index: 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 --- postgresql-previous/patches/patch-src_Makefile_shlib 11 Mar 2022 18:31:38 -0000 1.3 +++ 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: 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 --- postgresql-previous/patches/patch-src_bin_scripts_vacuumdb_c 11 Mar 2022 18:31:38 -0000 1.5 +++ 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: 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 --- postgresql-previous/patches/patch-src_include_storage_s_lock_h 11 Mar 2022 18:31:38 -0000 1.5 +++ 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: 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 --- postgresql-previous/patches/patch-src_interfaces_libpq_Makefile 11 Mar 2022 18:31:38 -0000 1.4 +++ 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: postgresql-previous/pkg/PLIST =================================================================== RCS file: /cvs/ports/databases/postgresql-previous/pkg/PLIST,v retrieving revision 1.8 diff -u -p -r1.8 PLIST --- postgresql-previous/pkg/PLIST 11 Mar 2022 18:31:38 -0000 1.8 +++ 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