[Pgpool-general] Question about Online Recovery

[Harold Lim]

Hi All,

I'm trying to setup the online recovery. I'm following the tutorial/beginners guide written by Gerd.

I am getting an error for 2nd stage. Any idea what the problem might be?


Below is the log file:

2009-04-06 18:28:14 DEBUG: pid 25867: pcp_child: authentication OK
2009-04-06 18:28:14 DEBUG: pid 25867: pcp_child: received PCP packet type of service 'O'
2009-04-06 18:28:14 DEBUG: pid 25867: pcp_child: start online recovery
2009-04-06 18:28:14 LOG:   pid 25867: starting recovering node 1
2009-04-06 18:28:14 DEBUG: pid 25867: exec_checkpoint: start checkpoint
2009-04-06 18:28:14 DEBUG: pid 25867: exec_checkpoint: finish checkpoint
2009-04-06 18:28:14 LOG:   pid 25867: CHECKPOINT in the 1st stage done
2009-04-06 18:28:14 LOG:   pid 25867: starting recovery command: "SELECT pgpool_recovery('copy_base_backup', '172.16.63.10', '/opt/PostgreSQL/8.3/data')"
2009-04-06 18:28:14 DEBUG: pid 25867: exec_recovery: start recovery
2009-04-06 18:28:22 DEBUG: pid 25834: starting health checking
2009-04-06 18:28:22 DEBUG: pid 25834: health_check: 0 th DB node status: 1
2009-04-06 18:28:22 DEBUG: pid 25834: health_check: 1 th DB node status: 3
2009-04-06 18:28:33 DEBUG: pid 25867: exec_recovery: finish recovery
2009-04-06 18:28:33 LOG:   pid 25867: 1st stage is done
2009-04-06 18:28:33 LOG:   pid 25867: starting 2nd stage
2009-04-06 18:28:33 LOG:   pid 25867: all connections from clients have been closed
2009-04-06 18:28:33 DEBUG: pid 25867: exec_checkpoint: start checkpoint
2009-04-06 18:28:33 DEBUG: pid 25867: exec_checkpoint: finish checkpoint
2009-04-06 18:28:33 LOG:   pid 25867: CHECKPOINT in the 2nd stage done
2009-04-06 18:28:33 LOG:   pid 25867: starting recovery command: "SELECT pgpool_recovery('pgpool_recovery_pitr', '172.16.63.10', '/opt/PostgreSQL/8.3/data')"
2009-04-06 18:28:33 DEBUG: pid 25867: exec_recovery: start recovery
2009-04-06 18:28:33 ERROR: pid 25867: exec_recovery: pgpool_recovery_pitr command failed at 2nd stage
2009-04-06 18:28:33 DEBUG: pid 25867: exec_recovery: finish recovery
2009-04-06 18:28:33 DEBUG: pid 25867: pcp_child: received PCP packet type of service 'X'
2009-04-06 18:28:33 DEBUG: pid 25867: pcp_child: client disconnecting. close connection

Thanks!
Harold