I resend the post (i get suscribed)
I'm trying to implement pgpool2 3.0 + 8.4.4 with pg_standby. Both servers are working correctly (with standby running). It's weird for me: 2010-09-27 11:49:31 DEBUG: pid 12161: health_check: 0 th DB node status: 2 2010-09-27 11:49:31 DEBUG: pid 12161: health_check: 1 th DB node status: 2 2010-09-27 11:49:55 DEBUG: pid 12210: I am 12210 accept fd 6 2010-09-27 11:49:55 DEBUG: pid 12210: Protocol Major: 1234 Minor: 5679 database: user: 2010-09-27 11:49:55 DEBUG: pid 12210: SSLRequest from client 2010-09-27 11:49:55 DEBUG: pid 12210: Protocol Major: 3 Minor: 0 database: postgres user: postgres 2010-09-27 11:49:55 DEBUG: pid 12210: new_connection: connecting 0 backend 2010-09-27 11:49:55 DEBUG: pid 12210: new_connection: connecting 1 backend 2010-09-27 11:49:55 ERROR: pid 12210: pool_read_kind: kind does not match between master(52) slot[1] (45) pcp_node_info: pgpool2/bin/pcp_node_info 5 bbdd2 9898 postgres xxxxx 2 BackendError pgpool2/bin/pcp_node_info 5 bbdd2 9898 postgres xxxxxx 1 bbdd2 5432 2 0.000000 How I can implement warm standby with pgpool? Obviusly, node 2 cannot connect because is recovering. I must deattach the node and attach it in the failover? Regards -- Emanuel Calvo Franco Independient DBA www.emanuelcalvofranco.com.ar _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
