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@xxxxxxxxx>
Date: Wed, Dec 7, 2011 at 9:03 AM
Subject: postgres 9.0.4 Streaming relate question ..
To: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Hi All -
From: akp geek <akpgeek@xxxxxxxxx>
Date: Wed, Dec 7, 2011 at 9:03 AM
Subject: postgres 9.0.4 Streaming relate question ..
To: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
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