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