MIME-Version: 1.0
From: Koen De Groote <kdg.dev@gmail.com>
Date: Mon, 9 Sep 2024 16:36:26 +0200
Message-ID: <CAGbX52GXtCZL0r2daozEwJH-tcH9bScxGit5D5syzizpJNwhSQ@mail.gmail.com>
Subject: Logical replication without direct link between publisher and subscriber?
To: PostgreSQL General <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002cbe0c0621b0af13"
Archived-At: <https://www.postgresql.org/message-id/CAGbX52GXtCZL0r2daozEwJH-tcH9bScxGit5D5syzizpJNwhSQ%40mail.gmail.com>
Precedence: bulk

--0000000000002cbe0c0621b0af13
Content-Type: text/plain; charset="UTF-8"

I want to have a PG instance receive logical replication from a publisher.

However, the subscriber should not have network access to the publisher, in
any way. This is for security reasons. No VPN or any setup that allows the
subscriber to send traffic to the publisher host.

The publisher, however, can reach the subscriber IP and send traffic to it.

Is there a way to start a logical replication setup without having the
subscriber create a subscription? Run a few commands on the publisher and
the subscriber suddenly starts receiving data?

From what I've googled, an option would be to use pgrecvlogical:
https://www.postgresql.org/docs/current/app-pgrecvlogical.html

Dumping changes periodically, sending them directly or uploading to cloud
storage and then downloading and applying them on the subscriber side.

But maybe there's a simpler option someone here knows about?

Any help and/or suggestions appreciated.

Thanks,
Koen

--0000000000002cbe0c0621b0af13
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I want to have a PG instance receive logical replication f=
rom a publisher.<div><br></div><div>However, the subscriber should not have=
 network access to the publisher, in any way. This is for security reasons.=
 No VPN or any setup that allows the subscriber to send traffic to the publ=
isher host.</div><div><br></div><div>The publisher, however, can reach the =
subscriber IP and send traffic to it.</div><div><br></div><div>Is there a w=
ay to start a logical replication setup without having the subscriber creat=
e a subscription? Run a few commands on the publisher and the subscriber su=
ddenly starts receiving data?</div><div><br></div><div>From what I&#39;ve g=
oogled, an option would be to use=C2=A0pgrecvlogical:=C2=A0<a href=3D"https=
://www.postgresql.org/docs/current/app-pgrecvlogical.html">https://www.post=
gresql.org/docs/current/app-pgrecvlogical.html</a></div><div><br></div><div=
>Dumping changes periodically, sending them directly or uploading to cloud =
storage and then downloading and applying them on the subscriber side.</div=
><div><br></div><div>But maybe there&#39;s a simpler option someone here kn=
ows about?</div><div><br></div><div>Any help and/or suggestions appreciated=
.</div><div><br></div><div>Thanks,</div><div>Koen</div></div>

--0000000000002cbe0c0621b0af13--