Re: PostgreSQL Streaming replication on two diff networks

From: Jorge Torralba <jorge(dot)torralba(at)gmail(dot)com>
To: Johannes Truschnigg <johannes(at)truschnigg(dot)info>
Cc: Pierre Ochsenbein <pierre(dot)ochsenbein(at)acceleris(dot)ch>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL Streaming replication on two diff networks
Date: 2018-06-05 14:02:39
Message-ID: CACut7uSiMoBNUyFhJyYLjJA1YT2C=5cqaSmKnhZ-NdRY03-ioQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)truschnigg(dot)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(at)truschnigg(dot)info )
>
> www: https://johannes.truschnigg.info/
> phone: +43 650 2 133337
> xmpp: johannes(at)truschnigg(dot)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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Pierre Ochsenbein 2018-06-05 14:16:05 RE: PostgreSQL Streaming replication on two diff networks
Previous Message gilberto.castillo 2018-06-05 13:44:57 Re: [MASSMAIL]Re: AWS DMS Expecting Logical Replication for Non RDS