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 1fQBnB-0007fg-Gm for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 13:14:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQBnA-0007Q1-GK for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 13:14:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQBnA-0007PT-9B for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 13:14:28 +0000 Received: from smtp.kmu4u.ch ([213.221.202.48]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQBn5-0007eL-Qs for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 13:14:27 +0000 X-Virus-Scanned: Debian amavisd-new at smtp.kmu4u.ch X-Spam-Flag: NO X-Spam-Score: -1.9 X-Spam-Level: X-Spam-Status: No, score=-1.9 required=4 tests=[BAYES_00=-1.9, HTML_MESSAGE=0.001, NO_RECEIVED=-0.001, NO_RELAYS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled From: Pierre Ochsenbein To: "pgsql-admin@lists.postgresql.org" Subject: PostgreSQL Streaming replication on two diff networks Thread-Topic: PostgreSQL Streaming replication on two diff networks Thread-Index: AQHT/M8E+PCURdZG5EaX/+IkgMdSTQ== Date: Tue, 5 Jun 2018 13:14:20 +0000 Message-ID: <1528204459993.51275@acceleris.ch> Accept-Language: fr-FR, en-US, de-CH Content-Language: fr-FR x-ms-exchange-transport-fromentityheader: Hosted Content-Type: multipart/alternative; boundary="_000_152820445999351275accelerisch_" MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --_000_152820445999351275accelerisch_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear securtiy support, I want to deploy a PostgreSQL Cluster with streaming replication, but I hav= e 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 Is the server running on host "10.1.24.13" and accepting TCP/IP connections on port 5432? pg_basebackup: removing data directory "/var/lib/pgsql/10/data" [root@vm02 ~]# tcptraceroute 10.1.24.13 5432 traceroute to 10.1.24.13 (10.1.24.13), 30 hops max, 60 byte packets 1 gateway (192.168.1.1) 0.375 ms 0.304 ms 0.282 ms 2 169.254.95.213 (169.254.95.213) 0.261 ms 0.241 ms 0.198 ms 3 10.0.2.1 (10.0.2.1) 1.761 ms 2.725 ms 3.449 ms 4 172.16.9.41 (172.16.9.41) 1.141 ms 172.16.9.33 (172.16.9.33) 1.190 ms= 172.16.9.41 (172.16.9.41) 1.642 ms 5 172.16.9.50 (172.16.9.50) 0.388 ms 172.16.9.54 (172.16.9.54) 0.367 ms= 172.16.9.62 (172.16.9.62) 0.430 ms 6 10.1.23.4 (10.1.23.4) 0.227 ms 0.388 ms 0.345 ms 7 10.1.23.4 (10.1.23.4) 0.298 ms !X 0.384 ms !X 0.326 ms !X pg_hba.conf file on my master : # replication privilege. local replication all peer host replication all 127.0.0.1/32 ident host replication all ::1/128 ident host replication replicate 10.0.2.67/32 scram-sha-256 Thank you so much for your help Best regards, Pierre [Acceleris] Acceleris AG | cloudifying IT Pierre Ochsenbein | Technical Consultant Schosshaldenstrasse 85 | CH-3006 Bern T : +41 31 911 33 22 | F : +41 31 911 62 63 pierre.ochsenbein@acceleris.ch | www.acceleris.ch Acceleris Offices are in : Bern | Zurich | Renens | Bucharest [Acceleris] Disclaimer This message possibly contains confidential data or items of information. I= t is intended solely for the rightful recipient. If you should have receive= d the message wrongfully, it is not permitted to disclose the e-mail messag= e or its contents to third parties, to copy or use it. We would respectfull= y request you to destroy the message with the exclusion of any reproduction= and to notify this to the originator by e-mail. Thank you very much. --_000_152820445999351275accelerisch_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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
   =  Is the server running on host "10.1.24.13" and accepting
   =  TCP/IP connections on port 5432?
pg_basebackup= : removing data directory "/var/lib/pgsql/10/data"<= /p>


[root@vm02 ~]# tcptraceroute 10.1.24.13 5432
traceroute to 10.1.24.13 (10.1.24.13), 30 hops max, 60 byte packets
 1  gateway (192.168.1.1)  0.375 ms  0.304 ms  = 0.282 ms
 2  169.254.95.213 (169.254.95.213)  0.261 ms  0.241= ms  0.198 ms
 3  10.0.2.1 (10.0.2.1)  1.761 ms  2.725 ms  3.= 449 ms
 4  172.16.9.41 (172.16.9.41)  1.141 ms 172.16.9.33 (172.= 16.9.33)  1.190 ms 172.16.9.41 (172.16.9.41)  1.642 ms
 5  172.16.9.50 (172.16.9.50)  0.388 ms 172.16.9.54 (172.= 16.9.54)  0.367 ms 172.16.9.62 (172.16.9.62)  0.430 ms
 6  10.1.23.4 (10.1.23.4)  0.227 ms  0.388 ms  = 0.345 ms
 7  10.1.23.4 (10.1.23.4)  0.298 ms !X  0.384 ms !X&= nbsp; 0.326 ms !X



pg_hba.conf file on my master :

# replication privilege.
local   replication     all   =             &nb= sp;            =          peer
host    replication     all  &= nbsp;          127.0.0.1/32&nb= sp;           ident
host    replication     all  &= nbsp;          ::1/128 &n= bsp;            = ;   ident
host    replication     replicate &= nbsp;     10.0.2.67/32      sc= ram-sha-256



Thank you so much for your help


Best regards,

Pierre



3D"Acceleris"

Accele= ris AG | cloudifying IT
Pierre Ochsenbein | Technical Consultant
Schosshaldenstrasse 85 | CH-3006 Bern
T : +41 31 911 33 22 | F : +41 31 911 62 63
pierre.ochsenbein@acceleris.ch | www.acceleris.ch  

Acceleris Offices are in :
Bern | Zurich | Renens | Bucharest
 
3D"Acceleris"
 

Disclaimer

This message possibly contains confidential data or items of information. I= t is intended solely for the rightful recipient. If you should have receive= d the message wrongfully, it is not permitted to disclose the e-mail messag= e or its contents to third parties, to copy or use it. We would respectfully request you to destroy the messag= e with the exclusion of any reproduction and to notify this to the originat= or by e-mail. Thank you very much.





--_000_152820445999351275accelerisch_--