public inbox for [email protected]help / color / mirror / Atom feed
Logical replication without direct link between publisher and subscriber? 3+ messages / 2 participants [nested] [flat]
* Logical replication without direct link between publisher and subscriber? @ 2024-09-09 14:36 Koen De Groote <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Koen De Groote @ 2024-09-09 14:36 UTC (permalink / raw) To: PostgreSQL General <[email protected]> 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 ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Logical replication without direct link between publisher and subscriber? @ 2024-09-11 13:19 Greg Sabino Mullane <[email protected]> parent: Koen De Groote <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Greg Sabino Mullane @ 2024-09-11 13:19 UTC (permalink / raw) To: Koen De Groote <[email protected]>; +Cc: PostgreSQL General <[email protected]> > > 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? How about using WAL shipping to populate a replica, and either query that directly or use that as the publisher to your sequestered node? Cheers, Greg ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Logical replication without direct link between publisher and subscriber? @ 2024-09-12 18:47 Koen De Groote <[email protected]> parent: Greg Sabino Mullane <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Koen De Groote @ 2024-09-12 18:47 UTC (permalink / raw) To: Greg Sabino Mullane <[email protected]>; +Cc: PostgreSQL General <[email protected]> I've considered it, but it sounds like a lot of work and failure prone. Even projects like Debezium seem like it's a ton to set up. Thanks for the suggestions. Regards, Koen On Wed, Sep 11, 2024 at 3:20 PM Greg Sabino Mullane <[email protected]> wrote: > 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? > > > How about using WAL shipping to populate a replica, and either query that > directly or use that as the publisher to your sequestered node? > > Cheers, > Greg > > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-09-12 18:47 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-09-09 14:36 Logical replication without direct link between publisher and subscriber? Koen De Groote <[email protected]> 2024-09-11 13:19 ` Greg Sabino Mullane <[email protected]> 2024-09-12 18:47 ` Koen De Groote <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox