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" <[EMAIL PROTECTED]> To: "Vilson farias" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
