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 CC68DD1D11F; Fri, 23 Jan 2004 12:20:04 +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 87212-08; Fri, 23 Jan 2004 08:19:36 -0400 (AST) Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2]) by svr1.postgresql.org (Postfix) with ESMTP id 5E3A2D1B48C; Fri, 23 Jan 2004 08:19:27 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by ucsns.ucs.co.za (Postfix) with ESMTP id 279432BD7A; Fri, 23 Jan 2004 14:19:20 +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 30051-02; Fri, 23 Jan 2004 14:19:08 +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 7DAD02BD59; Fri, 23 Jan 2004 14:18:55 +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 ABBF5DA463; Fri, 23 Jan 2004 14:18:55 +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 5D9EB973ED; Fri, 23 Jan 2004 14:18:56 +0200 (SAST) Date: Fri, 23 Jan 2004 14:18:53 +0200 From: Stef To: pgsql-admin@postgresql.org Cc: pgsql-sql@postgresql.org Subject: Fw: postgres logging Message-Id: <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/')(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_18_53_+0200_EnT9DQb6OZi_M/c1" X-Virus-Scanned: by amavisd-new at ucs.co.za X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/177 X-Sequence-Number: 12040 --Signature=_Fri__23_Jan_2004_14_18_53_+0200_EnT9DQb6OZi_M/c1 Content-Type: multipart/mixed; boundary="Multipart=_Fri__23_Jan_2004_14_18_53_+0200_p6e_l=j5GUe1f=nN" --Multipart=_Fri__23_Jan_2004_14_18_53_+0200_p6e_l=j5GUe1f=nN Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit Hi all, I've switched on log_statement in postgresql.conf for debugging purposes. I tried logging connections and pids as well, but I need to match up the logged statements to specific connections. 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? Kind Regards Stefan --Multipart=_Fri__23_Jan_2004_14_18_53_+0200_p6e_l=j5GUe1f=nN Content-Type: application/pgp-signature; name="00000009.mimetmp" Content-Disposition: attachment; filename="00000009.mimetmp" Content-Transfer-Encoding: base64 LS0tLS1CRUdJTiBQR1AgU0lHTkFUVVJFLS0tLS0KVmVyc2lvbjogR251UEcg djEuMi40IChHTlUvTGludXgpCgppUUNWQXdVQlFCRU9lcm9MYytIWWQ3TEZB UUluZFFQOERJQ04yM3ZJSXRwNmVWb2FjUG1LQjJMdTljblNnWHA2ClJuNjV2 UDUxYnE1MkpHTVppUEpIVHNnbW9vTGpoVmZtdmFvRHM2UVBvZEEyUXhQZUpB VEVDRm9rQXpwOGtPRnMKTHVjb04vQzd5cTJkNjQxM1BUQWxmRnpDd1VZOW5K Y1ZEV2RUbTZvVXI4bDVJaTNCZlY0ZUlEWkhkOEpGMU1IUQpzRzlNdVN1aUsz MD0KPXZneVkKLS0tLS1FTkQgUEdQIFNJR05BVFVSRS0tLS0tCgo= --Multipart=_Fri__23_Jan_2004_14_18_53_+0200_p6e_l=j5GUe1f=nN-- --Signature=_Fri__23_Jan_2004_14_18_53_+0200_EnT9DQb6OZi_M/c1 Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iQCVAwUBQBERMLoLc+HYd7LFAQK7rQP+IVcyQiCUaBsBrP/hDUsuqm+zt8rVWuHr MMaeCz5gdZ6olVPFL7HmTkS4CfZFsMfFm8LDIxwNaZumySTHS/u6eg8pr8AZq5kb Z0wC7zh+8DxguYbFs09P0HucCgQz8d3isYJCYSdTaRcAnK+ltj2HK23t9aaYHQza H6L428W0Was= =MXE7 -----END PGP SIGNATURE----- --Signature=_Fri__23_Jan_2004_14_18_53_+0200_EnT9DQb6OZi_M/c1--