MIME-Version: 1.0
From: Koen De Groote <kdg.dev@gmail.com>
Date: Sat, 12 Oct 2024 22:33:16 +0200
Message-ID: <CAGbX52GRfowPTnhWRZZM8bBUuco3=cPLK0zBLG+AwXtpfydHBQ@mail.gmail.com>
Subject: Using FDW to connect to a more recent postgres version?
To: PostgreSQL General <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001658ad06244d840d"
Archived-At: <https://www.postgresql.org/message-id/CAGbX52GRfowPTnhWRZZM8bBUuco3%3DcPLK0zBLG%2BAwXtpfydHBQ%40mail.gmail.com>
Precedence: bulk

--0000000000001658ad06244d840d
Content-Type: text/plain; charset="UTF-8"

The documentation speaks only of compatibility in terms of connecting to
older version:

> postgres_fdw can be used with remote servers dating back to PostgreSQL
8.3. Read-only capability is available back to 8.1.

But what about connecting to a foreign server that is more recent? Like
pg14 connecting to pg17?

Are the considerations in that case simply with new data types not being
recognized? Or are there cases where the setup can be done, but queries
won't behave as expected?

Regards,
Koen De Groote

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

<div dir=3D"ltr"><div>The documentation speaks only of compatibility in ter=
ms of connecting to older version:</div><div><br></div><div>&gt;=20
<code>postgres_fdw</code> can be used with remote servers dating back to <s=
pan>PostgreSQL</span> 8.3. Read-only capability is available back to 8.1. <=
br></div><div><br></div><div>But what about connecting to a foreign server =
that is more recent? Like pg14 connecting to pg17?</div><div><br></div><div=
>Are the considerations in that case simply with new data types not being r=
ecognized? Or are there cases where the setup can be done, but queries won&=
#39;t behave as expected?</div><div><br></div><div>Regards,</div><div>Koen =
De Groote<br></div></div>

--0000000000001658ad06244d840d--