[Pgpool-hackers] show pool_status like...

[Jehan-Guillaume (ioguix) de Rorthais]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 13/09/2011 09:30, Tatsuo Ishii wrote:
>> Hi,
>>
>> While I took a look at MySQL manual (mainly for checking query cache
>> functionality), I noticed that MySQL has following syntx:
>>
>> show .... like 'foo%';
>>
>> I think this is usefull for "show pool_status" command since it has
>> lengthy output now.
>>
>> Usage of show pool_status and like will be something like:
>>
>> show pool_status like 'client_idle%' will only show the status of
>> client_idle_limit and client_idle_limit_in_recovery.

Did you read our answer from Guillaume Lelarge and me ?

I would rather push forward pgpool_adm which is much more cleaner in
many aspects and remove SHOW commands all together.

> In the mean time, I also thinking about "SET" command for
> pgpool-II. This would be usefull for change pgpool-II setting just for
> the session scope.
> 
> Comments?

What kind of parameters you would like to change for your session only ?

It leads me to another question. How could we *really* change the pgpool
settings permanently (in the postgresql fashion for user, database or
user+database) from SQL commands ?

Shouldn't we *require* PostgreSQL installed on the pooler server to be
able to store some pgpool settings that would overwrite the settings
from config files ?

> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp

- -- 
Jehan-Guillaume (ioguix) de Rorthais
http://www.dalibo.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk5wwI4ACgkQXu9L1HbaT6LfVgCgtwDklOUMNM5aqGK6C+OA/Wdf
tfQAoJ+z7fD82NHozSRJZzTwMpauNFGI
=8CE+
-----END PGP SIGNATURE-----