Re: Logical replication without direct link between publisher and subscriber?

From: Greg Sabino Mullane <htamfids(at)gmail(dot)com>
To: Koen De Groote <kdg(dot)dev(at)gmail(dot)com>
Cc: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Logical replication without direct link between publisher and subscriber?
Date: 2024-09-11 13:19:37
Message-ID: CAKAnmmLH0_XCsgNg=Nk_u3jZN_C=rmKFnTxvUju+HOBOjwm6iA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Greg Sabino Mullane 2024-09-11 13:24:16 Re: Database schema for "custom fields"
Previous Message Greg Sabino Mullane 2024-09-11 12:57:17 Re: Ghost data from failed FDW transactions?