> >> I still have an issue and perhaps you have an idea on how to > >> resolve it. Is there a way to know which connection is the active one in > >> a pool? > > > > Good question:-) I never thought about it. Let me check... > > Just to give you my idea. If you do a "SHOW pool_processes", it gives > you a list of all processes. It also shows the database and the username > of the first connection in the pool of the process. And it would be best > if it can show you the database of the currently active connection in > the pool. BTW, the same could apply to pcp_proc_info: adding a simple > column showing the active connection in the pool handled by the > specified process.
I have just checked in for this. i.e. "connected" menmber is added to ConnectionInfo which indicates if this connection pool is connected from frontend or not. Please take a look at recent my commit. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp _______________________________________________ Pgpool-hackers mailing list Pgpool-hackers@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-hackers
