Fwd: postgres 9.0.4 Streaming related question ..
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
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 slaveWill 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.
Thanks , it worked
On Wed, Dec 7, 2011 at 12:01 PM, Ben Chobot <bench@silentmedia.com> wrote:
Show quoted text
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 setup1. If I shutdown the primary
2. Shutdown the slave
3. start Primary
4. start slaveWill 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.