<div dir="ltr">Great!<div><br></div><div>Can you also explain what does this mean? I have 4 DB nodes and once I open a single DB connection in my client I see in pool_pools that it created 4 connections (one per backend) in the same pool. Why are they created together? Are they somehow related or are they independent connections like any other connection?</div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Sep 25, 2014 at 3:38 AM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Good catch! I'll fix the docs.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
<div class="HOEnZb"><div class="h5"><br>
> Hi<br>
><br>
> I think there is a mistake in the documentation.<br>
><br>
> It says this about "show pool_pools": "It'll always return<br>
> num_init_children*max_pool lines."<br>
><br>
> However I have multiple backends (load balance mode) and for me it returns<br>
> num_init_children*max_pool*num_backends lines.<br>
><br>
> For example num_init_children=1, max_pool=3, with 2 backends:<br>
><br>
> pool_pid | start_time | pool_id | backend_id | database |<br>
> username | create_time | majorversion | minorversion |<br>
> pool_counter | pool_backendpid | pool_connected<br>
> ----------+---------------------+---------+------------+---------------+------------------+---------------------+--------------+--------------+--------------+-----------------+-----------<br>
> -----<br>
> 10692 | 2014-09-23 16:25:09 | 0 | 0 | |<br>
> | | 0 | 0 | 0<br>
> | 0 | 0<br>
> 10692 | 2014-09-23 16:25:09 | 0 | 1 | |<br>
> | | 0 | 0 | 0<br>
> | 0 | 0<br>
> 10692 | 2014-09-23 16:25:09 | 1 | 0 | |<br>
> | | 0 | 0 | 0<br>
> | 0 | 0<br>
> 10692 | 2014-09-23 16:25:09 | 1 | 1 | |<br>
> | | 0 | 0 | 0<br>
> | 0 | 0<br>
> 10692 | 2014-09-23 16:25:09 | 2 | 0 | |<br>
> | | 0 | 0 | 0<br>
> | 0 | 0<br>
> 10692 | 2014-09-23 16:25:09 | 2 | 1 | |<br>
> | | 0 | 0 | 0<br>
> | 0 | 0<br>
><br>
><br>
> <a href="http://www.pgpool.net/docs/pgpool-II-3.3.3/doc/pgpool-en.html#master_slave_mode" target="_blank">http://www.pgpool.net/docs/pgpool-II-3.3.3/doc/pgpool-en.html#master_slave_mode</a><br>
><br>
> Thanks,<br>
> Yaron<br>
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div dir="ltr"><p style="text-align:left;direction:ltr">I'm on Twitter (<a href="http://twitter.com/#!/YaronNaveh" target="_blank">@YaronNaveh</a>)</p></div>
</div>