Guillaume Smet escribió: > 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.
So add the session ID (%c) to log_line_prefix. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings