Re: PITR - base backup question - Mailing list pgsql-general

From Merlin Moncure
Subject Re: PITR - base backup question
Date
Msg-id b42b73150808270512y2867c937h1710512d6010d3c8@mail.gmail.com
Whole thread Raw
In response to Re: PITR - base backup question  ("Richard Broersma" <richard.broersma@gmail.com>)
Responses Re: PITR - base backup question
List pgsql-general
On Tue, Aug 26, 2008 at 9:04 PM, Richard Broersma
<richard.broersma@gmail.com> wrote:
> On Tue, Aug 26, 2008 at 5:38 PM, Merlin Moncure <mmoncure@gmail.com> wrote:
>
>
>> If you ever want to mess around with log
>> shipping I strongly suggest you go through the motions of setting up a
>> warm standby vi the pg_standby utility and practice popping the
>> standby out of recovery.
>
> Thanks for the reply!  I want to be certain that I understand the
> point you are making:
>
> Is setting up a warm standby server good pratice for gaining
> experience in PITR or do you mean that PITR is a good starting point
> for setting up a warm standby server?

setting up a warm standby is good for understanding pitr.  A warm
standby just 'lays on top' of pitr and you should learn how to do it.

merlin

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: loop vs. aggregate was: update and group by/aggregate
Next
From: Ivan Sergio Borgonovo
Date:
Subject: Re: loop vs. aggregate was: update and group by/aggregate