Re: Point in Time Recovery

From: HISADAMasaki <hisada(dot)masaki(at)lab(dot)ntt(dot)co(dot)jp>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Point in Time Recovery
Date: 2004-07-15 12:16:58
Message-ID: 20040715210816.E8A3.HISADA.MASAKI@lab.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers pgsql-patches

Dear Simon,

I've just tested pitr_v5_2.patch and got an error message
during archiving process as follows.

-- begin
LOG: archive command="cp /usr/local/pgsql/data/pg_xlog/0000000000000000 /tmp",return code=-1
-- end

The command called in system(3) works, but it returns -1.
system(3) can not get right exit code from its child process,
when SIGCHLD is set as SIG_IGN.

So I did following change to pgarch_Main() in pgarch.c

-- line 236 ---
- pgsignal(SIGCHLD, SIG_IGN);

-- line 236 ---
+ pgsignal(SIGCHLD, SIG_DFL);

After that,
the error message doen't come out and it seems to be working propery.

Regards,
Hisada, Masaki

On Wed, 14 Jul 2004 00:13:37 +0100
Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:

> PITR Patch v5_1 just posted has Point in Time Recovery working....
>
> Still some rough edges....but we really need some testers now to give
> this a try and let me know what you think.
>
> Klaus Naumann and Mark Wong are the only [non-committers] to have tried
> to run the code (and let me know about it), so please have a look at
> [PATCHES] and try it out.
>
> Many thanks,
>
> Simon Riggs
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend

--
HISADA, Masaki <hisada(dot)masaki(at)lab(dot)ntt(dot)co(dot)jp>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lending, Rune 2004-07-15 13:02:00 recover deletede tuples
Previous Message Mark Kirkwood 2004-07-15 09:47:50 Re: Point in Time Recovery

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB SD 2004-07-15 13:00:24 Re: Point in Time Recovery
Previous Message Peter Eisentraut 2004-07-15 12:11:35 How to display privileges in psql

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-07-15 13:40:51 Re: build infrastructure for extensions v3
Previous Message LELARGE Guillaume 2004-07-15 11:08:27 French translation updates for 7.4 and 7.5