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

One more thing.. pardon me for being dumb

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(at)gmail(dot)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
>
> 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
>>
>
>