From: | Volkan Unsal <spocksplanet(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Melvin Davidson <melvin6925(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: no pg_hba.conf entry for replication connection from host |
Date: | 2015-04-09 20:14:53 |
Message-ID: | CAMcqKmmfZuVSWAH4v2b+GTxuO02beMSV=2ydfNS6cbDFkgxtvQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Oops. I used a dummy IP address in the yml file for privacy reasons. The
actual IP addresses would be placed there in my setup. The pg_basebackup
connection to the MASTER_PORT_5432_TCP_ADDR is successful, so I know that
slave can connect to the master at least. But it just cannot open a
streaming backup connection...
On Thu, Apr 9, 2015 at 4:11 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:
> On 04/09/2015 01:00 PM, Volkan Unsal wrote:
>
>> Hi Adrian,
>>
>> 1) What version(s) of Postgres are you using on either end?
>>
>>
>> I'm using Postgres 9:3.
>>
>>
>> 2) Are the primary and the standby in different containers?
>>
>>
>> Yes, and they are on different servers as well.
>>
>> 3) What is the container/machine/network layout?
>>
>>
>> I created a gist of all the files in my setup.
>>
>> https://gist.github.com/volkanunsal/ad2173e2649393fcd3b6
>>
>> The init-slave.sh and init-master.sh scripts are executed before the
>> server is started, so that's where I do all my preprocessing of conf
>> files. I checked the results and the substituted values are indeed
>> correct.
>>
>
>
> Well if I am understanding. This:
>
> primary_conninfo = 'host=${MASTER_PORT_5432_TCP_ADDR} port=5432
>
> is getting translated to:
>
> host=0.0.0.0 port=5432
>
> Now the primary can receive connections from 0.0.0.0, which basically
> means it can receive from the Internet. The problem is that the standby can
> not connect to 0.0.0.0, that would mean it is connecting to the whole
> Internet. You will need to provide either the actual IP for the primary or
> its hostname.
>
>
>
>>
>>
>>
>>
>>
>> --
>> *Volkan Unsal*
>> /web and mobile development/
>> volkanunsal.com <http://bit.ly/1h1ebjy>
>>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
--
*Volkan Unsal*
*web and mobile development*
volkanunsal.com <http://bit.ly/1h1ebjy>
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-04-09 20:32:14 | Re: no pg_hba.conf entry for replication connection from host |
Previous Message | Adrian Klaver | 2015-04-09 20:11:13 | Re: no pg_hba.conf entry for replication connection from host |