pgsql: citext: Allow tests to pass in OpenSSL FIPS mode

2023-11-06 Thread Peter Eisentraut
citext: Allow tests to pass in OpenSSL FIPS mode citext doesn't define an md5() function, so the value of using it in its tests is dubious. At best this shows in an indirect way that the cast from citext to text works. Avoid the issue and remove the test. Discussion: https://www.postgresql.org

pgsql: Fix the test 003_logical_slots.

2023-11-06 Thread Amit Kapila
Fix the test 003_logical_slots. pg_upgrade test 003_logical_slots was leaving files like delete_old_cluster.sh in the source directory for VPATH and meson builds. The fix is to change the directory to tmp_check before running the test as is done in the similar test in 002_pg_upgrade. Reported-by:

pgsql: Reorder two functions in inval.c

2023-11-06 Thread Michael Paquier
Reorder two functions in inval.c This file separates public and static functions with a separator comment, but two routines were not defined in a location reflecting that, so reorder them. Author: Aleksander Alekseev Reviewed-by: Álvaro Herrera, Michael Paquier Discussion: https://postgr.es/m/CA

Re: pgsql: Migrate logical slots to the new node during an upgrade.

2023-11-06 Thread Amit Kapila
On Mon, Nov 6, 2023 at 4:01 PM Peter Eisentraut wrote: > > On 26.10.23 04:14, Amit Kapila wrote: > > Migrate logical slots to the new node during an upgrade. > > Something in this patch is causing the pg_upgrade test to be run in the > source directory and leaving files such as delete_old_cluster.

pgsql: Make use of initReadOnlyStringInfo() in more places

2023-11-06 Thread David Rowley
Make use of initReadOnlyStringInfo() in more places f0efa5aec introduced the concept of "read-only" StringInfos which makes use of an existing, possibly not NUL terminated, buffer. Here we adjust two places that make use of StringInfos to receive data to avoid using appendBinaryStringInfo() in ca

pgsql: Stamp 11.22.

2023-11-06 Thread Tom Lane
Stamp 11.22. Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/fd851f9e4a13d814ac5d6059d732c7518111 Modified Files -- configure| 18 +- configure.in | 2 +- doc/bug.template

pgsql: Stamp 12.17.

2023-11-06 Thread Tom Lane
Stamp 12.17. Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/2fe2d1af14fd2fb5afeee94b94c4d8a34a829e32 Modified Files -- configure| 18 +- configure.in | 2 +- src/include/pg_config.h.win32

pgsql: Stamp 13.13.

2023-11-06 Thread Tom Lane
Stamp 13.13. Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/319310aa121285b1c7c036cb956a11bcc9d1bcb2 Modified Files -- configure| 18 +- configure.in | 2 +- 2 files changed, 10 insertions(+), 10 deletions(-)

pgsql: Stamp 14.10.

2023-11-06 Thread Tom Lane
Stamp 14.10. Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/33d5cf65f8c97d6bf085dffecb51c6a52d1f3f0d Modified Files -- configure| 18 +- configure.ac | 2 +- 2 files changed, 10 insertions(+), 10 deletions(-)

pgsql: Stamp 15.5.

2023-11-06 Thread Tom Lane
Stamp 15.5. Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/1e7f81e90741795d547c0290b4a82d84d518faac Modified Files -- configure| 18 +- configure.ac | 2 +- 2 files changed, 10 insertions(+), 10 deletions(-)

pgsql: Stamp 16.1.

2023-11-06 Thread Tom Lane
Stamp 16.1. Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/3edc6580c0e27fb8f13322efd255a88d20dda6c2 Modified Files -- configure| 18 +- configure.ac | 2 +- meson.build | 2 +- 3 files changed, 11 insertions(+), 11 deletions(-

pgsql: Remove distprep

2023-11-06 Thread Peter Eisentraut
Remove distprep A PostgreSQL release tarball contains a number of prebuilt files, in particular files produced by bison, flex, perl, and well as html and man documentation. We have done this consistent with established practice at the time to not require these tools for building from a tarball.

Re: pgsql: Migrate logical slots to the new node during an upgrade.

2023-11-06 Thread Andrew Dunstan
On 2023-11-06 Mo 05:31, Peter Eisentraut wrote: On 26.10.23 04:14, Amit Kapila wrote: Migrate logical slots to the new node during an upgrade. Something in this patch is causing the pg_upgrade test to be run in the source directory and leaving files such as delete_old_cluster.sh around the

pgsql: Set GUC "is_superuser" in all processes that set AuthenticatedUs

2023-11-06 Thread Noah Misch
Set GUC "is_superuser" in all processes that set AuthenticatedUserId. It was always false in single-user mode, in autovacuum workers, and in background workers. This had no specifically-identified security consequences, but non-core code or future work might make it security-relevant. Back-patch

pgsql: Set GUC "is_superuser" in all processes that set AuthenticatedUs

2023-11-06 Thread Noah Misch
Set GUC "is_superuser" in all processes that set AuthenticatedUserId. It was always false in single-user mode, in autovacuum workers, and in background workers. This had no specifically-identified security consequences, but non-core code or future work might make it security-relevant. Back-patch

pgsql: Set GUC "is_superuser" in all processes that set AuthenticatedUs

2023-11-06 Thread Noah Misch
Set GUC "is_superuser" in all processes that set AuthenticatedUserId. It was always false in single-user mode, in autovacuum workers, and in background workers. This had no specifically-identified security consequences, but non-core code or future work might make it security-relevant. Back-patch

pgsql: Set GUC "is_superuser" in all processes that set AuthenticatedUs

2023-11-06 Thread Noah Misch
Set GUC "is_superuser" in all processes that set AuthenticatedUserId. It was always false in single-user mode, in autovacuum workers, and in background workers. This had no specifically-identified security consequences, but non-core code or future work might make it security-relevant. Back-patch

pgsql: Set GUC "is_superuser" in all processes that set AuthenticatedUs

2023-11-06 Thread Noah Misch
Set GUC "is_superuser" in all processes that set AuthenticatedUserId. It was always false in single-user mode, in autovacuum workers, and in background workers. This had no specifically-identified security consequences, but non-core code or future work might make it security-relevant. Back-patch

pgsql: Set GUC "is_superuser" in all processes that set AuthenticatedUs

2023-11-06 Thread Noah Misch
Set GUC "is_superuser" in all processes that set AuthenticatedUserId. It was always false in single-user mode, in autovacuum workers, and in background workers. This had no specifically-identified security consequences, but non-core code or future work might make it security-relevant. Back-patch

pgsql: Set GUC "is_superuser" in all processes that set AuthenticatedUs

2023-11-06 Thread Noah Misch
Set GUC "is_superuser" in all processes that set AuthenticatedUserId. It was always false in single-user mode, in autovacuum workers, and in background workers. This had no specifically-identified security consequences, but non-core code or future work might make it security-relevant. Back-patch

pgsql: Translation updates

2023-11-06 Thread Peter Eisentraut
Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: db060e1afcf150db436cc05807372480754013e5 Branch -- REL_12_STABLE Details --- https://git.postgresql.org/pg/commitdiff/1cfa44269c1260fd7ca6a3b99767f9c157f4c048 Modified Files --

pgsql: Translation updates

2023-11-06 Thread Peter Eisentraut
Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: 15fb3bd712561df7018c37a08ced1b71a05d4c31 Branch -- REL_15_STABLE Details --- https://git.postgresql.org/pg/commitdiff/8913ed121e28dc354791dc3137633b7d390ed86a Modified Files --

pgsql: Translation updates

2023-11-06 Thread Peter Eisentraut
Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: 367d7493dba6944ccb2dcbf64a118224d8c7a81c Branch -- REL_14_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b5e4e6d21ab9d8dffee77fadd7a07861a5abf77a Modified Files --

pgsql: Translation updates

2023-11-06 Thread Peter Eisentraut
Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: e479b8315c5d7fb9ca95c23487ea80ae2630aa10 Branch -- REL_16_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b1227766a33558405db97505d9e430fd0884685b Modified Files --

pgsql: Translation updates

2023-11-06 Thread Peter Eisentraut
Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: 8174b9117de39641851e8c8f8f8cd300487a6f70 Branch -- REL_11_STABLE Details --- https://git.postgresql.org/pg/commitdiff/b29af71cd9a32b11e9e41f66c3068070a01e544d Modified Files --

pgsql: Translation updates

2023-11-06 Thread Peter Eisentraut
Translation updates Source-Git-URL: https://git.postgresql.org/git/pgtranslation/messages.git Source-Git-Hash: ef361a8dcaedb7f2f297023e894e25362345c7a8 Branch -- REL_13_STABLE Details --- https://git.postgresql.org/pg/commitdiff/0f1f3893baccf79be2794c41b3d37f1f460277df Modified Files --

Re: pgsql: Migrate logical slots to the new node during an upgrade.

2023-11-06 Thread Peter Eisentraut
On 26.10.23 04:14, Amit Kapila wrote: Migrate logical slots to the new node during an upgrade. Something in this patch is causing the pg_upgrade test to be run in the source directory and leaving files such as delete_old_cluster.sh around there. (This is under meson; there shouldn't be any n

pgsql: Add XMLText function (SQL/XML X038)

2023-11-06 Thread Daniel Gustafsson
Add XMLText function (SQL/XML X038) This function implements the standard XMLTest function, which converts text into xml text nodes. It uses the libxml2 function xmlEncodeSpecialChars to escape predefined entities (&"<>), so that those do not cause any conflict when concatenating the text node out

pgsql: doc: pg_resetwal: Add comments how the multipliers are derived

2023-11-06 Thread Peter Eisentraut
doc: pg_resetwal: Add comments how the multipliers are derived Reviewed-by: Aleksander Alekseev Discussion: https://www.postgresql.org/message-id/flat/[email protected] Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/6ceec8a1fe7a5

pgsql: pg_resetwal: Add more tests and test coverage

2023-11-06 Thread Peter Eisentraut
pg_resetwal: Add more tests and test coverage pg_resetwal had poor test coverage. There are some TAP tests, but they all run with -n, so they don't actually test the full functionality. (There is a non-dry-run call of pg_resetwal in the recovery test suite, but that is incidental.) This adds a

pgsql: Fix allocation of UniqueRelInfo

2023-11-06 Thread Alexander Korotkov
Fix allocation of UniqueRelInfo Reported-by: Richard Guo Discussion: https://postgr.es/m/CAMbWs4_STsG1PKQBuvQC8W4sPo3KvML3=jotjkluyquk3g8...@mail.gmail.com Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/93c85db3b5b8d8d15b10b4c66a0e6961028470d4 Modified Files