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

[Athanasios Kostopoulos]

I did installed it by hand and now I am getting the following,
non-informative message ...
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
Jun 17 15:42:11 lb pgpool:
Jun 17 15:42:11 lb pgpool: 2013-06-17 15:42:11 ERROR: pid 5438:
start_recovery: remote start failed



On Mon, Jun 17, 2013 at 3:30 PM, Rene Romero Benavides <
rene.romero.b at gmail.com> wrote:

> You need to install the online recovery functions in the master node as
> described here:
>
> http://pgpool.projects.pgfoundry.org/pgpool-II/doc/pgpool-en.html#online-recovery
>
>
> 2013/6/17 Athanasios Kostopoulos <athanasios.kostopoulos at classmarkets.com>
>
>> 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
>>>
>>>
>>>
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
>>
>
>
> --
> El genio es 1% inspiración y 99% transpiración.
> Thomas Alva Edison
> http://pglearn.blogspot.mx/
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130617/2c2962ae/attachment.html>