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

On 04/09/2015 01:34 PM, Volkan Unsal wrote:
> Thanks for giving it a shot, Adrian. I'm scouring the Postgres source
> code looking for some inspiration around the error message "database
> system was interrupted". Let me know if you can think of anything else.

Not sure that is a problem as the logs show the database reaching a
consistent state:

LOG: consistent recovery state reached at 0/E0000F0

The only I have left at the moment is removing the CONNECTION LIMIT on
the replication user. Also setting up logging connects/disconnects on
the primary to see if an attempt is even being made.

>
> On Thu, Apr 9, 2015 at 4:32 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>
> 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>
> <mailto: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>
>
> <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://volkanunsal.com> <http://bit.ly/1h1ebjy>
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)__com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
>
>
>
>
> --
> *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