On 2/19/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
I don't think the syslog option is so nice to use these days; the redirect_stderr stuff is more powerful and easy to use.
Did you already analyze logs of a highly loaded platform using stderr? It's impossible to guarantee the consistency of the queries because you can have: Query 1 Line 1 Query 2 Line 1 Query 3 Line 1 Query 1 Line 2 Query 2 Line 2 Query 1 Line 3 Query 3 Line 2 (each query is run on a different backend). With stderr you don't have sufficient information to know the query you should append the text to. Syslog adds useful context information (pid, command line, command number) which allows you to guarantee the consistency. It's a real problem for us and that's why I don't recommend using stderr when you use pgFouine. Moreover, syslog can send the log to the network which moves the I/O needed to log on another box and it's necessary in our case. -- Guillaume ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly