<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 style>from the command line:</div><div style><br></div><div style>pcp_recovery_node 10 $HOST $PORT $USER $PASS $NODE_ID # all properly set</div><div style><br></div><div style><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 style>from /var/log/messages</div><div style><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 style>any ideas anyone on how I can address this problem? I am using:</div><div style>Debian 7.1 wheezy</div>
<div style>Postgres 9.1 that comes with Debian</div><div style>pgpool-II version 3.1.3 (hatsuiboshi)<br></div><div><br></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 class="im"><br>
<br>
On 14/06/2013 06:56 ìì, Athanasios Kostopoulos wrote:<br>
</div></div>
<blockquote type="cite"><div class="im">
<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>