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@xxxxxxxxxxx
<mailto: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@xxxxxxxxxxx>
<mailto:adrian.klaver@aklaver.__com
<mailto:adrian.klaver@xxxxxxxxxxx>>> 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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
<mailto:adrian.klaver@aklaver.__com
<mailto:adrian.klaver@xxxxxxxxxxx>>
--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http://volkanunsal.com> <http://bit.ly/1h1ebjy>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
*Volkan Unsal*
/web and mobile development/
volkanunsal.com <http://bit.ly/1h1ebjy>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
