[Pgpool-general] Hello!!

[Lazaro Ruben Garcia Martinez]

Jaume Sabater, thank you very much for your attention, I'm trying to make online recovery but I obtain a BackendError:
In pgpool.log, I see this error but I don't know what about it is:

2010-06-08 00:17:08 DEBUG: pid 26387: I am PCP 26387 accept fd 5
2010-06-08 00:17:08 DEBUG: pid 26387: pcp_child: received PCP packet type of service 'M'
2010-06-08 00:17:08 DEBUG: pid 26387: pcp_child: salt sent to the client
2010-06-08 00:17:08 DEBUG: pid 26387: pcp_child: received PCP packet type of service 'R'
2010-06-08 00:17:08 DEBUG: pid 26387: pcp_child: authentication OK
2010-06-08 00:17:08 DEBUG: pid 26387: pcp_child: received PCP packet type of service 'O'
2010-06-08 00:17:08 DEBUG: pid 26387: pcp_child: start online recovery
2010-06-08 00:17:08 LOG:   pid 26387: starting recovering node 1
2010-06-08 00:17:08 DEBUG: pid 26387: exec_checkpoint: start checkpoint
2010-06-08 00:17:08 DEBUG: pid 26387: exec_checkpoint: finish checkpoint
2010-06-08 00:17:08 LOG:   pid 26387: CHECKPOINT in the 1st stage done
2010-06-08 00:17:08 LOG:   pid 26387: starting recovery command: "SELECT pgpool_recovery('copy_base_backup', '192.168.101.122', '/var/lib/pgsql/data')"
2010-06-08 00:17:08 DEBUG: pid 26387: exec_recovery: start recovery
2010-06-08 00:17:08 ERROR: pid 26387: exec_recovery: copy_base_backup command failed at 1st stage
2010-06-08 00:17:08 DEBUG: pid 26387: exec_recovery: finish recovery
2010-06-08 00:17:08 DEBUG: pid 26387: pcp_child: received PCP packet type of service 'X'
2010-06-08 00:17:08 DEBUG: pid 26387: pcp_child: client disconnecting. close connection

This is my copy_base_backup script.

#!/bin/sh 

DATA=$1
RECOVERY_TARGET=$2
RECOVERY_DATA=$3
PG_HOME=/var/lib/pgsql

psql -c "select pg_start_backup('pgpool-recovery')" postgres
echo "restore_command = 'cp $PG_HOME/data/pg_xlog_archive/%f %p'" > $PG_HOME/data/recovery.conf
tar -C $PG_HOME/data -zcf pgsql.tar.gz base global pg_clog pg_multixact pg_subtrans pg_tblspc pg_twophase pg_xlog recovery.conf
psql -c 'select pg_stop_backup()' postgres
scp pgsql.tar.gz $RECOVERY_TARGET:$RECOVERY_DATA

These are the archiving properties in my postgresql.conf
# - Archiving -

archive_mode = on			
archive_command = '/bin/cp %p /var/lib/pgsql/data/pg_xlog_archive/%f'

Can you suggest my any reason for this error??? 

Thank you very much for your time.






 
----- Mensaje original -----
De: "Jaume Sabater" <jsabater at gmail.com>
Para: pgpool-general at pgfoundry.org
Enviados: Viernes, 11 de Junio 2010 10:12:03 (GMT-0500) Auto-Detected
Asunto: Re: [Pgpool-general] Hello!!

On Fri, Jun 11, 2010 at 4:01 PM, Lazaro Ruben Garcia Martinez
<lgarciam at estudiantes.uci.cu> wrote:

> Hello, I have a doubt, for making online recovery is necessary that pgpool-II will be installed in all nodes?
> Thank you very much for your time.

No. You just need one pgpool-II instance if you don't want high
availability, and multiple pgsql nodes. Scripts executed on online
recovery will have to be copied to all nodes, though.

-- 
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"
_______________________________________________
Pgpool-general mailing list
Pgpool-general at pgfoundry.org
http://pgfoundry.org/mailman/listinfo/pgpool-general