Re: Recovery target 'immediate' - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Recovery target 'immediate'
Date
Msg-id CA+U5nMK6K8tMXEad_tzy2HdtEcFppiTYOyO0Z4YFnuk0ySMG-g@mail.gmail.com
Whole thread Raw
In response to Re: Recovery target 'immediate'  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
On 26 April 2013 12:54, Magnus Hagander <magnus@hagander.net> wrote:

> That said, maybe the easier choice for a *system* (such as v-thingy)
> would be to simply to the full backup using pg_basebackup -x (or
> similar), therefor not needing the log archive at all when restoring.
> Yes, it makes the base backup slightly larger, but also much
> simpler... As a bonus, your base backup would still work if you hosed
> your log archive.

Good point. My comments also apply there.

I think we should put a clear health warning on that to explain what
you get and don't get.

--Simon Riggs                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Recovery target 'immediate'
Next
From: Robert Haas
Date:
Subject: Re: pg_controldata gobbledygook