public inbox for [email protected]
help / color / mirror / Atom feedUsing FDW to connect to a more recent postgres version?
2+ messages / 2 participants
[nested] [flat]
* Using FDW to connect to a more recent postgres version?
@ 2024-10-12 20:33 Koen De Groote <[email protected]>
2024-10-12 20:35 ` Re: Using FDW to connect to a more recent postgres version? Tom Lane <[email protected]>
0 siblings, 1 reply; 2+ messages in thread
From: Koen De Groote @ 2024-10-12 20:33 UTC (permalink / raw)
To: PostgreSQL General <[email protected]>
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Using FDW to connect to a more recent postgres version?
2024-10-12 20:33 Using FDW to connect to a more recent postgres version? Koen De Groote <[email protected]>
@ 2024-10-12 20:35 ` Tom Lane <[email protected]>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2024-10-12 20:35 UTC (permalink / raw)
To: Koen De Groote <[email protected]>; +Cc: PostgreSQL General <[email protected]>
Koen De Groote <[email protected]> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-10-12 20:35 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-12 20:33 Using FDW to connect to a more recent postgres version? Koen De Groote <[email protected]>
2024-10-12 20:35 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox