<div dir="rtl"><div style="direction:ltr">

















<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">pool_version    
<span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">----------------------<span style="font-family:Arial,sans-serif"><span></span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">3.7.2
(amefuriboshi)<span lang="HE" dir="RTL" style="font-family:&quot;Times New Roman&quot;,serif"><span></span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span dir="LTR"></span><span dir="LTR"></span><span dir="LTR"></span><span dir="LTR"></span>(1
row)<span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span style="font-family:Arial,sans-serif"><span> </span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span lang="HE" dir="RTL" style="font-family:Arial,sans-serif"><span> </span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">psql
-d postgres -U postgres -h 127.0.0.1  -p 9999 -c &quot;show
pool_nodes&quot;;<span lang="HE" dir="RTL" style="font-family:&quot;Times New Roman&quot;,serif"><span></span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span style="font-family:Arial,sans-serif"><span> </span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">node_id
|    hostname     | port | status |
lb_weight |  role   | select_cnt | load_balance_node |
replication_delay <span lang="HE" dir="RTL" style="font-family:&quot;Times New Roman&quot;,serif"><span></span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span dir="LTR"></span><span dir="LTR"></span><span dir="LTR"></span><span dir="LTR"></span>---------+-----------------+------+--------+-----------+---------+------------+-------------------+-------------------<span style="font-family:Arial,sans-serif"><span></span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">0      
| pg1 | 5432 | up     | 0.333333  |
standby | 22565      |
true             
| 0<span lang="HE" dir="RTL" style="font-family:&quot;Times New Roman&quot;,serif"><span></span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif"><span dir="LTR"></span><span dir="LTR"></span><span dir="LTR"></span><span dir="LTR"></span>1      
| pg2 | 5432 | up     | 0.333333  |
primary | 10416      |
false             |
0<span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">2      
| pg3 | 5432 | up     | 0.333333  |
standby | 7686       |
false             |
0<span></span></p>

<p class="MsoNormal" style="text-align:left;direction:ltr;unicode-bidi:embed;margin:0cm 0cm 0.0001pt;font-size:11pt;font-family:Calibri,sans-serif">(3
rows)<span></span></p>





<br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div dir="ltr">2018-03-01 6:23 GMT+02:00 Tatsuo Ishii <span dir="ltr">&lt;<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>&gt;</span>:</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">&gt; I found a problem that had a big impact on our servers. I&#39;m using pgpool as<br>
&gt; a load balancer and pool connections manager. When a user tries to run a<br>
&gt; select query it redirects the query to the slave. If the user tries after<br>
&gt; that to run dml or ddl command he get error :<br>
&gt;<br>
&gt; ERROR: cannot execute CREATE TABLE in a read-only transaction<br>
&gt; SQL state: 25006<br>
&gt;<br>
&gt; Is there any way to solve this issue ? It means that once the pool<br>
&gt; redirected your session to the slaves you cant run any ddl/dml actions ..<br>
<br>
</span>Normaly Pgpool-II redirects any ddl/dml query to primary.  Can you<br>
show me following query results? I would like to confirm your problem.<br>
<br>
show pool_version;<br>
show pool_nodes;<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_<wbr>en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
</blockquote></div><br></div>