X-Original-To: pgsql-docs@postgresql.org Received: from jester.inquent.com (unknown [216.208.117.7]) by postgresql.org (Postfix) with ESMTP id C4EE5475FC6 for ; Wed, 5 Mar 2003 12:50:06 -0500 (EST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by jester.inquent.com (8.12.6/8.12.6) with ESMTP id h25HosNU020407; Wed, 5 Mar 2003 12:50:55 -0500 (EST) (envelope-from rbt@rbt.ca) Subject: Re: Monitoring From: Rod Taylor To: "Delao, Darryl W" Cc: pgsql-docs@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-dYJLsLhJoPFBmKEIqXXm" Organization: Message-Id: <1046886654.19527.39.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 Date: 05 Mar 2003 12:50:54 -0500 X-Archive-Number: 200303/5 X-Sequence-Number: 1683 --=-dYJLsLhJoPFBmKEIqXXm Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Wed, 2003-03-05 at 12:21, Delao, Darryl W wrote: > Anyone aware of any tool or command line option to view active and inacti= ve > postgres connections? Is there a setting in postgres that sets the > Time_Wait to something lower? Also, is there a command to kill a specific > connection at any given time? No, but I'd love something that can throw an SNMP event when queries are taking too long -- or someone is idling in a transaction... --=20 Rod Taylor PGP Key: http://www.rbt.ca/rbtpub.asc --=-dYJLsLhJoPFBmKEIqXXm Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (FreeBSD) iD8DBQA+Zjj+6DETLow6vwwRAq/jAJ9JzOtYyiidE/E3w5poMZU6rEqD5QCeOVHD SM7RtXo7gR5W9XLvRsZXFq4= =AQo5 -----END PGP SIGNATURE----- --=-dYJLsLhJoPFBmKEIqXXm--