[Pgpool-general] Hello!!

[Gerd Koenig]

Hi Lazaro,

can you perform the "scp"-command manually to check if it's working 
(without entering the password) ?

just my 50ct.....GERD......

On 11.06.10 16:36, Lazaro Ruben Garcia Martinez wrote:
> 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.
>
>