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

[Guillaume Lelarge]

Le 21/07/2010 10:11, Tatsuo Ishii a écrit :
>>> I would add pgsql_pid to pcp_proc_info anyway but in the mean time I
>>> understand your concern about pcp API (it's a shame that libppcp API
>>> is not documented anywhere BTW).
>>
>> OK, that would be good to have (the psql_pid column).
>>
>>> I admit that SELECT or SHOW is easier to use for appIications such as
>>> pgAdmin. So I do not object to add new SELECT or SHOW command you
>>> proposed. Would you like to create patches for this?
>>
>> Yeah, I will work on it right away. My patches for pgAdmin can wait, but
>> the one for pgPool can't if you want to get a release out at the end of the
>> month. I can also work on the documentation for the libppcp API. But first,
>> the SHOW statement.
> 
> Great. I and Kitagawa are working hard but it seems the actual release
> timing delays... like mid of August. Probably submitting by the end of
> July is enough.

OK, no problem.

I worked a bit on it tonight. I began with something really simple:
"show pool_version". And it works :)

guillaume at laptop:~/freeprojects/cvs.pgpool/head/pgpool-II$ psql -p 9999
postgres
psql (9.0beta3)
Saisissez « help » pour l'aide.

postgres=# show pool_version;
      pool_version
------------------------
 3.0-dev (umiyameboshi)
(1 ligne)


Next "show pool_processes", and "show pools". Not really sure if I need
to make a difference.


-- 
Guillaume
 http://www.postgresql.fr
 http://dalibo.com