Postgres Pro
Downloads
Home   >   mailing lists

Thread: Using FDW to connect to a more recent postgres version?

Using FDW to connect to a more recent postgres version?

From
Koen De Groote
Date:
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

Re: Using FDW to connect to a more recent postgres version?

From
Tom Lane
Date:
Koen De Groote <kdg.dev@gmail.com> writes:
> 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?

I'd expect it to work, but it's not a scenario that we test.

            regards, tom lane