Using FDW to connect to a more recent postgres version?

From: Koen De Groote <kdg(dot)dev(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Using FDW to connect to a more recent postgres version?
Date: 2024-10-12 20:33:16
Message-ID: CAGbX52GRfowPTnhWRZZM8bBUuco3=cPLK0zBLG+AwXtpfydHBQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2024-10-12 20:35:50 Re: Using FDW to connect to a more recent postgres version?
Previous Message Thomas Munro 2024-10-12 19:16:04 Re: Naive question about multithreading/multicore