Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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

pgsql-admin by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group