Re: no pg_hba.conf entry for replication connection from host

On 04/09/2015 01:14 PM, Volkan Unsal wrote:
> 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...

Yeah, that would have been too easy:) I am not seeing anything else at
the moment.

>
> On Thu, Apr 9, 2015 at 4:11 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto: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
> <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://volkanunsal.com> <http://bit.ly/1h1ebjy>
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
>
>
> --
> *Volkan Unsal*
> /web and mobile development/
> volkanunsal.com <http://bit.ly/1h1ebjy>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com