> The postmaster logs to a separate log file, but at the moment
> it's impossible to tell which sql comes from which connection.
> Is there an easy way to accomplish this?
The PID of the connected process is prepended to every log statement.
You can make use of this to know which sql comes from which connection.
In response to
pgsql-admin by date
|Next:||From: Martinelli Paolo A.||Date: 2004-01-24 10:10:52|
|Subject: R: Can't connect to phppgadmin|
|Previous:||From: Mark Kirkwood||Date: 2004-01-24 03:27:04|
|Subject: Re: High Performance/High Reliability File system on SuSE64|
pgsql-sql by date
|Next:||From: David Arnold||Date: 2004-01-24 06:24:37|
|Subject: An order by question|
|Previous:||From: Rajesh Kumar Mallah||Date: 2004-01-23 18:16:30|
|Subject: Re: [SQL] Database diagram|