pgsql: Adjust interaction of CREATEROLE with role properties.

2023-01-24 Thread Robert Haas
Adjust interaction of CREATEROLE with role properties. Previously, a CREATEROLE user without SUPERUSER could not alter REPLICATION users in any way, and could not set the BYPASSRLS attribute. However, they could manipulate the CREATEDB property even if they themselves did not possess it. With thi

Re: pgsql: instr_time: Represent time as an int64 on all platforms

2023-01-24 Thread Andres Freund
Hi, On 2023-01-23 01:20:54 -0500, Tom Lane wrote: > I'm inclined to think that we should fix the plpython code to be rigorous > about including everything else we need before including the Python > headers. I tried that, but I think it's hard with the current split of plpython headers. Several of

pgsql: Improve exclude pattern file processing in pgindent

2023-01-24 Thread Andrew Dunstan
Improve exclude pattern file processing in pgindent This makes two small changes that will improve pgindent's usefulness in a git hook. First, it looks for the exclude file relative to the current directory. And second, it applies the filters to filenames given on the command line as well as those

pgsql: Update more obsolete multixact.c comments.

2023-01-24 Thread Peter Geoghegan
Update more obsolete multixact.c comments. Update some remaining comments in multixact.c that still described SLRU truncation as happening in the checkpointer, rather than during VACUUM. Follow-up to commit 5212d447. Shi yu, with tweaks by me. Author: Shi yu Discussion: https://postgr.es/m/os

pgsql: Process pending postmaster work before connections.

2023-01-24 Thread Thomas Munro
Process pending postmaster work before connections. Modify the new event loop code from commit 7389aad6 so that it checks for work requested by signal handlers even if it doesn't see a latch event yet. This gives priority to shutdown and reload requests where the latch will be reported later in t

pgsql: Rename contrib module basic_archive to basic_wal_module

2023-01-24 Thread Michael Paquier
Rename contrib module basic_archive to basic_wal_module This rename is in preparation for the introduction of recovery modules, where basic_wal_module will be used as a base template for the set of callbacks introduced. The former name did not really reflect all that. Author: Nathan Bossart Disc