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 <htamfids@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?