X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (neptune.hub.org [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP
	id DC111D1D11F; Fri, 23 Jan 2004 12:51:29 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 01782-08; Fri, 23 Jan 2004 08:51:01 -0400 (AST)
Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2])
	by svr1.postgresql.org (Postfix) with ESMTP
	id 1E4A0D1E86A; Fri, 23 Jan 2004 08:50:51 -0400 (AST)
Received: from localhost (localhost.localdomain [127.0.0.1])
	by ucsns.ucs.co.za (Postfix) with ESMTP
	id AF70E2BDDF; Fri, 23 Jan 2004 14:50:41 +0200 (SAST)
Received: from ucsns.ucs.co.za ([127.0.0.1])
	by localhost (ucsns.ucs.co.za [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 30828-07; Fri, 23 Jan 2004 14:50:30 +0200 (SAST)
Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253])
	by ucsns.ucs.co.za (Postfix) with ESMTP
	id B15292BDFA; Fri, 23 Jan 2004 14:50:25 +0200 (SAST)
Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3])
	by ucspost.ucs.co.za (Postfix) with ESMTP
	id 63C24DA463; Fri, 23 Jan 2004 14:50:25 +0200 (SAST)
Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148])
	by jhb.ucs.co.za (Postfix) with SMTP
	id BF98C973EC; Fri, 23 Jan 2004 14:50:25 +0200 (SAST)
Date: Fri, 23 Jan 2004 14:50:23 +0200
From: Stef <svb@ucs.co.za>
To: Stef <svb@ucs.co.za>
Cc: pgsql-admin@postgresql.org,
	pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: [SQL] Fw: postgres logging [SOLVED]
Message-Id: <20040123145023.25e6af79.svb@ucs.co.za>
In-Reply-To: <20040123141853.3c6457ef.svb@ucs.co.za>
References: <20040123141853.3c6457ef.svb@ucs.co.za>
X-Mailer: Sylpheed version 0.9.6claws (GTK+ 1.2.10; i386-pc-linux-gnu)
User-Agent: sillypheed-claws (anti-aliased)
X-Face: GFoC95e6r)_TTG>n~=uFLojP=O~4W@Ms]>:.DMm/')(<lrm)P;
	cAAeen^3Z`d/`t1M`X!B3Mz0L_UUN/n)o%rP)f&Yu}syx]R@;
	&mc=o&]6#=R!4G^lnCE6(%t1w3#VH8; &[NK=XA>z3\Mwj^XP@?
	Q:3";lD.OM1"^mDu}2NJ@US:)dO:U*iY5EM50&Tx.
X-Operating-System: sid
X-X-X: _-^-_
Mime-Version: 1.0
Content-Type: multipart/signed; protocol="application/pgp-signature";
	micalg="pgp-sha1";
	boundary="Signature=_Fri__23_Jan_2004_14_50_23_+0200_Z8hPBkTOuggchKMg"
X-Virus-Scanned: by amavisd-new at ucs.co.za
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200401/178
X-Sequence-Number: 12041

--Signature=_Fri__23_Jan_2004_14_50_23_+0200_Z8hPBkTOuggchKMg
Content-Type: text/plain; charset=US-ASCII
Content-Disposition: inline
Content-Transfer-Encoding: 7bit

Stef mentioned :
=> 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?

Erm... sorry ,

It appears my postgresql.conf is not an original. It didn't have
the log_pid option in. :)

--Signature=_Fri__23_Jan_2004_14_50_23_+0200_Z8hPBkTOuggchKMg
Content-Type: application/pgp-signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iQCVAwUBQBEYk7oLc+HYd7LFAQILlAP+M9n1VVzgyGuz8HbCvO/7Sw0A9aX4CspB
24/DwVHlDDzFE5mCOH+c0jl04kKszdmULX2ZCf+1fO4j2asaPr0rTWBMEQiUgYen
AsXnI3PHBhlQQOxz4sUgddmFoS+ZxHePWSBeIWoc2zuIJk8hrZF1zBDNL7shC7ao
dhPa5jM5R90=
=+q8C
-----END PGP SIGNATURE-----

--Signature=_Fri__23_Jan_2004_14_50_23_+0200_Z8hPBkTOuggchKMg--