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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
