Re: PostgreSQL Streaming replication on two diff networks - Mailing list pgsql-admin

From Jorge Torralba
Subject Re: PostgreSQL Streaming replication on two diff networks
Date
Msg-id CACut7uSiMoBNUyFhJyYLjJA1YT2C=5cqaSmKnhZ-NdRY03-ioQ@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL Streaming replication on two diff networks  (Johannes Truschnigg <johannes@truschnigg.info>)
Responses RE: PostgreSQL Streaming replication on two diff networks  (Pierre Ochsenbein <pierre.ochsenbein@acceleris.ch>)
List pgsql-admin
>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 sites
fixed (which is probably going to need some kind of VPN solution).<

You are correct. But,  I am assuming all routing, vpn's, iptables etc are configured since it is a known network to the user.  He will still need entrie in pg_hba.conf.

JT

On Tue, Jun 5, 2018 at 6:43 AM, Johannes Truschnigg <johannes@truschnigg.info> wrote:
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 sites
fixed (which is probably going to need some kind of VPN solution).

--
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.



--
Thanks,

Jorge Torralba
----------------------------

Note: This communication may contain privileged or other confidential information. If you are not the intended recipient, please do not print, copy, retransmit, disseminate or otherwise use the information. Please indicate to the sender that you have received this email in error and delete the copy you received. Thank You.

pgsql-admin by date:

Previous
From: gilberto.castillo@etecsa.cu
Date:
Subject: Re: [MASSMAIL]Re: AWS DMS Expecting Logical Replication for Non RDS
Next
From: Pierre Ochsenbein
Date:
Subject: RE: PostgreSQL Streaming replication on two diff networks