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

[Rene Romero Benavides]

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/a6050f72/attachment-0001.html>