<div dir="ltr">Well, i thought so...before i enable the load balance mode become ON, i had tried it but no luck...<div><br></div><div><div>I&#39;ll try downgrade the version then..</div><div><br></div><div>Cheers</div><div><br></div><div><br></div><div>Agus</div></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Dec 23, 2016 at 2:57 AM, David Sisk -X (dsisk - TEKSYSTEMS INC at Cisco) <span dir="ltr">&lt;<a href="mailto:dsisk@cisco.com" target="_blank">dsisk@cisco.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">





<div lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="m_-8185058020181902673WordSection1">
<p class="MsoNormal"><a name="m_-8185058020181902673__MailEndCompose"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">I don’t believe you need to explicitly blacklist the nextval() function…PGPool will automatically blacklist it already (right folks?). 
 Remove that from the blacklist and see if it works correctly.<u></u><u></u></span></a></p>
<p class="MsoNormal"><span><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d"><u></u> <u></u></span></span></p>
<p class="MsoNormal"><span><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">Also, be aware that there are some bugs in 3.5.4 around load-balancing that might render it ineffective.  Test carefully
 with your specific application.<u></u><u></u></span></span></p>
<p class="MsoNormal"><span><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d"><u></u> <u></u></span></span></p>
<p class="MsoNormal"><span><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d">Cheers,<u></u><u></u></span></span></p>
<p class="MsoNormal"><span><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d"><u></u> <u></u></span></span></p>
<table class="m_-8185058020181902673MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="1086" style="width:407.25pt">
<tbody>
<tr>
<td colspan="3" style="padding:0in 0in 0in 0in">
<p class="MsoNormal"><span><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d"><img width="543" height="70" style="width:5.6562in;height:.7291in" id="m_-8185058020181902673Picture_x0020_1" src="cid:image002.png@01D25C63.BECAB8C0" alt="banner2"></span></span><span><span style="color:#1f497d"><u></u><u></u></span></span></p>
</td>
<td><span></span>
</td></tr>
<tr style="height:7.5pt">
<td style="padding:0in 0in 0in 0in;height:7.5pt">
<p class="MsoNormal"><span><span style="font-size:1.0pt;color:#1f497d"> <u></u><u></u></span></span></p>
</td>
<td><span></span>
</td><td style="padding:0in 0in 0in 0in;height:7.5pt"><span></span></td>
<td><span></span>
</td><td style="padding:0in 0in 0in 0in;height:7.5pt"><span></span></td>
<td><span></span>
</td></tr>
<tr>
<td nowrap valign="top" style="padding:0in 0in 0in .25in">
<p class="MsoNormal"><span><b><span style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#666666">David Sisk</span></b></span><span><span style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#666666"><u></u><u></u></span></span></p>
<p class="MsoNormal"><span><span style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#666666">Engineer - Software<u></u><u></u></span></span></p>
<p class="MsoNormal"><span></span><a href="mailto:dsisk@cisco.com" target="_blank"><span><span style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#666666;text-decoration:none">dsisk@cisco.com</span></span></a><span><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d"><u></u><u></u></span></span></p>
<p class="MsoNormal"><span><span style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#666666">Tel:
<u></u><u></u></span></span></p>
</td>
<td><span></span>
</td><td width="550" valign="top" style="width:206.25pt;padding:0in 0in 0in 15.0pt">
<p class="MsoNormal"><span><b><span style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#666666">Cisco Systems, Inc.<u></u><u></u></span></b></span></p>
<p class="MsoNormal"><span><span style="font-size:8.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#666666">7025-6 Kit Creek Road PO Box 14987<br>
RESEARCH TRIANGLE PARK<br>
27709-4987<br>
United States<br>
<a href="http://cisco.com" target="_blank">cisco.com</a><u></u><u></u></span></span></p>
</td>
<td><span></span>
</td><td style="padding:0in 0in 0in 0in"><span></span></td>
<td><span></span>
</td></tr>
</tbody>
</table>
<p class="MsoNormal"><span><span lang="EN-GB" style="color:#1f497d;display:none"><u></u> <u></u></span></span></p>
<table class="m_-8185058020181902673MsoNormalTable" border="0" cellspacing="0" cellpadding="0" width="800" style="width:300.0pt">
<tbody>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal"><span><span style="font-size:7.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#009900"><img border="0" width="18" height="19" style="width:.1875in;height:.1979in" id="m_-8185058020181902673Picture_x0020_3" src="cid:image004.png@01D25C63.BECAB8C0" alt="http://www.cisco.com/assets/swa/img/thinkbeforeyouprint.gif">Think
 before you print.<u></u><u></u></span></span></p>
</td>
<td><span></span>
</td></tr>
<tr>
<td style="padding:0in 15.0pt 0in .25in">
<p class="MsoNormal"><span><span style="font-size:7.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#999999">This email may contain confidential and privileged material for the sole use of the intended recipient. Any review, use,
 distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender by reply email and delete all copies of this message.<u></u><u></u></span></span></p>
<p class="MsoNormal"><span><span style="font-size:7.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#999999">Please
</span></span><a href="http://www.cisco.com/web/about/doing_business/legal/cri/index.html" title="Legal Information" target="_blank"><span><span style="font-size:7.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#0e58a0">click here</span></span><span></span></a><span><span style="font-size:7.5pt;font-family:&quot;Arial&quot;,sans-serif;color:#999999">
 for Company Registration Information.<u></u><u></u></span></span></p>
</td>
<td><span></span>
</td></tr>
</tbody>
</table>
<p class="MsoNormal"><span><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif;color:#1f497d"><u></u> <u></u></span></span></p>
<span></span>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,sans-serif"> <a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-bounces@pgpool.<wbr>net</a> [mailto:<a href="mailto:pgpool-general-bounces@pgpool.net" target="_blank">pgpool-general-<wbr>bounces@pgpool.net</a>]
<b>On Behalf Of </b>Agus Syafaat<br>
<b>Sent:</b> Thursday, December 22, 2016 11:32 AM<br>
<b>To:</b> <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<b>Subject:</b> [pgpool-general: 5196] Error cannot execute nextval while had configure black_function_list on pgpool.conf<u></u><u></u></span></p><div><div class="h5">
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<div>
<p class="MsoNormal">Hello,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I&#39;m new member in pgpool..:)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">I had problem when setting up load balancing on pgpool (i use version 3.5.4) connected to postgresql 9.5 with stream replication ( using repmgr). I always getting error &quot;ERROR: cannot execute nextval() in a read-only transaction&quot; while
 i had configure black_function_list for sequences. Kindly advice whats going wrong..<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">Below is my pgpool configuration :<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"># - pgpool Connection Settings -<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">listen_addresses = &#39;localhost&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Host name or IP address to listen on:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # &#39;*&#39; for all, &#39;&#39; for no TCP/IP connections<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # (change requires restart)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">port = 15982<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Port number<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # (change requires restart)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">socket_dir = &#39;/var/run/postgresql&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Unix domain socket path<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # The Debian package defaults to<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # /var/run/postgresql<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # (change requires restart)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">listen_backlog_multiplier = 2<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Set the backlog parameter of listen(2) to<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                                                   # num_init_children * listen_backlog_multiplier.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # (change requires restart)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">serialize_accept = off<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # whether to serialize accept() call to avoid thundering herd problem<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # (change requires restart)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"># - pgpool Communication Manager Connection Settings -<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">pcp_listen_addresses = &#39;*&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Host name or IP address for pcp process to listen on:<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # &#39;*&#39; for all, &#39;&#39; for no TCP/IP connections<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # (change requires restart)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">pcp_port = 9898<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Port number for pcp<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # (change requires restart)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">pcp_socket_dir = &#39;/var/run/postgresql&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Unix domain socket path for pcp<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # The Debian package defaults to<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # /var/run/postgresql<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # (change requires restart)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"># - Backend Connection Settings -<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">backend_hostname0 = &#39;pg-prod-01a&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Host name or IP address to connect to for backend 0<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">backend_port0 = 5432<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Port number for backend 0<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">backend_weight0 = 0<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Weight for backend 0 (only in load balancing mode)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">backend_data_directory0 = &#39;/opt/ebs/postgresql/9.5/main&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Data directory for backend 0<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">backend_flag0 = &#39;ALLOW_TO_FAILOVER&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Controls various backend behavior<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # ALLOW_TO_FAILOVER or DISALLOW_TO_FAILOVER<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">backend_hostname1 = &#39;pg-prod-01b&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">backend_port1 = 5432<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">backend_weight1 = 1<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">backend_data_directory1 = &#39;/opt/ebs/postgresql/9.5/main&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">backend_flag1 = &#39;ALLOW_TO_FAILOVER&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"># - Authentication -<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">enable_pool_hba = on<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Use pool_hba.conf for client authentication<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">pool_passwd = &#39;pool_passwd&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # File name of pool_passwd for md5 authentication.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # &quot;&quot; disables pool_passwd.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # (change requires restart)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">authentication_timeout = 60<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Delay in seconds to complete client authentication<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # 0 means no timeout.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"># LOAD BALANCING MODE<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">#-----------------------------<wbr>------------------------------<wbr>-------------------<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">load_balance_mode = on<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Activate load balancing mode<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # (change requires restart)<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">ignore_leading_white_space = on<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Ignore leading white spaces of each query<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">white_function_list = &#39;&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Comma separated list of function names<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # that don&#39;t write to database<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Regexp are accepted<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">black_function_list = &#39;nextval,setval&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Comma separated list of function names<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # that write to database<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                   # Regexp are accepted<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">database_redirect_preference_<wbr>list = &#39;&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                                                   # comma separated list of pairs of database and node id.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                                                   # example: postgres:primary,mydb[0-4]:1,<wbr>mydb[5-9]:2&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                                                   # valid for streaming replicaton mode only.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">app_name_redirect_preference_<wbr>list = &#39;&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                                                   # comma separated list of pairs of app name and node id.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                                                   # example: &#39;psql:primary,myapp[0-4]:1,<wbr>myapp[5-9]:standby&#39;<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                                                   # valid for streaming replicaton mode only.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">allow_sql_comments = off<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                                                   # if on, ignore SQL comments when judging if load balance or<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                                                   # query cache is possible.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                                                   # If off, SQL comments effectively prevent the judgment<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">                                                                   # (pre 3.4 behavior).<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Thanks in advance,<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Regards<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal">Agus<u></u><u></u></p>
</div>
</div>
</div></div></div>
</div>

</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature" data-smartmail="gmail_signature">Warm Regards,<br><br>Agus Syafa&#39;at</div>
</div>