Re: [GENERAL] PITR - base backup question

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Richard Broersma" <richard(dot)broersma(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-admin(at)postgresql(dot)org
Subject: Re: [GENERAL] PITR - base backup question
Date: 2008-08-27 12:12:31
Message-ID: b42b73150808270512y2867c937h1710512d6010d3c8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Tue, Aug 26, 2008 at 9:04 PM, Richard Broersma
<richard(dot)broersma(at)gmail(dot)com> wrote:
> On Tue, Aug 26, 2008 at 5:38 PM, Merlin Moncure <mmoncure(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Nolan 2008-08-27 13:18:34 Re: [GENERAL] PITR - base backup question
Previous Message Jeff Frost 2008-08-27 06:02:31 Re: vacuum verbose relations reporting

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-08-27 12:58:18 Re: loop vs. aggregate was: update and group by/aggregate
Previous Message Sam Mason 2008-08-27 11:45:42 Re: loop vs. aggregate was: update and group by/aggregate