Subject: Re: Fw: postgres logging
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>
In-Reply-To: <20040123141853.3c6457ef.svb@ucs.co.za>
References: <20040123141853.3c6457ef.svb@ucs.co.za>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-0+MYNYOOayh+Xj4tMDIw"
Message-Id: <1074921094.1630.1.camel@Bhuvan.bksys.co.in>
Mime-Version: 1.0
Date: Sat, 24 Jan 2004 10:41:35 +0530

--=-0+MYNYOOayh+Xj4tMDIw
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

> 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?
>=20

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

--=-0+MYNYOOayh+Xj4tMDIw
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQBAEf6GL2UFujVh8ToRAt1QAJ9BPPbIRaz7J80cX38pDzKOhBJrTACfVpZL
VOy1KI8gvk6QPdbQWbIkmyA=
=DleT
-----END PGP SIGNATURE-----

--=-0+MYNYOOayh+Xj4tMDIw--