Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group