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.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>         <mailto:adrian.klaver@aklaver.__com
>         <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>         <mailto:adrian.klaver@aklaver.__com
>         <mailto:adrian.klaver@aklaver.com>>
>
>
>
>
>         --
>         *Volkan Unsal*
>         /web and mobile development/
>         volkanunsal.com <http://volkanunsal.com> <http://bit.ly/1h1ebjy>
>
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>
>
>
> --
> *Volkan Unsal*
> /web and mobile development/
> volkanunsal.com <http://bit.ly/1h1ebjy>


--
Adrian Klaver
adrian.klaver@aklaver.com