<div><div dir="auto">Thank you <span style="color:rgb(49,49,49);word-spacing:1px">Tatsuo. Please accept my gratitude. This is so helpful. I will get back to you if i have any questions.</span></div><div dir="auto"><span style="color:rgb(49,49,49);word-spacing:1px"><br></span></div><div dir="auto"><span style="color:rgb(49,49,49);word-spacing:1px">Thank you again</span></div><div dir="auto"><span style="color:rgb(49,49,49);word-spacing:1px">SD </span></div><div dir="auto"><br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr"> On Sun, Sep 1, 2019 at 3:11 AM Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">> Hi<br>
> <br>
> I am looking for some clear document to setup pgpool for cluster and load<br>
> balancing. I want to try streaming replication with 1 primary and 2 read<br>
> only nodes using pgpool as load balancer. Any help would be appreciated. i<br>
> am using red hat linux server for the setup but most documents talk about<br>
> ubuntu.<br>
<br>
There are some examples in the official documentation.<br>
<br>
The closest one is here:<br>
<br>
<a href="http://www.pgpool.net/docs/latest/en/html/example-cluster.html" rel="noreferrer" target="_blank">http://www.pgpool.net/docs/latest/en/html/example-cluster.html</a><br>
<br>
The differences are:<br>
<br>
1) the example assumes CentOS7, but should be applied to Red Hat 7 as well.<br>
<br>
2) the example is for 1 read only node, while yours is 2. But it's<br>
should be easy to add one more read only node.<br>
<br>
3) the example explains "watchdog", which is HA feature for Pgpool-II<br>
itself. i.e. assuming to use multiple Pgpool-II. If you do not need<br>
the feature, you could skip the "watchdog" section.<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" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
</blockquote></div></div>