> 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 <[email protected]> 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@adt-web01 pgpool-II-3.0.3]# pcp_node_info 10 adt-web01 9898 >> postgres >> > postgres 0 >> > adt-db01 5432 1 0.500000 >> > [root@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 >> _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
