| From: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
|---|---|
| To: | Arthur Silva <arthurprs(at)gmail(dot)com>, Vladimir Borodin <root(at)simply(dot)name> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Satoshi Nagayasu <snaga(at)uptime(dot)jp>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Venkata Balaji N <nag1010(at)gmail(dot)com>, Michael Paquier <mpaquier(at)vmware(dot)com> |
| Subject: | Re: pg_rewind in contrib |
| Date: | 2015-04-13 13:11:00 |
| Message-ID: | 552BC064.2070009@iki.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 03/26/2015 09:45 PM, Arthur Silva wrote:
> On Mar 26, 2015 4:20 AM, "Vladimir Borodin" <root(at)simply(dot)name> wrote:
>>
>>
>>> 26 марта 2015 г., в 7:32, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
> написал(а):
>>>
>>> On Thu, Mar 26, 2015 at 12:23 PM, Venkata Balaji N <nag1010(at)gmail(dot)com>
> wrote:
>>>> If the master is crashed or killed abruptly, it may not be possible to
> do a
>>>> rewind. Is my understanding correct ?
>>>
>>> Yep. This is mentioned in the documentation:
>>> http://www.postgresql.org/docs/devel/static/app-pgrewind.html
>>> "The target server must shut down cleanly before running pg_rewind>>.
>>
>> You can start old master, wait for crash recovery to complete, stop it
> cleanly and then use pg_rewind. It works.
>
> Shouldn't we have a flag so it does that automatically if necessary?
Might be handy, but currently pg_rewind never invokes postgres or other
binaries, so it would be a fair amount of new functionality to implement
that. Let's keep it simple for now.
- Heikki
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2015-04-13 13:33:35 | Re: "rejected" vs "returned with feedback" in new CF app |
| Previous Message | Etsuro Fujita | 2015-04-13 09:58:46 | Re: EvalPlanQual behaves oddly for FDW queries involving system columns |