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

[Athanasios Kostopoulos]

Thanks, that did it!
One last question: sometimes after issuing "pcp_recovery_node", any further
pcp commands will hang. Anyone has any idea on how I can address this and
what is the root cause?
Again, many thanks to Theodotos and Rene for their help!


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

> It needs to exist in the primary a script called pgpool_remote_start in
> your database cluster directory, take this as an example:
>
>
> http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting/pgpool_remote_start
>
> it brings up the new node.
>
>
> 2013/6/17 Athanasios Kostopoulos <athanasios.kostopoulos at classmarkets.com>
>
>> 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/
>>>
>>>
>>
>
>
> --
> 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/be95b45c/attachment.html>