Re: Question about trace session

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Lucas Itamar <meuname(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Question about trace session
Date: 2005-03-27 06:52:43
Message-ID: 20050327065243.GA45898@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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/

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jos van Roosmalen 2005-03-27 15:19:33 Help: my table is corrupt!
Previous Message Christopher Kings-Lynne 2005-03-27 05:24:34 Re: [pgsql-advocacy] Function which gives back the nearest neighbours