public inbox for [email protected]  

help / color / mirror / Atom feed

From: Koen De Groote <[email protected]>
To: PostgreSQL General <[email protected]>
Subject: Logical replication without direct link between publisher and subscriber?
Date: Mon, 9 Sep 2024 16:36:26 +0200
Message-ID: <CAGbX52GXtCZL0r2daozEwJH-tcH9bScxGit5D5syzizpJNwhSQ@mail.gmail.com> (raw)

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

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Logical replication without direct link between publisher and subscriber?
  In-Reply-To: <CAGbX52GXtCZL0r2daozEwJH-tcH9bScxGit5D5syzizpJNwhSQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox