[pgpool-general: 3040] Re: pgpool-general Digest, Vol 33, Issue 3

[Lazaro Ruben Garcia Martinez]

Pgpool use the query select pg_is_in_recovery(), for detecting the standby node.

Regards.
________________________________________
De: pgpool-general-bounces at pgpool.net [pgpool-general-bounces at pgpool.net] En nombre de Long On [on.long.on at gmail.com]
Enviado el: miércoles, 16 de julio de 2014 22:56
Para: Muhammad Usama
CC: pgpool-general at pgpool.net
Asunto: [pgpool-general: 3035] Re: pgpool-general Digest, Vol 33, Issue 3

On Tue, Jul 15, 2014 at 9:22 AM, Muhammad Usama <m.usama at gmail.com<mailto:m.usama at gmail.com>> wrote:

On Wed, Jul 2, 2014 at 10:45 PM, Long On <on.long.on at gmail.com<mailto:on.long.on at gmail.com>> wrote:
Hello,

I am also observing node 0 being promoted to master when using pcp_attach_node, after a recovery of node 0. Node 1 is master and should remain so but I see a failback sequence happening in pgpool.log. After which write statements are no longer possible since pgpool is sending them to node 0, which is now standby.

Whenever a new node is attached to pgpool-II using the pcp_attach_node utility. pgpool-II forgets the previous primary node and start searching for primary node again. The first node which fulfils the conditions for being the primary node is selected as primary.

Muhammad, what are the conditions pgpool looks for to decide if a node is primary or standby?

Thanks,
Long


________________________________
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com