[pgpool-general: 1845] Re: pgpool master-master setup

[Athanasios Kostopoulos]

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:

from the command line:

pcp_recovery_node 10 $HOST $PORT $USER $PASS $NODE_ID # all properly set

DEBUG: send: tos="R", len=46
DEBUG: recv: tos="r", len=21, data=AuthenticationOK
DEBUG: send: tos="D", len=6
DEBUG: recv: tos="e", len=20, data=recovery failed
DEBUG: command failed. reason=recovery failed
DEBUG: send: tos="X", len=4

from /var/log/messages
Jun 17 14:53:41 lb pgpool: 2013-06-17 14:53:41 LOG:   pid 5438: 1st stage
is done
Jun 17 14:53:41 lb pgpool: 2013-06-17 14:53:41 LOG:   pid 5438: starting
2nd stage
Jun 17 14:53:41 lb pgpool: 2013-06-17 14:53:41 LOG:   pid 5438: all
connections from clients have been closed
Jun 17 14:53:41 lb pgpool: 2013-06-17 14:53:41 LOG:   pid 5438: CHECKPOINT
in the 2nd stage done
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
Jun 17 14:53:41 lb pgpool: LINE 1: SELECT
pgpool_remote_start('192.168.10.3', '/data1')
Jun 17 14:53:41 lb pgpool:                ^
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.
Jun 17 14:53:41 lb pgpool:
Jun 17 14:53:41 lb pgpool: 2013-06-17 14:53:41 ERROR: pid 5438:
start_recovery: remote start failed

any ideas anyone on how I can address this problem? I am using:
Debian 7.1 wheezy
Postgres 9.1 that comes with Debian
pgpool-II version 3.1.3 (hatsuiboshi)



On Fri, Jun 14, 2013 at 11:55 PM, Theodotos Andreou <theo at ubuntucy.org>wrote:

>  Yes, they call it "replication mode". Ini this mode rwrite queries hit
> both servers and read (SELECT) queries are load-balanced.
>
> http://www.pgpool.net/docs/latest/pgpool-en.html#replication_mode
>
>
> On 14/06/2013 06:56 μμ, Athanasios Kostopoulos wrote:
>
> Dear list,
> 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.
>
>
> _______________________________________________
> pgpool-general mailing listpgpool-general at pgpool.nethttp://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130617/0eba8ae1/attachment.html>