[Pgpool-general] Not able to recover a node using pgpool recovery

[Gerd Koenig]

Hello Deepak,

DM schrieb:
> Also here is teh base-backup script.
> 
# I would favor /tmp/pgpool-recovery instead of /data,
# as it contains live data

I don't understand your comment. You have to sync your $PGDATA 
directory, the directory which includes several directories like "base", 
"global", "pg_clog" and files like pg_hba.conf, postgresql.conf
> 
> Should I need to set these environment variables -RECOVERY_TARGET, 
> RECOVERY_DATA ?

I don't think so, because e.g. RECOVERY_DATA doesn't appear in the 
script (except for setting it). Try setting real values for $HOSTNAME, 
$RECOVERY_TARGET for testing.
Since the logs doesn't tell too much, what about calling the single 
commands manually to be able to locate the error.
Are you able to perform a scp command without typing a password (->ssh 
key-exchange) ?

Are there some entries in postgres.log on the node you want to create 
the checkpoint ?

regards....GERD....
> 
> 
> On Fri, Mar 13, 2009 at 7:04 PM, DM <dm.aeqa at gmail.com 
> <mailto:dm.aeqa at gmail.com>> wrote:
> 
>     Hi All,
> 
>     Not able to recover node using pgpool recovery
> 
>     # I did all the configuration changes - Gerd Koenig's document
> 
>     pcp_recovery_node -d 10.80.16.16 9898 pgpuser xyz 1
> 
>     2009-03-13 18:07:26 LOG:   pid 17559: starting recovering node 1
>     2009-03-13 18:07:26 LOG:   pid 17559: CHECKPOINT in the 1st stage done
>     2009-03-13 18:07:26 LOG:   pid 17559: starting recovery command:
>     "SELECT pgpool_recovery('base-backup', 'fdbr-res0002',
>     '/mnt/data/pns/pgsql8.3.6')"
>     2009-03-13 18:07:26 ERROR: pid 17559: exec_recovery: base-backup
>     command failed at 1st stage
>     2009-03-13 18:10:01 LOG:   pid 17559: starting recovering node 1
> 
> 
>     #####################################################
> 
>     I logged to psql on fdbr-res0001
> 
>     #===========
>     [postgres at fdbr-res0001 scripts]$ /usr/postgres/8.3.6/bin/psql -p9999
>     Welcome to psql 8.3.6, the PostgreSQL interactive terminal.
> 
>     Type:  \copyright for distribution terms
>            \h for help with SQL commands
>            \? for help with psql commands
>            \g or terminate with semicolon to execute query
>            \q to quit
> 
>     postgres=# \c template1
>     You are now connected to database "template1".
>     template1=# SELECT pgpool_recovery('base-backup', 'fdbr-res0002',
>     '/mnt/data/pns/pgsql8.3.6');
>     ERROR:  pgpool_recovery failed
>     template1=#
>     #===========
> 
>     Not able to figure out how to solve this issue
>     ERROR:  pgpool_recovery failed
> 
>     Help me with this error
> 
>     Thanks
>     Deepak Murthy
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general