Re: Fwd: postgres 9.0.4 Streaming related question .. - Mailing list pgsql-general

From akp geek
Subject Re: Fwd: postgres 9.0.4 Streaming related question ..
Date
Msg-id CACnhOfJ0NVLCBzXgxQFrCOr0hJwzw0dzwYNR8WewDp3PgVxJxA@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: postgres 9.0.4 Streaming related question ..  (Ben Chobot <bench@silentmedia.com>)
List pgsql-general
Thanks , it worked

On Wed, Dec 7, 2011 at 12:01 PM, Ben Chobot <bench@silentmedia.com> wrote:

On Dec 7, 2011, at 8:45 AM, akp geek wrote:

> Small Clarification. I have gone through the documentation. I did not find any thing related to start ans stop replication after the replication is setup
>
> 1. If I shutdown the primary
> 2. Shutdown the slave
> 3. start Primary
> 4. start slave
>
> Will this automatically catch up the streaming. Can you please comment?

So long as you leave your recovery.conf file in place, and don't loose any needed wal files between steps 3 and 4 (or can recover them from an archive), then the answer is yes.

pgsql-general by date:

Previous
From: Marc Cousin
Date:
Subject: Re: Hope for a new PostgreSQL era?
Next
From: Merlin Moncure
Date:
Subject: Re: Hope for a new PostgreSQL era?