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 <htamf...@gmail.com> 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 > >
