From: Ray Stell <stellr@vt.edu>
To: pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL Streaming replication on two diff networks
Date: Tue, 5 Jun 2018 09:25:13 -0400
Message-ID: <9d7591c3-5c2d-4412-ddf4-2f874a43e412@vt.edu> (raw)
In-Reply-To: <BYAPR11MB2663EE57770AEF7BEAF396E3A7660@BYAPR11MB2663.namprd11.prod.outlook.com>
References: <1528204459993.51275@acceleris.ch>
<BYAPR11MB2663EE57770AEF7BEAF396E3A7660@BYAPR11MB2663.namprd11.prod.outlook.com>
On 6/5/18 9:19 AM, Scott Whitney wrote:
>
> Sure, but you need to be able to reach it.
>
>
> You need to be able to ping/ssh between the 2 hosts first.
>
>
>
> ------------------------------------------------------------------------
> *From:* Pierre Ochsenbein <pierre.ochsenbein@acceleris.ch>
> *Sent:* Tuesday, June 5, 2018 8:14 AM
> *To:* pgsql-admin@lists.postgresql.org
> *Subject:* PostgreSQL Streaming replication on two diff networks
>
> Dear securtiy support,
>
>
> I want to deploy a PostgreSQL Cluster with streaming replication, but
> I have a problem..
>
>
> We have two VMs in two different data-centers with two different network.
>
>
> It's possible to made a streaming replication with two different network?
>
>
> My output :
>
>
> vm01:10.1.24.13
>
> vm02:10.0.2.67
>
>
> On my slave (vm02) :
>
> I can't make a pg_basebackup..
>
>
> pg_basebackup: could not connect to server: could not connect to
> server: No route to host
>
need to get with your sysadmin, "No route to host" is a good thing,
really, 10. is not routable. You need to be sending to an interface
that can be reached:
https://www.arin.net/knowledge/address_filters.html
According to standards set forth in Internet Engineering Task Force
(IETF) documentRFC-1918 <http://tools.ietf.org/html/rfc1918;, the
following IPv4 address ranges have been reserved by the IANA for private
internets, and are/not/publicly routable on the global internet:
* *10.0.0.0/8 IP addresses:*10.0.0.0 -- 10.255.255.255
*
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: stellr@vt.edu, pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL Streaming replication on two diff networks
In-Reply-To: <9d7591c3-5c2d-4412-ddf4-2f874a43e412@vt.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox