David BOURIAUD wrote:
> Le vendredi 9 novembre 2007, vous avez écrit :
>
>> David BOURIAUD wrote:
>>
>>> if the run-time option is chosen, any message issued by any command, from
>>> connexion to all sql commands launched in any way by a user should go in
>>> a separate log file, that could be named log.username for example.
>>>
>> You can enable logging user name into postgres log and grep or some
>> other text utility help you to generate required log file.
>>
>>
> Thanks Zdenek for your answer.
> I know what you answered me, but in certain cases, using a text utility like
> grep is not suitable. I think of this when you get a many hundreds of Mo
> logfile at least, or when you need to track commands made by one peculiar
> user in real-time.
> That's why I thought that having a possibility to specify how log file(s)
> should be handled by postmaster could be of great help.
> I suggested an option to have one file per user, but one could think of having
> one file per IP address connected to the server, and so on. The way samba log
> files can be handled could be a good starting point, but I must admit that I
> don't have the programming skills required to code any patch...
> I hope that this answer will clarify my point of view.
>
>
This would involve a lot of work, I suspect. It's doable but very far
from simple. But you could use log_line_prefix to tag the lines and then
pipe the log through a preprocessor. That would split them in real time
without imposing the logic requirements on postgres.
cheers
andrew