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 <[email protected] > <mailto:[email protected]>> 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 > > #=========== > [postg...@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 > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
