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 1fQCFp-0001ic-12 for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 13:44:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fQCFn-0006ch-TW for pgsql-admin@arkaria.postgresql.org; Tue, 05 Jun 2018 13:44:03 +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 1fQCFn-0006Xq-E4 for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 13:44:03 +0000 Received: from truschnigg.info ([78.46.103.228]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fQCFk-00065X-AO for pgsql-admin@lists.postgresql.org; Tue, 05 Jun 2018 13:44:02 +0000 Received: from vault.lan (84-112-34-152.cable.dynamic.surfer.at [84.112.34.152]) (Authenticated sender: colo) by truschnigg.info (Postfix) with ESMTPSA id 1AFEB403FA; Tue, 5 Jun 2018 15:43:57 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=truschnigg.info; s=mail; t=1528206237; bh=278WW+7I3qSIAs2xShLZiT6GGYAbzRKfXcyNqbyhQAU=; h=Date:From:To:Cc:Subject:References:In-Reply-To:From; b=1yWNy50Yk/2HAPzafMWiymyPwavK2/9J9p012VDtbxGtAIMDBnB/+9GsnuVN2sKFw vkCCWoXPtQJ5OpBkZG5jjodPkKqrwmOvyta2g4UNCYLvZ9uuO9a9FTqIpj+icgKGyi 0f7Qz5JSNI8y2/SnxYDt90CY7xvx4xY+VLdXtWOc= Date: Tue, 5 Jun 2018 15:43:55 +0200 From: Johannes Truschnigg To: Jorge Torralba Cc: Pierre Ochsenbein , pgsql-admin@lists.postgresql.org Subject: Re: PostgreSQL Streaming replication on two diff networks Message-ID: <20180605134355.omxjwp7rnc5yia6u@vault.lan> References: <1528204459993.51275@acceleris.ch> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="lgbhl3c6rkt6e2ha" Content-Disposition: inline In-Reply-To: User-Agent: NeoMutt/20170113 (1.7.2) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --lgbhl3c6rkt6e2ha Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Tue, Jun 05, 2018 at 06:39:42AM -0700, Jorge Torralba wrote: > It's all about the pg_hba.conf :) No; not if there's not even basic IP connectivity between the participating hosts. Pierre will have to make sure he gets the routing between the two si= tes fixed (which is probably going to need some kind of VPN solution). --=20 with best regards: - Johannes Truschnigg ( johannes@truschnigg.info ) www: https://johannes.truschnigg.info/ phone: +43 650 2 133337 xmpp: johannes@truschnigg.info Please do not bother me with HTML-email or attachments. Thank you. --lgbhl3c6rkt6e2ha Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEGu9IhkI+7/aKLUWF95W3jMsYfLUFAlsWk5YACgkQ95W3jMsY fLWKgg/+M6V3zO9KXlcHu/ncxRWWLAjcmC3UuG3+4NIM8xYTZ3t11OTNsm8H3RnK QevbiozZJGGqH1X7fasCxvi+aM9KZBexx8cx5QOZ/pkBg6kEdVR8SOaz7HHth1wg D0U7yrRi2RY33P9wl0GE7DlY9Q0GW0T2DbA05V8oehMRiG394VswccntU+dw5u2a y7FTXi/KkKaT3MVxz0geZ2Dk3t5TrTNpyA9Atw6cU+ad9WjPKjTgNnfwjhibH4Xz 3Jmwsl2t0DtKmwlY5DgOYoeXe5SYNHV/KXzztTWT37p/kV53Z9Oc+bpCQX2FlugF GvFc+i5aZVFTLFkRId9WmZHmk8N4MgtJeuT3IpSd3N2wiq6qiScIn3prm8wTEiAq CrHJj1fbmQkBUokY2k7/7vRtEQEu7fxT2I6yEzu6JRxpiID8uE+HP5vV7nWz80FF hvY1akMfc1XFsS0Wx9elHEhhVweOMLE7O9MoFuzVLyC6V5+heS91PAWkDQIOmw+o Z1KX0kEJ7L7u2OhZE/hEnOBHAXgGlXLJJl17FZR6iJfK9pbounGmZXluC+W6Hi18 clNjZikuvO3CbNH6GZILiZGu7aA1QsxqezuINPKNAfxSb7uAKRGIHCM1JJIh7FuL IVTB7UqyxgGM4UJQu9nGbFXpNoaVQvkpQBJwNpAyKvrl4Whbm2w= =Ub+v -----END PGP SIGNATURE----- --lgbhl3c6rkt6e2ha--