| From: | "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net> |
|---|---|
| To: | Stef <svb(at)ucs(dot)co(dot)za> |
| Cc: | pgsql-admin(at)postgresql(dot)org, "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Fw: postgres logging |
| Date: | 2004-01-24 05:11:35 |
| Message-ID: | 1074921094.1630.1.camel@Bhuvan.bksys.co.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-sql |
> 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.
Regards,
A.Bhuvaneswaran
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martinelli Paolo A. | 2004-01-24 10:10:52 | R: Can't connect to phppgadmin |
| Previous Message | Mark Kirkwood | 2004-01-24 03:27:04 | Re: High Performance/High Reliability File system on SuSE64 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Arnold | 2004-01-24 06:24:37 | An order by question |
| Previous Message | Rajesh Kumar Mallah | 2004-01-23 18:16:30 | Re: [SQL] Database diagram |