MIME-Version: 1.0
References: <CAGbX52GXtCZL0r2daozEwJH-tcH9bScxGit5D5syzizpJNwhSQ@mail.gmail.com>
 <CAKAnmmLH0_XCsgNg=Nk_u3jZN_C=rmKFnTxvUju+HOBOjwm6iA@mail.gmail.com>
In-Reply-To: <CAKAnmmLH0_XCsgNg=Nk_u3jZN_C=rmKFnTxvUju+HOBOjwm6iA@mail.gmail.com>
From: Koen De Groote <kdg.dev@gmail.com>
Date: Thu, 12 Sep 2024 20:47:21 +0200
Message-ID: <CAGbX52G=Fo8YhJ9o1te=G9FD9Yedpk_O55rSk8PqfFwy4SEsmw@mail.gmail.com>
Subject: Re: Logical replication without direct link between publisher and subscriber?
To: Greg Sabino Mullane <htamfids@gmail.com>
Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003352f90621f08ad4"
Archived-At: <https://www.postgresql.org/message-id/CAGbX52G%3DFo8YhJ9o1te%3DG9FD9Yedpk_O55rSk8PqfFwy4SEsmw%40mail.gmail.com>
Precedence: bulk

--0000000000003352f90621f08ad4
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM 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?
>
> Cheers,
> Greg
>
>

--0000000000003352f90621f08ad4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">I&#39;ve considered it, but it sounds lik=
e a lot of work and failure prone. Even projects like Debezium seem like it=
&#39;s a ton to set up.</div><div dir=3D"ltr"><br></div><div>Thanks for the=
 suggestions.</div><div><br></div><div>Regards,</div><div>Koen<br></div><br=
><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Wed, S=
ep 11, 2024 at 3:20=E2=80=AFPM Greg Sabino Mullane &lt;<a href=3D"mailto:ht=
amfids@gmail.com">htamfids@gmail.com</a>&gt; wrote:<br></div><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex">Dumping changes periodically, sending them dire=
ctly or uploading to cloud storage and then downloading and applying them o=
n the subscriber side.<br>But maybe there&#39;s a simpler option someone he=
re knows about?</blockquote><div><br></div><div>How about using WAL shippin=
g to populate a replica, and either query that directly or use that as the =
publisher=C2=A0to your sequestered node?</div><div><br></div><div>Cheers,</=
div><div>Greg</div><div><br></div></div>
</blockquote></div></div>

--0000000000003352f90621f08ad4--