From: Michael Fuhr <mike@fuhr.org>
To: Lucas Itamar <meuname@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Question about trace session
Date: Sat, 26 Mar 2005 23:52:43 -0700
Message-ID: <20050327065243.GA45898@winnie.fuhr.org> (raw)
In-Reply-To: <BAY21-F20812A062B591CF5F86CB1B54D0@phx.gbl>
References: <BAY21-F20812A062B591CF5F86CB1B54D0@phx.gbl>
On Mon, Mar 21, 2005 at 05:34:19PM +0000, Lucas Itamar wrote:
> My name is Lucas and I would like to know if somebody knows how to trace
> (or kill) the sessions in PostgreSql. Someway to see the connected users,
> his IPs, machines, etc.
See the "Monitoring Database Activity" chapter in the PostgreSQL
documentation. You don't say what version you're running; here's
a link to the documentation for the latest release:
http://www.postgresql.org/docs/8.0/interactive/monitoring.html
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mike@fuhr.org, meuname@hotmail.com
Subject: Re: Question about trace session
In-Reply-To: <20050327065243.GA45898@winnie.fuhr.org>
References: <BAY21-F20812A062B591CF5F86CB1B54D0@phx.gbl> <20050327065243.GA45898@winnie.fuhr.org>
* 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