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.
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
