Hi Bruce,
Thanks for quick answer. It's a great feature for newer releases for
PostgreSQL, but here I'm still using 7.1.2 (and few 7.0.3), so is there some
way in older versions?
Best regards.
----- Original Message -----
From: "Bruce Momjian" <pgman@candle.pha.pa.us>
To: "Vilson farias" <vilson.farias@digitro.com.br>
Cc: <pgsql-admin@postgresql.org>
Sent: Tuesday, March 26, 2002 11:36 AM
Subject: Re: [ADMIN] info request : listing active connections
> Vilson farias wrote:
> > Greetings,
> >
> > I've been looking for a way to list active connections from
> > clients to the postmaster. What kind of features does postgresql
> > has to make it possible? I would like to list users, ips and
> > maybe calling application and plataform. Now, the only way I
> > know is through ps -ef | grep post. Is there some system table
> > where I can find information about active connections?
>
> 7.2 has pg_stat_activity table that shows connections and queries.
>
> --
> Bruce Momjian | http://candle.pha.pa.us
> pgman@candle.pha.pa.us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>