I want to set the 2 nd slave as HOT STAND BY, not steaming ..
What would be steps.
on the primary I will have the archive_command
on the slave in the recover.conf , restore_command.
After I make my slave as exactly as master, How can the slave gets the files from master ( HOT STAND BY ).. master has trusted connection(ssh ) with slave.
Thanks a lot for the help.
On Tue, Oct 1, 2013 at 10:14 AM, akp geek <akpgeek@gmail.com> wrote:
it is a firewall issue. they can't open the port that we requested it.
so as you mentioned tunnel to the primary via tunnel. will give that a try
On Mon, Sep 30, 2013 at 7:14 PM, akp geek <akpgeek@gmail.com> wrote:
Hi all -
Currently we have set up one master one slave , which working fine. Now we need to replicate to an other slave. The problem we have , the port that we use on primary can not be reached from the new slave. We can't the change the primary port also, because many applications using it.
I can't reach out to my primary using the recovery.conf on the new slave.
Can you suggest how I can handle this? Appreciate your help.
Why can't you reach it? Is it a firewall?
if so basically you have two options. The first is you can configure your firewall to allow the connection. The second is you can tunnel through using another port/service like SSH or IPSec ESP.
Best Wishes,
Chris Travers
Regards
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor lock-in.