> > 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