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.kla...@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 >> >> 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.kla...@aklaver.com > -- *Volkan Unsal* *web and mobile development* volkanunsal.com <http://bit.ly/1h1ebjy>
