[Pgpool-general] pgpool + warm standby presentation

[Emanuel Calvo Franco]

2010/9/28 Emanuel Calvo Franco <postgres.arg at gmail.com>:
> 2010/9/28 Tatsuo Ishii <ishii at sraoss.co.jp>:
>>>>> 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

[root at 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

[root at 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