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

DM dm.aeqa at gmail.com
Sat Mar 14 02:04:11 UTC 2009


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20090313/ef88bc87/attachment.html 


More information about the Pgpool-general mailing list