[Pgpool-hackers] Admin interface, statistics views, etc

[Guillaume Lelarge]

Le 03/08/2010 13:29, Guillaume Lelarge a écrit :
> Le 03/08/2010 12:23, Tatsuo Ishii a écrit :
>>> Le 03/08/2010 03:48, Tatsuo Ishii a écrit :
>>>>>>> AFAICT, it works really good. We still miss pgsql_pid. And should I add
>>>>>>> some other reports? what do other people need?
>>>>>>>
>>>>>>
>>>>>> No comments on this patch? meaning I should commit it or not?
>>>>>
>>>>> I was waiting for you add pgsql_pid. Have you done it?
>>>>
>>>> I have added new function:
>>>> /*
>>>>  * Return pointer to i th child, j th connection pool and k th backend
>>>>  * of connection info on shmem.
>>>>  */
>>>> ConnectionInfo *pool_coninfo(int child, int connection_pool, int backend)
>>>>
>>>> I hope this will make your implementation regarding pgsql_pid easier.
>>>> For example, pool_coninfo(10, 0, 1) will return pointer to
>>>> ConnectionInfo corresponds to 1th backend pid which is in 0th
>>>> connection pool in 10th pgpool child.
>>>
>>> Sorry for not answering sooner. I thought you were working on adding
>>> pgsql_pid. There was a little misunderstanding :)
>>
>> Oh, I thought I woould work on pcp command, you would work on show
>> command. 
>>
> 
> No problem :)
> 
> I'll work on it ASAP.
> 

With your last commits, it makes it quite easy to do. Here is my new
patch. 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?


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgpool_show_v2.patch
Type: text/x-diff
Size: 36065 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-hackers/attachments/20100805/93bdba4e/attachment-0001.bin>