[Pgpool-general] Question about Online Recovery

[Gerd König]

Hi Harold,

have you checked the postgresql.log on your nodes for (error-)messages created
at "2009-04-06 18:28:33" ?

regards...GERD...

Harold Lim schrieb:
> 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
> 
> 
> 
>       
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
> 

-- 
/===============================\
| Gerd König
| - Infrastruktur -
|
| TRANSPOREON GmbH
| Pfarrer-Weiss-Weg 12
| DE - 89077 Ulm
|
|
| Tel: +49 [0]731 16906 16
| Fax: +49 [0]731 16906 99
| Web: www.transporeon.com
|
\===============================/



Bleiben Sie auf dem Laufenden.
Jetzt den Transporeon Newsletter abonnieren!
http://www.transporeon.com/unternehmen_newsletter.shtml


TRANSPOREON GmbH, Amtsgericht Ulm, HRB 722056
Geschäftsf.: Axel Busch, Peter Förster, Roland Hötzl, Marc-Oliver Simon