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

[DM]

Thank you all for the support.

I did some debugging and found what was wrong with base-back script.

Now i am very close to recover the database.

I have a new issue with pgpool_remote_start, though i have the file
/mnt/data/pns/pgsql8.3.6/pgpool_remote_start.sh in the specified directory,
I am getting an error message in postgres log file as sh:
/mnt/data/pns/pgsql8.3.6/pgpool_remote_start: No such file or directory

If i execute the script manually it works fine (database is started).

Note: I have already created a function under template1 db as

CREATE OR REPLACE FUNCTION pgpool_remote_start(text, text)
RETURNS bool
AS '$libdir/pgpool-recovery', 'pgpool_remote_start'
LANGUAGE C STRICT;

****From postgres node1 log file*********
postgres|postgres|[local]|25721|2009-03-17 19:27:02.268
PDT|idle|49c05bf6.6479|5|2009-03-17 19:27:02 PDT|0LOG:  disconnection:
session time: 0:00:00.004 user=postgres database=postgres host=[local]
postgres|template1|localhost.localdomain(59930)|25253|2009-03-17
19:27:02.269 PDT|SELECT|49c05b9c.62a5|10|2009-03-17 19:25:32 PDT|0LOG:
duration: 8.517 ms
postgres|template1|localhost.localdomain(59930)|25253|2009-03-17
19:27:02.269 PDT|idle|49c05b9c.62a5|11|2009-03-17 19:25:32 PDT|0LOG:
statement: SELECT pgpool_remote_start('fdbr-res0002',
'/mnt/data/pns/pgsql8.3.6')
sh: /mnt/data/pns/pgsql8.3.6/pgpool_remote_start: No such file or directory
postgres|template1|localhost.localdomain(59930)|25253|2009-03-17
19:27:02.271 PDT|SELECT|49c05b9c.62a5|12|2009-03-17 19:25:32 PDT|0ERROR:
pgpool_remote_start failed
postgres|template1|localhost.localdomain(59930)|25253|2009-03-17
19:27:02.271 PDT|SELECT|49c05b9c.62a5|13|2009-03-17 19:25:32
PDT|0STATEMENT:  SELECT pgpool_remote_start('fdbr-res0002',
'/mnt/data/pns/pgsql8.3.6')
postgres|template1|localhost.localdomain(59930)|25253|2009-03-17
19:27:02.272 PDT|idle|49c05b9c.62a5|14|2009-03-17 19:25:32 PDT|0LOG:
disconnection: session time: 0:01:29.962 user=postgres database=template1
host=localhost.localdomain port=59930
****From postgres node1 log file*********

Any solution for this?

Thanks
Deepak
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/pgpool-general/attachments/20090317/0c213003/attachment.html