2010/9/28 Emanuel Calvo Franco <[email protected]>: > 2010/9/28 Tatsuo Ishii <[email protected]>: >>>>> I'm using raw mode: >>> >>> Ok, I'll look into this more. >> >> It looks like pgpool-II succeeded in connecting to bbdd1 while failed >> to connect to bbdd2. >> >> pg_hba.conf setting of bbdd2? > > Both servers have trust between. > > When i had moved the pgpool to bd1, it works (but i didn't test > the failover yet). I only modified the hostname, the rest of the > pgpool.conf is the same.
Fix: It doesn't work. Failover puts the trigger file and the 2nd node starts (that's why pgpool works). The same error in different host: 2010-09-28 12:15:51 DEBUG: pid 587: starting health checking 2010-09-28 12:15:51 DEBUG: pid 587: health_check: 0 th DB node status: 2 2010-09-28 12:15:51 DEBUG: pid 587: health_check: 1 th DB node status: 2 2010-09-28 12:15:57 DEBUG: pid 638: I am 638 accept fd 6 2010-09-28 12:15:57 DEBUG: pid 638: Protocol Major: 1234 Minor: 5679 database: user: 2010-09-28 12:15:57 DEBUG: pid 638: SSLRequest from client 2010-09-28 12:15:57 DEBUG: pid 638: pool_ssl: SSL requested but SSL support is not available 2010-09-28 12:15:57 DEBUG: pid 638: Protocol Major: 3 Minor: 0 database: postgres user: postgres 2010-09-28 12:15:57 DEBUG: pid 638: new_connection: connecting 0 backend 2010-09-28 12:15:57 DEBUG: pid 638: new_connection: connecting 1 backend 2010-09-28 12:15:57 DEBUG: pid 638: pool_ssl: SSL requested but SSL support is not available 2010-09-28 12:15:57 DEBUG: pid 638: pool_ssl: SSL requested but SSL support is not available 2010-09-28 12:15:57 ERROR: pid 638: pool_read_kind: kind does not match between master(52) slot[1] (45) 2010-09-28 12:16:21 DEBUG: pid 587: starting health checking 2010-09-28 12:16:21 DEBUG: pid 587: health_check: 0 th DB node status: 2 2010-09-28 12:16:21 DEBUG: pid 587: health_check: 1 th DB node status: 2 [r...@310454-db1 opt]# pgpool2/bin/pcp_node_info -d 2 bbdd1 9898 postgres xxxx 2 DEBUG: send: tos="R", len=46 DEBUG: recv: tos="r", len=21, data=AuthenticationOK DEBUG: send: tos="I", len=6 DEBUG: recv: tos="e", len=20, data=Invalid Node ID DEBUG: command failed. reason=Invalid Node ID BackendError DEBUG: send: tos="X", len=4 [r...@310454-db1 opt]# pgpool2/bin/pcp_node_info -d 2 bbdd1 9898 postgres xxxxx 1 DEBUG: send: tos="R", len=46 DEBUG: recv: tos="r", len=21, data=AuthenticationOK DEBUG: send: tos="I", len=6 DEBUG: recv: tos="i", len=37, data=CommandComplete bbdd2 5432 2 nan DEBUG: send: tos="X", len=4 -- Emanuel Calvo Franco Independient DBA www.emanuelcalvofranco.com.ar _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
