Re: Postgres replication question :- One master 2 slaves 9.0.10

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

regards

On Mon, Sep 30, 2013 at 11:10 PM, Chris Travers <chris(dot)travers(at)gmail(dot)com>wrote:

>
>
>
> On Mon, Sep 30, 2013 at 7:14 PM, akp geek <akpgeek(at)gmail(dot)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.
> http://www.efficito.com/learn_more.shtml
>