This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 12%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
We created a single server postgresql and a flexible server postgresql that single server can not connect to flexible server via postgres_fdw and get the following message when I run "IMPORT FOREIGN SCHEMA public LIMIT TO ( abc_test ) FROM SERVER server_name INTO public".
Query 1 ERROR: ERROR: could not connect to server "server_name"
DETAIL: could not connect to server: Network is down (0x00002742/10050)
Is the server running on host "host.name" (xxx.xx.xx.xx) and accepting
TCP/IP connections on port 5432?
I confirmed that both of the firewalls were set to 0.0.0.0 - 255.255.255.255 and also checked "Allow access to Azure services".
I also found the flexible server can use postgre_fdw to connect to the single server.
Is there any solution for it?
@fyzhu_henk Thanks for the ask and for using the Microsoft Q&A platform.
Can you please share the script you have used? so I can better assist you.
Regrds
Geetha
Yes, there are the following 4 scripts.
It works If two PostgreSQL servers are single servers. If one server is flexible and another one is single, the single one can not use postgres_fdw to connect to the flexible one.
@fyzhu_henk yes you are right, I tried to reproduce the issue and I got the same error as you got, currently I am checking with the internal product team and provide you with more details.
Regards
Geetha
Hi, @fyzhu_henk Thanks for your patience, I got a confirmation from the engineering team that this scenario is not supported and you should upgrade the existing Single Server PG to Flexible and try FDW between flex to flex.
Please let me know if this information is helpful.
Regards
Geetha
Hi, @fyzhu_henk We haven't heard back from you. Just wanted to check if you find the above reply useful. If yes, do click on the 'Mark as answer' link in the above reply. This will help other community members facing similar queries to refer to this solution.
Regards
Geetha
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 63%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGR%3C/text%3E%3C/svg%3E)
Sorry, but this is hardly a satisfying answer. I'm in a same situation. I tried FDW from Flexi to Single, that works. Is scenario for FDW from Single to Flexi still not supported? If not, will be in future? If not, is there a workaround other than migrating to Flexi (yes, migrating, not upgrading as stated above, there's actually no "upgrade" path)?
Thanks in advance for answers.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 90%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Completely agree - would like to get an answer to your questions. Especially with the sunsetting of Single Server in 2025, this is a hefty limitation.
At a minimum, there should be a warning somewhere in the docs that mentioned this limitation. Instead we get a large banner that says this is possible with absolutely no mention of an exception for flexible server.