Ciao,
it solved, using the command
pcp_attach_node
in this way I've attached backend1 in the pool and everything works.
Thanks
cristina
On Sep 26, 2011, at 11:01 AM, Cristina Bulfon wrote:
Hello,
thanks for the answer.
I don't have the file pgpool_status and yes, backend1 can receive
connection from pgpool node, just for testing the authentication
method (at the moment) is "trust"
ciao
cristina
On Sep 23, 2011, at 4:10 PM, Lazaro Rubén García Martinez wrote:
Pgpool, saves the status node in pgpool_status file, for example if
you stop one PostgreSQL node manually and pgpool performs a health
check and detects that this node is down, the result is saved in
pgpool_status for preventing future replication problems, but if
you start the backend manually, this continues down for pgpool, if
you are sure that the two servers are sync, you can stop pgpool,
delete pgpool_status and start up pgpool again, in other way you
can stop backend1 and perform and online recovery with pgpool.
Other options, can backend1 receive connections from pgpool?? Is
there any rule in pg_hba.conf of backend1 for allows pgpool connect
to it? What is the authentication method used??
Regards.
-----Mensaje original-----
De: pgpool-general-boun...@pgfoundry.org [mailto:pgpool-general-boun...@pgfoundry.org
] En nombre de Cristina Bulfon
Enviado el: viernes, 23 de septiembre de 2011 08:58
Para: pgpool-general@pgfoundry.org
Asunto: [Pgpool-general] problem with replication
Hello,
I have the following layout,
- one computer is running pgpool-II-3.10 and postgresql 8.4.7-1
(backend 0)
- one computer running postgresql 8.4.7-1 (backend 1)
I have used the pgpool.conf.sample.replication for my set up and if I
try to create both the DB's user and the database (using port
9999) I
don't see the replication on both backends.
I also try to see the pcp comunication and the backend1 seems to be
down even if postgres is running on this node.
Any help is appreciate.
Thanks
cristina
_______________________________________________
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
_______________________________________________
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general
_______________________________________________
Pgpool-general mailing list
Pgpool-general@pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general