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

[DM]

Hi Gerd,
thanks for mentioning that, I was able to do successful recovery.

I guess the documentation needs a little tweak. :)

Thanks for your help.

Thanks
Deepak

2009/3/18 Gerd König <koenig at transporeon.com>

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