'replication_mode = true' means sincronous replication with pgpool-II, 
pgpool_walrecrunning function is used for streaming replication, configuring 
pgpool-II in master/slave sub-mode stream.

Regards.

De: [email protected] 
[mailto:[email protected]] En nombre de Sandeep Thakkar
Enviado el: lunes, 19 de septiembre de 2011 01:32
Para: Tatsuo Ishii
CC: [email protected]
Asunto: Re: [Pgpool-general] Is pgpool_walrecrunning needed in Master/Slave 
mode?

Thanks Tatsuo.

By streaming replication mode, you mean the 'replication_mode = true' in 
pgpool.conf? If I use pgpool-II-3.0.3, and configure it in Master/Slave mode 
with sub mode as 'stream', then I do not need this function., right?

Sandeep.
________________________________
From: Tatsuo Ishii <[email protected]>
To: [email protected]
Cc: [email protected]
Sent: Saturday, September 17, 2011 1:40 PM
Subject: Re: [Pgpool-general] Is pgpool_walrecrunning needed in Master/Slave 
mode?

> I read the 3.0.3 docs and found that pgpool_walrecrunning() should be used 
> only in replication mode, and that too when somebody is using the 
> failure/online recovery feature of pgPoll-II.

pgpool_walrecrunning is only usefull for streaming replication
mode in 3.0.x.

> At the same time, I found that this function has undergone some change:
> "
>
> Now "pgpool_walrecrunning()" was not used. pgpool-II used to consider the 
> node that is promoted a primary node using the function. Now, pgpool-II waits 
> for completing of the promotion to primary node because it did not work as we 
> intended. But we still have a problem that pgpool-II waits while 
> recovery_timeout, when there is no primary node(Kitagawa)
>  "
>
> Can someone elaborate this please? Also, I assume that I need this function 
> only when I setup pgPool-II in replication mode.

In pgpool-II 3.1 the function is not used anymore even in streaming
replication mode.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general

Reply via email to