At Sun, 24 Oct 2021 20:31:37 -0700, Jeff Davis <pg...@j-davis.com> wrote in > On Mon, 2021-10-25 at 11:53 +0900, Kyotaro Horiguchi wrote: > > In other words, I don't think pg_signal_backends is not meant to > > control "log something on another session" or "rotate log file". > > It's > > danger that if we allow somewone to rotate log files, that means to > > allow same user to terminate another session. > > The current patch doesn't allow members of pg_signal_backend to rotate > the log file.
Ah, sorry, I might have confused with some other discussion. > Do you think pg_signal_backend is the wrong group to allow usage of > pg_log_backend_memory_contexts()? Alternatively, it could simply not Yes. I think it would be danger that who is allowed to dump memory context into log files by granting pg_signal_backend also can terminate other backends. > pg_log_backend_memory_contexts()? Alternatively, it could simply not > GRANT anything, and leave that up to the administrator to choose who > can use it. *I* prefer that. I'm not sure I'm the only one to think so, though.. regards. -- Kyotaro Horiguchi NTT Open Source Software Center