Bruce Momjian <[EMAIL PROTECTED]> writes: > However, looking at the issue of backends all reloading their > postgresql.conf files at different times and sending output to different > files, I wonder if it would be best to create a log process and have > each backend connect to that. That way, all the logging happens in one > process.
That was something that bothered me too. I think in the patch as given, the GUC parameter determining the logfile name would have to be PGC_POSTMASTER, ie, you could not change it on the fly because the backends wouldn't all switch together. There may be some finer-grain timing issues as well. On the whole I think that capturing all the backends' stderr via a pipe and doing the file rotation in a single downstream process is a *much* cleaner solution. However, I've been saying that right along and haven't been listened to... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]