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 4: Don't 'kill -9' the postmaster
