From: | Kyotaro HORIGUCHI <horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> |
---|---|
To: | masao(dot)fujii(at)gmail(dot)com |
Cc: | hlinnakangas(at)vmware(dot)com, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Archive recovery won't be completed on some situation. |
Date: | 2014-03-28 05:06:59 |
Message-ID: | 20140328.140659.254643135.horiguchi.kyotaro@lab.ntt.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hello,
> > At Wed, 19 Mar 2014 19:34:10 +0900, Fujii Masao wrote
> >> > Agreed. Attached patches do that and I could "recover" the
> >> > database state with following steps,
> >>
> >> Adding new option looks like new feature rather than bug fix.
> >> I'm afraid that the backpatch of such a change to 9.3 or before
> >> is not acceptable.
> >
> > Me too. But on the other hand it simplly is a relief for the
> > consequence of the behavior of server (altough it was ill
> > operation:), and especially it is needed for at least 9.1 which
> > seems cannot be saved without it. Plus it has utterly no impact
> > on servers' behavior of any corresponding versions. So I hope it
> > is accepted.
>
> Even in 9.1, we can think that problematic situation as database corruption
> and restart the server from the backup which was successfully taken before.
> No?
Mmm. I don't think it is relevant to this problem. The problem
specific here is 'The database was running until just now, but
shutdown the master (by pacemaker), then restart, won't run
anymore'. Deleting backup_label after immediate shutdown is the
radical measure but existing system would be saved by the option.
But, honestly saying, I (also?) don't have sympathy for the
situation so much and if all or most of you think the option can
cause another problem, I won't insist about that any more.
regards,
--
Kyotaro Horiguchi
NTT Open Source Software Center
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2014-03-28 05:37:30 | Re: Re: [HACKERS] New parameter RollbackError to control rollback behavior on error |
Previous Message | Kyotaro HORIGUCHI | 2014-03-28 04:52:52 | Re: Archive recovery won't be completed on some situation. |