Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQC1X-0000NK-0q for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 13:29:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQC1W-0005We-4b for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 13:29:18 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQBxn-0008Gf-2N for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 13:25:27 +0000 Received: from omr2.cc.ipv6.vt.edu ([2607:b400:92:8400:0:33:fb76:806e] helo=omr2.cc.vt.edu) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQBxi-0005dt-Tf for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 13:25:25 +0000 Received: from mr5.cc.vt.edu (junk.cc.ipv6.vt.edu [IPv6:2607:b400:92:9:0:9d:8fcb:4116]) by omr2.cc.vt.edu (8.14.4/8.14.4) with ESMTP id w55DPLgZ006841 for ; Tue, 5 Jun 2018 09:25:21 -0400 Received: from mail-qt0-f199.google.com (mail-qt0-f199.google.com [209.85.216.199]) by mr5.cc.vt.edu (8.14.7/8.14.7) with ESMTP id w55DPFhK025996 for ; Tue, 5 Jun 2018 09:25:20 -0400 Received: by mail-qt0-f199.google.com with SMTP id t24-v6so2293398qtn.7 for ; Tue, 05 Jun 2018 06:25:20 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:references:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=I6Ztmmj+Eafih2zqC+weWV7cK9c2xNun2D5TbRwFEwA=; b=evTu+jzyKSfJ9ulPFghZ9uJNAYvKuxOWWSCVpU+qK2OpHn2WSxNoi8FHg/Cs1Y/OUW 6YXhmMnIQm1gfboHBHttc+Ve1kONqAuPzeC+Wa7QJeUr0GIr/yddp6uC9t0pAV3LrSLM POvbmRrIENUUAi/ct1HenTN+WcdImdMhbgNQiXD9WC6OV5l6Xym4e6LMIDBeu9hrXCp5 swddrgN7+rzBijVgRYSjGHpNUqG0Ym/RhK9L/wVfDCNxPOsRbXbZUXnWY8TzREaTqO3B fweymx3jpW9EY1Af8LjdSjQHibOQdLSmrlQSpjoch4oYrH3oU4J7MsiZPFrG1CKL6DK5 tcUg== X-Gm-Message-State: APt69E1ke9tebB+Na1PO4lRjpEvHkHvs7xHZn5IOnb4ylGqWm8N+cMfg B1B+sirmSPN68swiJlbhaPVovjgJaLPlfOeY0R7hiz5/3qGOaHzwoLOsqJKJP0SpUQsDyUqE/v5 H1Zp6kRu6qeVFU06R3nEeyajmB8tTrXj3L/lTHXCErclf3gF3rmg1aG39BWwvZrm3aEXpy3o9J0 PHMXF83trw X-Received: by 2002:a0c:d0eb:: with SMTP id b40-v6mr16070999qvh.236.1528205115503; Tue, 05 Jun 2018 06:25:15 -0700 (PDT) X-Google-Smtp-Source: ADUXVKIWUU4z73yM5WWNa6wDSw/+7kf5Orvt2xu3uFI84QWNCZDiUKkzxIQ3017PaggvwS5N+zteNw== X-Received: by 2002:a0c:d0eb:: with SMTP id b40-v6mr16070983qvh.236.1528205115289; Tue, 05 Jun 2018 06:25:15 -0700 (PDT) Received: from stell.cns.vt.edu (stell.cns.ipv6.vt.edu. [2001:468:c80:2102:200:94ff:fe7a:a104]) by smtp.gmail.com with ESMTPSA id s186-v6sm34251271qkb.53.2018.06.05.06.25.14 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 05 Jun 2018 06:25:14 -0700 (PDT) From: Ray Stell X-Google-Original-From: Ray Stell Subject: Re: PostgreSQL Streaming replication on two diff networks To: pgsql-admin@lists.postgresql.org References: <1528204459993.51275@acceleris.ch> Message-ID: <9d7591c3-5c2d-4412-ddf4-2f874a43e412@vt.edu> Date: Tue, 5 Jun 2018 09:25:13 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:52.0) Gecko/20100101 Thunderbird/52.8.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------23728FD5D73C00077A9EC37F" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------23728FD5D73C00077A9EC37F Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit 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 > *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 , 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 * --------------23728FD5D73C00077A9EC37F Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit



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) document RFC-1918, 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


--------------23728FD5D73C00077A9EC37F--