[Pgpool-general] postgres conections are stuked after a pcp_recovery_node.

[erobles]

Hi!

 i have the following  scenary:


0. First , i made a  copy of whole the postgres dir  the backend0  on 
backend1
1.  start up postgres on the backend0  (pgsql1), with port 6543
2.  keep  down postgres  on the backend1 (pgsql2), with port 6543 too.
3.  start up the pgpool on the port 5432 confiugred to replication.
4. NO  querys or  any transaction are executed

I tried  to start up postgres and  recovery   the   backend 1 executing 
pcp_recovery_command.

Checking  the logs ,  pgpool  recoveries   and reconnects the host ,  to 
veryfied that , i ran the pcp_attach_node and  i have the message node 1 
is alive, is ok.

and  check the  postgres connection on port 6543 of the backend 1 and 
is  alive a,is ok.


But... i tried to  connect  psql through pgpool but the  psql is stucked

How can i tell to pgpool,  that reset its connections to allow  psql and 
requests and avoid that stuck???



by the way  i 'm using pgpool 2.2.6, because i can't compile the  later 
version on SCO 507 Openserver.

--
La información contenida en este correo electrónico es confidencial de Sensa Control Digital, S.A. de C.V. Está dirigido solamente a la dirección de correo señalada. El acceso a este correo electrónico por cualquier otra persona, No está autorizado. Si Ud. no es el receptor deliberado de este correo electrónico, cualquier difusión, copia o distribución está prohibida y puede ser ilegal. Si lo ha recibido por error, por favor notifique al emisor e inmediatamente bórrelo de forma permanente y destruya cualquier copia impresa.

The information in this Internet e-mail is confidential, belongs to Sensa Control Digital, S.A. de C.V. It is intended solely for the addressee(s). Access to this Internet e-mail by anyone else is unauthorized. If you are not the intended recipient of this e-mail, any disclosure, copying, or distribution of it is prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender and immediately and permanently delete it and destroy any copies of it that were printed out.