"Nebojsa Pirocanac" <[EMAIL PROTECTED]> writes: > How can I get number of current connections to the database and is there an= > y way to identify connection. For example in Oracle I can get these informa= > tion from dynamic view V$SESSION.
In 7.2, yes. See http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/monitoring.html and read about pg_stat_activity. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
