Re: [ADMIN] Fw: postgres logging - Mailing list pgsql-sql

From A.Bhuvaneswaran
Subject Re: [ADMIN] Fw: postgres logging
Date
Msg-id 1074921094.1630.1.camel@Bhuvan.bksys.co.in
Whole thread Raw
In response to Fw: postgres logging  (Stef <svb@ucs.co.za>)
List 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

pgsql-sql by date:

Previous
From: Rajesh Kumar Mallah
Date:
Subject: Re: [ADMIN] Database diagram
Next
From: James Taylor
Date:
Subject: Label Security