Debian Patches

Status for postgresql-16/16.2-2

Patch Description Author Forwarded Bugs Origin Last update
50-per-version-dirs.patch Use version specific installation directories so that several major versions can be installed in parallel.
* Install lib files into /usr/lib/postgresql/<version>/lib/
* Install server related header files into /usr/include/postgresql/<version>/server/
Martin Pitt <mpitt@debian.org> invalid debian
51-default-sockets-in-var.patch Put server Unix sockets into /var/run/postgresql/ by default
Using /tmp for sockets allows everyone to spoof a PostgreSQL server. Thus use
/var/run/postgresql/ for "system" clusters which run as 'postgres' (user
clusters will still use /tmp). Since system cluster are by far the common case,
set it as default.
Martin Pitt <mpitt@debian.org> invalid
52-tutorial-README.patch Update tutorial README for required build dependencies. Martin Pitt <mpitt@debian.org> invalid
53-pg_service.conf_directory_doc.patch Update pg_service.conf example to tell the Debian specific file location.
===================================================================
Martin Pitt <mpitt@debian.org> invalid
54-debian-alternatives-for-external-tools.patch Use Debian alternatives for external tools instead of hardcoded programs Martin Pitt <mpitt@debian.org> invalid
70-history Document Debian location of release notes files. Christoph Berg <myon@debian.org> invalid
filter-debug-prefix-map To make the PostgreSQL server packages build reproducibly, we need to remove
the build path from -fdebug-prefix-map and -ffile-prefix-map in CFLAGS.

* The actual server build still uses the original CFLAGS so the build path is
correctly mapped in the object files.
* The information printed by the pg_config binary and the system view is
filtered in src/common/Makefile and the configure script.
* The build paths stored in Makefile.global are filtered in debian/rules.
(abs_top_builddir, abs_top_srcdir, configure_args, CFLAGS)
* To make PGXS module builds reproducible, pg_buildext copies the environment
CFLAGS to COPT where Makefile.global picks them up, using the prefix maps
from dpkg-buildflags.
no
libpgport-pkglibdir Move libpgport/libpgcommon/libpgfeutils from libdir to pkglibdir This allows client applications to link to version-specific libraries.
Used by pg-checksums.
Christoph Berg <myon@debian.org> invalid
extension_destdir no
autoconf2.69 no
focal-arm64-outline-atomics Enable outline-atomics on arm64.

The flag was added in focal's gcc, but is off by default there. It is enabled
by default on all later distributions (hirsute, impish, bullseye, bookwork,
sid).

https://www.postgresql.org/message-id/flat/1635221042457.21654%40amazon.com

This patch can be removed once focal is EOL.
no
jit-s390x [PATCH] jit: Workaround potential datalayout mismatch on s390x
LLVM's s390x target uses a different datalayout for z13 and newer processors.
If llvmjit_types.bc is compiled to target a processor older than z13, and
then the JIT runs on a z13 or newer processor, then there will be a mismatch
in datalayouts between llvmjit_types.bc and the JIT engine. This mismatch
causes the JIT to fail at runtime.
Tom Stellard <tstellar@redhat.com> no 2021-04-20
hurd-iovec hurd-i386 does not define IOV_MAX no
v8-0001-Fix-recovery-conflict-SIGUSR1-handling.patch [PATCH v8] Fix recovery conflict SIGUSR1 handling.
We shouldn't be doing real work in a signal handler, to avoid reaching
code that is not safe in that context. The previous coding also
confused the 'reason' shown in error messages by clobbering global
variables. Move all recovery conflict checking logic into the next CFI,
and have the signal handler just set flags and the latch, following the
standard pattern. Since there are several different reasons, use a
separate flag for each.

With this refactoring, the recovery conflict system no longer
piggy-backs on top of the regular query cancelation mechanisms, but
instead ereports directly if it decides that is necessary. It still
needs to respect QueryCancelHoldoffCount, because otherwise the FEBE
protocol might be corrupted (see commit 2b3a8b20c2d).

Back-patch to 16. For now we have agreed not to back-patch this change
any further than that, due to its complexity and the regex changes in
commit bea3d7e that it depends on.
Thomas Munro <thomas.munro@gmail.com> no 2022-05-10
pgstat-report-conflicts-immediately.patch diff --git i/src/backend/utils/activity/pgstat_database.c w/src/backend/utils/activity/pgstat_database.c
index 7149f22f729..bb36d73ec04 100644
no

All known versions for source package 'postgresql-16'

Links