[Pgpool-general] Fwd: pgpool + warm standby presentation

[Emanuel Calvo Franco]

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