Thread: Fwd: postgres 9.0.4 Streaming related question ..

Fwd: postgres 9.0.4 Streaming related question ..

From
akp geek
Date:
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?

Regards

---------- Forwarded message ----------
From: akp geek <akpgeek@gmail.com>
Date: Wed, Dec 7, 2011 at 9:03 AM
Subject: postgres 9.0.4 Streaming relate question ..
To: pgsql-general <pgsql-general@postgresql.org>


Hi All -

        Need some help. We have been using postgres 9.0.4 for our production environment for some time. Today we are going to restart the Solaris servers. 

        We have streaming on . My question is how to handle the streaming when we start the database on the servers.

         Can you please give me some steps. I have actually used the http://wiki.postgresql.org/wiki/Streaming_Replication to set up the replication.

        Appreciate your help

Regards

         



Re: Fwd: postgres 9.0.4 Streaming related question ..

From
Ben Chobot
Date:
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
replicationafter 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
canrecover them from an archive), then the answer is yes. 

Re: Fwd: postgres 9.0.4 Streaming related question ..

From
akp geek
Date:
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.