Re: Point in Time Recovery

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

On Thu, 2004-07-15 at 13:16, HISADAMasaki wrote:
> 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);
>

Thank you for testing the patch. Very much appreciated.

I was aware of the potential issues of incorrect return codes, and that
exact part of the code is the part I'm least happy with.

I'm not sure I understand why its returned -1, though I'll take you
recommendation. I've not witnessed such an issue. What system are you
running, or is it a default shell issue?

Do people think that the change is appropriate for all systems, or just
the one you're using?

Best Regards, Simon Riggs

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Alvaro Herrera 2004-07-15 23:01:33 Re: Point in Time Recovery
Previous Message Marc G. Fournier 2004-07-15 19:36:05 Re: Slony NG

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2004-07-15 22:50:08 Re: Point in Time Recovery
Previous Message Bruce Momjian 2004-07-15 22:39:53 Re: [PATCHES] serverlog rotation/functions

Browse pgsql-patches by date

  From Date Subject
Next Message Bruce Momjian 2004-07-15 22:49:40 Re: initdb authentication
Previous Message Bruce Momjian 2004-07-15 22:39:53 Re: [PATCHES] serverlog rotation/functions