[Pgpool-general] failback setup problem

[Tatsuo Ishii]

> thanks, that message already helped. I tried to recover the postgres server
> with the failback_command.

You are welcome.

> I didn't realize these recovery_* parameters yet.
> So I use the recovery_* parameters for recovering the failed postgres
> server.

pgpool-II connects to backend to issue some SQLs including CHECKPOINT.
recovery_* parameters define the user and password for the connection.
Usually they are for PostgreSQL super user (postgres).

> And the failback_command to attach the postgres server into pgpool
> right?

If you want to do something special, for example mailing to DBA, then
you might want to specify it.  Otherwise you can leave it empty.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Best Regards,
> Uwe
> 
> 
> On 26 April 2011 01:06, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> 
>> > I'm using pg-pool-II 3.0.3 with streaming replication.
>> > I coded the failback scenario/script for the slave server and the script
>> > itself works fine.
>> >
>> > I now configured the failback script in pgpool.conf and during testing an
>> > error message comes up:
>> > 2011-04-09 06:42:18 LOG:   pid 16863: starting recovering node 1
>> > 2011-04-09 06:42:18 ERROR: pid 16863: start_recover: could not connect
>> > master node.
>> >
>> > [root at adt-web01 pgpool-II-3.0.3]# pcp_node_info 10 adt-web01 9898
>> postgres
>> > postgres 0
>> > adt-db01 5432 1 0.500000
>> > [root at adt-web01 pgpool-II-3.0.3]# pcp_node_info 10 adt-web01 9898
>> postgres
>> > postgres 1
>> > adt-db02 5432 3 0.500000
>> >
>> > pcp commands and pgpooladmin report that the master is up and running and
>> > I'm able to connect to the master directly and through pgpool.
>> > So what's wrong? So far everything else works fine.
>>
>> Assuming you have set recovery_user and recovery_passwd correctly, I'm
>> not sure what's going on. IMO, the error message is very rare. It's so
>> rare and there's a bug in the error path, which had not been found for
>> long time. Can please try attached patch? The patch add a little bit
>> usefull info to the error message above.
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese: http://www.sraoss.co.jp
>>