It needs to exist in the primary a script called pgpool_remote_start in your database cluster directory, take this as an example:<br><br><a href="http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/pgpool_remote_start">http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/pgpool_remote_start</a><br>
<br>it brings up the new node.<br><br><div class="gmail_quote">2013/6/17 Athanasios Kostopoulos <span dir="ltr"><<a href="mailto:athanasios.kostopoulos@classmarkets.com" target="_blank">athanasios.kostopoulos@classmarkets.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div>I did installed it by hand and now I am getting the following, non-informative message ...</div><div>
Jun 17 15:42:11 lb pgpool: 2013-06-17 15:42:11 ERROR: pid 5438: exec_remote_start: pgpool_remote_start failed: ERROR: pgpool_remote_start failed</div>
<div>Jun 17 15:42:11 lb pgpool: </div><div>Jun 17 15:42:11 lb pgpool: 2013-06-17 15:42:11 ERROR: pid 5438: start_recovery: remote start failed</div><div><br></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra">
<br><br><div class="gmail_quote">
On Mon, Jun 17, 2013 at 3:30 PM, Rene Romero Benavides <span dir="ltr"><<a href="mailto:rene.romero.b@gmail.com" target="_blank">rene.romero.b@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
You need to install the online recovery functions in the master node as described here:<br><a href="http://pgpool.projects.pgfoundry.org/pgpool-II/doc/pgpool-en.html#online-recovery" target="_blank">http://pgpool.projects.pgfoundry.org/pgpool-II/doc/pgpool-en.html#online-recovery</a><div>
<div><br>
<br><div class="gmail_quote">2013/6/17 Athanasios Kostopoulos <span dir="ltr"><<a href="mailto:athanasios.kostopoulos@classmarkets.com" target="_blank">athanasios.kostopoulos@classmarkets.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr">Thanks for the quick reply Theodotos. I got a setup up and running in 2 VMs which works fine under ideal conditions. However when I simulate a network failure and recovery I get the following:<div><br></div>
<div>from the command line:</div><div><br></div><div>pcp_recovery_node 10 $HOST $PORT $USER $PASS $NODE_ID # all properly set</div><div><br></div><div><div>DEBUG: send: tos="R", len=46</div>
<div>DEBUG: recv: tos="r", len=21, data=AuthenticationOK</div><div>DEBUG: send: tos="D", len=6</div><div>DEBUG: recv: tos="e", len=20, data=recovery failed</div><div>DEBUG: command failed. reason=recovery failed</div>
<div>DEBUG: send: tos="X", len=4</div></div><div><br></div><div>from /var/log/messages</div><div><div>Jun 17 14:53:41 lb pgpool: 2013-06-17 14:53:41 LOG: pid 5438: 1st stage is done</div><div>Jun 17 14:53:41 lb pgpool: 2013-06-17 14:53:41 LOG: pid 5438: starting 2nd stage</div>
<div>Jun 17 14:53:41 lb pgpool: 2013-06-17 14:53:41 LOG: pid 5438: all connections from clients have been closed</div><div>Jun 17 14:53:41 lb pgpool: 2013-06-17 14:53:41 LOG: pid 5438: CHECKPOINT in the 2nd stage done</div>
<div>Jun 17 14:53:41 lb pgpool: 2013-06-17 14:53:41 ERROR: pid 5438: exec_remote_start: pgpool_remote_start failed: ERROR: function pgpool_remote_start(unknown, unknown) does not exist</div><div>Jun 17 14:53:41 lb pgpool: LINE 1: SELECT pgpool_remote_start('192.168.10.3', '/data1')</div>
<div>Jun 17 14:53:41 lb pgpool: ^</div><div>Jun 17 14:53:41 lb pgpool: HINT: No function matches the given name and argument types. You might need to add explicit type casts.</div><div>Jun 17 14:53:41 lb pgpool: </div>
<div>Jun 17 14:53:41 lb pgpool: 2013-06-17 14:53:41 ERROR: pid 5438: start_recovery: remote start failed</div><div><br></div><div>any ideas anyone on how I can address this problem? I am using:</div><div>Debian 7.1 wheezy</div>
<div>Postgres 9.1 that comes with Debian</div><div>pgpool-II version 3.1.3 (hatsuiboshi)<br></div><div><br></div></div></div><div><div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Jun 14, 2013 at 11:55 PM, Theodotos Andreou <span dir="ltr"><<a href="mailto:theo@ubuntucy.org" target="_blank">theo@ubuntucy.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Yes, they call it "replication mode".
Ini this mode rwrite queries hit both servers and read (SELECT)
queries are load-balanced.<br>
<br>
<a href="http://www.pgpool.net/docs/latest/pgpool-en.html#replication_mode" target="_blank">http://www.pgpool.net/docs/latest/pgpool-en.html#replication_mode</a><div><br>
<br>
On 14/06/2013 06:56 μμ, Athanasios Kostopoulos wrote:<br>
</div></div>
<blockquote type="cite"><div>
<div dir="ltr">Dear list,
<div>is pgpool capable of providing 2-master replication? I have
come across a lot of information for master-slave setups but
was not able to find something for master-master. Thanks in
advance for your replies.</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div><pre>_______________________________________________
pgpool-general mailing list
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<br>
</div>
</blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br><br clear="all"><br></div></div><span><font color="#888888">-- <br>El genio es 1% inspiración y 99% transpiración.<br>Thomas Alva Edison<br><a href="http://pglearn.blogspot.mx/" target="_blank">http://pglearn.blogspot.mx/</a><br>
<div style="line-height:130%;text-align:left;font-size:10px;overflow:hidden;margin-left:0px;word-wrap:break-word;margin-top:0px;padding:0px">
</div><div><br></div>
</font></span></blockquote></div><br></div>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>El genio es 1% inspiración y 99% transpiración.<br>Thomas Alva Edison<br><a href="http://pglearn.blogspot.mx/" target="_blank">http://pglearn.blogspot.mx/</a><br>
<div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%"></div><div><br></div>