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

From: Chris Travers <chris(dot)travers(at)gmail(dot)com>
To: akp geek <akpgeek(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres replication question :- One master 2 slaves 9.0.10
Date: 2013-10-01 03:10:11
Message-ID: CAKt_ZfuwW3EoTOQc5LVGasnbr4_Stt9CT0fY9W1w65RSbE4MFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jayadevan M 2013-10-01 12:21:31 Re: logging statements in PostgreSQL
Previous Message akp geek 2013-10-01 02:14:53 Postgres replication question :- One master 2 slaves 9.0.10