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
