From: A.Bhuvaneswaran <bhuvan@symonds.net>
To: Stef <svb@ucs.co.za>
Cc: pgsql-admin@postgresql.org, "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: Re: Fw: postgres logging
Date: Sat, 24 Jan 2004 10:41:35 +0530
Message-ID: <1074921094.1630.1.camel@Bhuvan.bksys.co.in> (raw)
In-Reply-To: <20040123141853.3c6457ef.svb@ucs.co.za>
References: <20040123141853.3c6457ef.svb@ucs.co.za>
> 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
Attachments:
signature.asc (application/pgp-signature, 231B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: bhuvan@symonds.net, svb@ucs.co.za
Subject: Re: Fw: postgres logging
In-Reply-To: <1074921094.1630.1.camel@Bhuvan.bksys.co.in>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox