Re: info request : listing active connections

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(at)candle(dot)pha(dot)pa(dot)us>
To: "Vilson farias" <vilson(dot)farias(at)digitro(dot)com(dot)br>
Cc: <pgsql-admin(at)postgresql(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> + If your life is a hard drive, | 830 Blythe Avenue
> + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
>