[pgpool-general: 3185] documentation error?

Yaron Naveh yaronn01 at gmail.com
Wed Sep 24 10:52:16 JST 2014


Hi

I think there is a mistake in the documentation.

It says this about "show pool_pools": "It'll always return
num_init_children*max_pool lines."

However I have multiple backends (load balance mode) and for me it returns
num_init_children*max_pool*num_backends lines.

For example num_init_children=1, max_pool=3, with 2 backends:

 pool_pid |     start_time      | pool_id | backend_id |   database    |
  username     |     create_time     | majorversion | minorversion |
pool_counter | pool_backendpid | pool_connected
----------+---------------------+---------+------------+---------------+------------------+---------------------+--------------+--------------+--------------+-----------------+-----------
-----
 10692    | 2014-09-23 16:25:09 | 0       | 0          |               |
               |                     | 0            | 0            | 0
       | 0               | 0
 10692    | 2014-09-23 16:25:09 | 0       | 1          |               |
               |                     | 0            | 0            | 0
       | 0               | 0
 10692    | 2014-09-23 16:25:09 | 1       | 0          |               |
               |                     | 0            | 0            | 0
       | 0               | 0
 10692    | 2014-09-23 16:25:09 | 1       | 1          |               |
               |                     | 0            | 0            | 0
       | 0               | 0
 10692    | 2014-09-23 16:25:09 | 2       | 0          |               |
               |                     | 0            | 0            | 0
       | 0               | 0
 10692    | 2014-09-23 16:25:09 | 2       | 1          |               |
               |                     | 0            | 0            | 0
       | 0               | 0


http://www.pgpool.net/docs/pgpool-II-3.3.3/doc/pgpool-en.html#master_slave_mode

Thanks,
Yaron
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20140924/174e76c2/attachment.html>


More information about the pgpool-general mailing list