Re: Fwd: postgres 9.0.4 Streaming related question ..

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: akp geek <akpgeek(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Fwd: postgres 9.0.4 Streaming related question ..
Date: 2011-12-07 17:01:26
Message-ID: 91CBA76D-4683-4A74-B80E-EC5384B04C00@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Prashant Bharucha 2011-12-07 19:09:49 Tables creation date and time
Previous Message akp geek 2011-12-07 16:45:26 Fwd: postgres 9.0.4 Streaming related question ..