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

[Gerd König]

Good morning Deepak,

could it be that you have just to rename your script from
"/mnt/data/pns/pgsql8.3.6/pgpool_remote_start.sh" to
"/mnt/data/pns/pgsql8.3.6/pgpool_remote_start" ...?!?!

On my nodes the scripts doesn't have an extension:
#>ll /opt/postgres/data
insgesamt 267276
drwx------ 9 postgres postgres      4096 16. Mär 08:08 base
-rwxr-xr-x 1 postgres postgres       378 11. Mär 15:44 copy_base_backup
drwx------ 2 postgres postgres      4096 18. Mär 07:58 global
-rwxr-xr-x 1 postgres postgres       668 11. Mär 15:44 pgpool_recovery
-rwxr-xr-x 1 postgres postgres        55 11. Mär 15:44 pgpool_recovery_pitr
-rwxr-xr-x 1 postgres postgres       373 11. Mär 15:44 pgpool_remote_start
...

and one corresponding log entry looks like:
"
2009-03-13 10:58:03 CET [4732]: [1-1] LOG:  duration: 95212.992 ms  statement:
SELECT pgpool_recovery('copy_base_backup', 'node02', '/opt/postgres/data')
"

just a guess.............regards--==GERD==--


DM schrieb:
> 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

-- 
/===============================\
| Gerd König
| - Infrastruktur -
|
| TRANSPOREON GmbH
| Pfarrer-Weiss-Weg 12
| DE - 89077 Ulm
|
|
| Tel: +49 [0]731 16906 16
| Fax: +49 [0]731 16906 99
| Web: www.transporeon.com
|
\===============================/



Bleiben Sie auf dem Laufenden.
Jetzt den Transporeon Newsletter abonnieren!
http://www.transporeon.com/unternehmen_newsletter.shtml


TRANSPOREON GmbH, Amtsgericht Ulm, HRB 722056
Geschäftsf.: Axel Busch, Peter Förster, Roland Hötzl, Marc-Oliver Simon