Re: pgsql: Implement pg_wal_replay_wait() stored procedure

2024-10-11 Thread Alexander Korotkov
Hi! On Sun, Sep 29, 2024 at 1:40 PM Alexander Korotkov wrote: > > Thank you for your review. > > On Fri, Sep 27, 2024 at 7:35 AM Michael Paquier wrote: > > > > On Fri, Sep 20, 2024 at 03:00:20PM +0300, Alexander Korotkov wrote: > > > Please, check the attached patchset for implementation of prop

pgsql: Avoid mixing custom and OpenSSL BIO functions

2024-10-11 Thread Daniel Gustafsson
Avoid mixing custom and OpenSSL BIO functions PostgreSQL has for a long time mixed two BIO implementations, which can lead to subtle bugs and inconsistencies. This cleans up our BIO by just just setting up the methods we need. This patch does not introduce any functionality changes. The following

pgsql: Add pg_ls_summariesdir().

2024-10-11 Thread Nathan Bossart
Add pg_ls_summariesdir(). This function returns the name, size, and last modification time of each regular file in pg_wal/summaries. This allows administrators to grant privileges to view the contents of this directory without granting privileges on pg_ls_dir(), which allows listing the contents

pgsql: Mark consume_xids test functions VOLATILE and PARALLEL UNSAFE

2024-10-11 Thread Heikki Linnakangas
Mark consume_xids test functions VOLATILE and PARALLEL UNSAFE Both functions advance the transaction ID, which modifies the system state. Thus, they should be marked as VOLATILE. Additionally, they call the AssignTransactionId function, which cannot be invoked in parallel mode, so they should be

pgsql: Fix typo in connection limits test

2024-10-11 Thread Daniel Gustafsson
Fix typo in connection limits test Spotted while doing post-commit review. Branch -- master Details --- https://git.postgresql.org/pg/commitdiff/682512dca870f46cf2c0b9e227702dffc5de5ef0 Modified Files -- src/test/postmaster/t/001_connection_limits.pl | 2 +- 1 file changed, 1

pgsql: Use deconstruct_array_builtin instead of deconstruct_array

2024-10-11 Thread Álvaro Herrera
Use deconstruct_array_builtin instead of deconstruct_array Commit 062a84442424 introduced use of deconstruct_array when deconstruct_array_builtin can be used instead. Do that to save some code. Author: Bertrand Drouvot Discussion: https://postgr.es/m/zwi5g2gzlux1n...@ip-10-97-1-34.eu-west-3.co