Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

On Thu, Apr 9, 2015 at 4:32 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxx
<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>

        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.klaver@xxxxxxxxxxx <mailto:adrian.klaver@aklaver.com>




--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http://bit.ly/1h1ebjy>


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx



--
Volkan Unsal
web and mobile development

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux