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

Поиск
Список
Период
Сортировка
От akp geek
Тема Re: Postgres replication question :- One master 2 slaves 9.0.10
Дата
Msg-id CACnhOfLhwmUcGa=HkV6p4+NHPqt2EOSM9DOyZOoRtPU2NyVv-g@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Postgres replication question :- One master 2 slaves 9.0.10  (akp geek <akpgeek@gmail.com>)
Ответы Re: Postgres replication question :- One master 2 slaves 9.0.10
Список pgsql-general
Дерево обсуждения
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@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

regards


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



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.


В списке pgsql-general по дате отправления: